Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/censusreporter/census-postgres

PostgreSQL schema and import scripts for recent US Census data
https://github.com/censusreporter/census-postgres

ensure UTF-8 in fixed CSV

1fdb71ef10780b8eaff6c6dc054d16af6eaa3b05 authored 10 months ago by Joe Germuska <[email protected]>
create indexes when creating tables

c634f9349d605c623f07b3ac4d97188744a46698 authored 11 months ago by Joe Germuska <[email protected]>
Make geoid name column longer

dbde842e0dec1d2e10a8d1194a128e07a2368b31 authored about 1 year ago by Ian Dees <[email protected]>
Use correct drop table query

2d6da23f68ab4cbd8c97595f75bd404647e65048 authored about 1 year ago by Ian Dees <[email protected]>
Use the correct geoheader tables

8b043a63846a62887e45f8292401682ef2afb61e authored about 1 year ago by Ian Dees <[email protected]>
Add acs2022 5yr scripts

908728acdf49b9420fc13962bf8a80e28dc89ce1 authored about 1 year ago by Ian Dees <[email protected]>
Copy/paste error on drop table

f2381f1cbaeb2148c7f15fbfc58b255904fdf835 authored over 1 year ago by Ian Dees <[email protected]>
Can't use NUMERIC postgres type, since it is represented as strings in Python

cd51558c4e0cceffc6f322a37d6e02d7cfc8a270 authored over 1 year ago by Ian Dees <[email protected]>
Fix typo in the drop schema tables script

67428a23c2ebf127bfc0b9847cdc498b68d8223d authored over 1 year ago by Ian Dees <[email protected]>
Not using _tables suffix

10efbf79589b9eba2dc89ef41102f4caa425a553 authored over 1 year ago by Ian Dees <[email protected]>
Not using _tables suffix

6ab5a30898d78a21e033885b2c7ee142ebf271de authored over 1 year ago by Ian Dees <[email protected]>
Add scripts for acs2022_1yr

07d6fddb0065dfb801b0c791e7edfebcf4dd76d4 authored over 1 year ago by Ian Dees <[email protected]>
Use argparse in the build_table_based_sql script

5c413b5437d292f4026ee5e0184ec17288bc71db authored over 1 year ago by Ian Dees <[email protected]>
Move the fix_geoids script to meta-scripts where the other scripts are

504e06b97bafc58c1afc72ad06726eb977746533 authored over 1 year ago by Ian Dees <[email protected]>
Rename the file that handles table-based releases to match existing scripst

a8548473e7a7ea265e4738727de53436d27ffdad authored over 1 year ago by Ian Dees <[email protected]>
rename

e9e21c4718edb80a789e0849889cc3fa6e287e35 authored over 1 year ago by Joe Germuska <[email protected]>
try another way to drop tables

7e99ab5452c362c72f7bfa33ca75e8c22e70aee4 authored over 1 year ago by Joe Germuska <[email protected]>
drop tables the hard way

84af62e3022d272c2f4c0d6ae059634aa1805c8d authored over 1 year ago by Joe Germuska <[email protected]>
try dropping a different way

e037427ec701f4203a050fad3f014b1d43e08b5a authored over 1 year ago by Joe Germuska <[email protected]>
drop tables the hard way

284bacd67894c939c10cb64fe8f827c8ec8899da authored over 1 year ago by Joe Germuska <[email protected]>
fix merge

1dd9fa5bdbcf9aca444f6bba023d073f1a79bbdd authored over 1 year ago by Joe Germuska <[email protected]>
have to fix geoheaders too.

759bd2cb0b517ff3d666662954ff9d32fd4bb5e2 authored over 1 year ago by Joe Germuska <[email protected]>
have to fix geoheaders too

798afe6adb6c7b8895e59b9f294d096cab494990 authored over 1 year ago by Joe Germuska <[email protected]>
create tool to rewrite geoids from 7-char prefix to 5-char to align with CR practice

c18f06be196d9c03aae47a38fab5f89e153cb4d9 authored over 1 year ago by Joe Germuska <[email protected]>
skip technical tables; minor cleanup

be41cc8c255004ea0a6f0d28ab9709d0b4aaf7fa authored over 1 year ago by Joe Germuska <[email protected]>
who needs tech tables

80a71611a91fc5582cd1742cf17952ad4b4fcb0d authored over 1 year ago by Joe Germuska <[email protected]>
whoops handle label-only rows for views too

0a374fa895a2dde963e5688d85d9aed6c670be3b authored over 1 year ago by Joe Germuska <[email protected]>
try all numeric maybe that's easier

5171ce38939debd2f4668c7b3e94581ec31e292d authored over 1 year ago by Joe Germuska <[email protected]>
whoops wrong table for bigint values

61c1ba583d2ae40d7a9d2c231a769d3812c32acc authored over 1 year ago by Joe Germuska <[email protected]>
technical tables don't have MOE

b9ea4498f2ddcb4593e8c2cd156ad3646a4b8333 authored over 1 year ago by Joe Germuska <[email protected]>
account for large value in B08013 and switch data type

55cf927013d1af1817b6bcf0ba2fe38db48dcd5e authored over 1 year ago by Joe Germuska <[email protected]>
account for non-variable rows in table shell data

6da0eac30c6f9c6e8d19f8524abe1b71c665d65d authored over 1 year ago by Joe Germuska <[email protected]>
fix typo

c67b632b4e487e68267269ecc4834c4afde4ca9b authored over 1 year ago by Joe Germuska <[email protected]>
WIP on table-based summary files

48020de36995eff3d6581ed249c093f12db9540e authored over 1 year ago by Joe Germuska <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-postgres

c697a90c7fb1c1f804d9087c19a2ffffc856d05f authored over 1 year ago by Joe Germuska <[email protected]>
add geoid primary key

14bc176ca4c9ff6f4c331b2119535785c8c9a139 authored over 1 year ago by Joe Germuska <[email protected]>
Add acs2021 5yr

c06ae9a6cbb69f388b3faea1404a6ec22ffc9a36 authored about 2 years ago by Ian Dees <[email protected]>
Add 2021 5yr to the build_sql_files.py script

8eed3280589ae8906d2e86ca130a5c3e0cd1ca37 authored about 2 years ago by Ian Dees <[email protected]>
More _moe suffix fixes for 21 1-year

4c5605f64a4e0b669742432d099a40fd840dbff2 authored about 2 years ago by Ian Dees <[email protected]>
Fixing DROP TABLE cleanup for temp sequence tables

29d5efbf57f7fbb208b27f20d86a44edd3e73062 authored about 2 years ago by Ian Dees <[email protected]>
Add ACS 2021 1yr

912c996792dd27358717652405f6055240c7664f authored about 2 years ago by Ian Dees <[email protected]>
Add acs2021 1yr

22f4a0246c4ad8a7a6d539c2955f697369218868 authored about 2 years ago by Ian Dees <[email protected]>
Use real instead of double-precision when generating sequence tables

5fdc5f22f8144b7d90c59276e5cbfb1ac3494711 authored almost 3 years ago by Ian Dees <[email protected]>
Add drops after using a temp sequence table to save space

99acf520b52e565e402ac71980f41e66abea7826 authored almost 3 years ago by Ian Dees <[email protected]>
Merge pull request #16 from censusreporter/add-2020

Add 2020 5yr

e61f1882e30c9fd77d419206f6718d0382d292b6 authored almost 3 years ago by Ian Dees <[email protected]>
Add 2020 5yr postgres scripts

d0c15f6b8ce26779c2c77873b444a1346b9999f5 authored almost 3 years ago by Ian Dees <[email protected]>
Add acs2020 5yr to build script

d7aae8e416449f14810c72bd690cec1e9a94c8b3 authored almost 3 years ago by Ian Dees <[email protected]>
testing 2020

fe1a27073777021fe59ed2fe6e4be54e5a9aeed3 authored over 3 years ago by Joe Germuska <[email protected]>
remove stray commas

c7d78e3ccc5dcfc434f1bea59e0ec70f15fae580 authored over 3 years ago by Joe Germuska <[email protected]>
tweaking

038007f545ddaf34ddb0e3cd76cb6ed365a6c770 authored over 3 years ago by Joe Germuska <[email protected]>
add or replace for debugging

5174a355cc012ba4b27fcd47b5542849b933d7c2 authored over 3 years ago by Joe Germuska <[email protected]>
cleanup syntax

8d344a819812f28f43b3d59d7f40d5b4f98e9508 authored over 3 years ago by Joe Germuska <[email protected]>
WIP on 2020 redistricting

a4e1f57ee3fa3f427b98adf9e279f67607065692 authored over 3 years ago by Joe Germuska <[email protected]>
support for loading 2010 redistricting data

bd37a60891dd46fb93407a07581c3e79d87c87d8 authored over 3 years ago by Joe Germuska <[email protected]>
add ordering prefix to SQL scripts

886c02c7cb9326c5e3fb59b54c256538ee762193 authored over 3 years ago by Joe Germuska <[email protected]>
Add .DS_Store to gitignore

70192b6edb0588a19f02100bde3f24c8269aeadb authored about 4 years ago by Ian Dees <[email protected]>
Fix typo in file name

0a6f7d7fdea3866aaa3b39d51417926242a917bf authored about 4 years ago by Ian Dees <[email protected]>
Add ACS 2019 5-year setup scripts

d1a7a8c51e11922fcf3ed3016f1a5c7caf92b744 authored about 4 years ago by Ian Dees <[email protected]>
Python 3 support

b8936b9f9624f8317c152a3e642824a8677df49b authored about 4 years ago by Ian Dees <[email protected]>
Add 2019 5yr config

12b220c233e46663eb1302d0a129edca86648e40 authored about 4 years ago by Ian Dees <[email protected]>
Add 2019 1-yr release

d9753115e61c71ebfac027ec86cb85736288b30a authored about 4 years ago by Ian Dees <[email protected]>
Add 2019 1-yr configuration

5013095e3c3d76103626e469b3e07c8ed9b86127 authored about 4 years ago by Ian Dees <[email protected]>
Remove duplicate geoheader COPY lines for 18/5

c6e41586f53e2cc76b5cfc74e6ef621822189125 authored almost 5 years ago by Ian Dees <[email protected]>
Name needs to be longer for 18 5yr

1ad6b25f8dcb0eec6e5c6b5fc5f0ce033567c343 authored almost 5 years ago by Ian Dees <[email protected]>
blank4 -> zcta5

77ebe07ddc0b8bf7e2953e8c7419feca815be8d5 authored almost 5 years ago by Ian Dees <[email protected]>
Fix temp geoheader copy/paste error

0e2a38ca80568e16072ab183571e0f12770fede8 authored almost 5 years ago by Ian Dees <[email protected]>
Add 2018 5yr SQL

a5726729652d152bb41614fdd361de6a922fcc5b authored almost 5 years ago by Ian Dees <[email protected]>
Add config for 2018 5yr

2576c232935d287361ac82d90726058728b280a6 authored almost 5 years ago by Ian Dees <[email protected]>
Geoheader comment for zcta5

6b62e8e1ef9558de940ea6acfb442dc046befd04 authored about 5 years ago by Ian Dees <[email protected]>
Adjust geoheader parser for 2018

b561ec8bca94ec787027ae0358da94ecf7731b9a authored about 5 years ago by Ian Dees <[email protected]>
Add ACS 2018 1yr table data

173e414188a7ffca5d2e1204984ab417ab5a3ebd authored about 5 years ago by Ian Dees <[email protected]>
Adding 2018 config to build sql files

66a91acde814a3eb7d3dd695d416f2d2faa8667c authored about 5 years ago by Ian Dees <[email protected]>
Add 2017 5-year SQL

62242aa19c3b0125d9136aedaf9691468feddeb2 authored about 6 years ago by Ian Dees <[email protected]>
Add the 17 5-year sql configuration

6f5e9ad0c9c11457a24e3137362109358695a8b3 authored about 6 years ago by Ian Dees <[email protected]>
Add the 2017 1-yr SQL

6b38742f18375637432f7e38b4c8698f3b7acb08 authored over 6 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-postgres

11d2fd5df514d6e07ef32dc8c628474d54d7631d authored over 6 years ago by Ian Dees <[email protected]>
Adding the 2017-1yr info for building sql

ac338cf6a6c8aa7f9b07e804982abdb6b36b64c0 authored over 6 years ago by Ian Dees <[email protected]>
Merge pull request #12 from censusreporter/add-license-1

Create LICENSE

2777a0588699b0afe44a5fa69ce402ad8b4f13e6 authored over 6 years ago by Ian Dees <[email protected]>
Create LICENSE

6e90a637b5db676d9dce8ebea15aedbc3b6617f8 authored over 6 years ago by Ian Dees <[email protected]>
Add 2016 5yr metadata

48c05f720235a8fa9d3b04692745ff1addd50fa5 authored almost 7 years ago by Ian Dees <[email protected]>
Add 2016 5yr config

f1864d2caa010baf21e42301ca34f58f65aad8f6 authored almost 7 years ago by Ian Dees <[email protected]>
Add ACS 2016 1yr metadata

ddab8a03bc8195c6752831d27f04dbf09a1876b4 authored over 7 years ago by Ian Dees <[email protected]>
Add 2016 to the build-sql-files script

a1bdf4931ba2fc2b9bdfcba5c7d99b2954770040 authored over 7 years ago by Ian Dees <[email protected]>
Add 2015 5yr scripts

ef769cf4a4ef23ab7b6ad69a84bbe2d4d8934488 authored about 8 years ago by Ian Dees <[email protected]>
Add config for 2015

4cbdd5ce959a170ae2b5e3ec63d31eb3af9f2a30 authored about 8 years ago by Ian Dees <[email protected]>
Add acs2015_1yr built scripts

41f6ab9fa2743eecbbf6bc73c17c95f941bbad7b authored over 8 years ago by Ian Dees <[email protected]>
Add acs 2014 5yr

c44c63bbfec00fc976e920e95cc7f236d9f9a410 authored about 9 years ago by Ian Dees <[email protected]>
Add 2014 5-yr to build_sql_files

05ce3783dba8dfdd4bc85c8ef946f6b02c2b3132 authored about 9 years ago by Ian Dees <[email protected]>
Add acs2014 1yr release

9e0b6131fc2e7c48e49d3bab49c7768a48903e1d authored over 9 years ago by Ian Dees <[email protected]>
Add acs2014 1yr

2739bb2d05bf1aeb720652be529490d2df7087e9 authored over 9 years ago by Ian Dees <[email protected]>
Merge pull request #7 from grant-humphries/master

Addition to Accomodate ACS2013_5yr Schema, Other Small Improvements

d3bd2fd795c366a7ab2a6e6631ba66e57872bc53 authored almost 10 years ago by Ian Dees <[email protected]>
Added and modified files such that the ACS2013_5yr can be built using the metascripts, modified functions so that data product specific information is no longer hard coded within them and updated to the readme to improve ease of execution

1ee3b46a728f2fb3b07463f66ec79d8fb21565d8 authored almost 10 years ago by grant-humphries <[email protected]>
Duplicate geography data somehow?

08e908f41f5d340449a89902b8aea2eea29caefc authored about 10 years ago by Ian Dees <[email protected]>
Adding ACS 2013 5yr schema

40e20bacd0d46c9047f8f0099398edb399c73546 authored about 10 years ago by Ian Dees <[email protected]>
Add config data for 2013 5yr

bf431721c7d40615712a62176a310cfcee84a916 authored about 10 years ago by Ian Dees <[email protected]>
Re-ran with the correct(?) metadata.

184c5c1212f97f4d66d39a812157c5faf6c93797 authored about 10 years ago by Ian Dees <[email protected]>
Add acs2013_3yr postgres stuff

acfd72bc2b8fec9090444f1285959394c5a4db71 authored about 10 years ago by Ian Dees <[email protected]>
Fix the header names

8c878ca7ff5804f21a8ceffa6fedf94cac014af4 authored about 10 years ago by Ian Dees <[email protected]>
Add beginning of ACS 2013 3-yr info

77d639eadaddf8e38b85207c2af57bb87f232565 authored about 10 years ago by Ian Dees <[email protected]>
Add 2013 1yr stuff

4a788af9495812247b53b176bf77822f881a5b26 authored over 10 years ago by Ian Dees <[email protected]>