Ecosyste.ms: OpenCollective

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

Census Reporter

Make it easier to understand Census data.
Collective - Host: opensource - https://opencollective.com/censusreporter - Website: https://censusreporter.org/ - Code: https://github.com/censusreporter

catch some more errors when building profile with missing data

github.com/censusreporter/censusreporter - 33b92d5e50feab8ff72b962c8186c7cce1cabaac authored over 1 year ago by Joe Germuska <[email protected]>
update data available note

github.com/censusreporter/censusreporter - fdd0789bdf1e8a00cbd49e9a68a5bc29c44a3cd7 authored over 1 year ago by Joe Germuska <[email protected]>
Copy/paste error on drop table

github.com/censusreporter/census-postgres - 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

github.com/censusreporter/census-postgres - cd51558c4e0cceffc6f322a37d6e02d7cfc8a270 authored over 1 year ago by Ian Dees <[email protected]>
Use TIGER 2022 for parent/child comparisons

github.com/censusreporter/census-api - 2d304d1b4e9411fe60b6a661b930d1b8a37b7e5a authored over 1 year ago by Ian Dees <[email protected]>
Add 2022 1yr ACS and TIGER 2022 data support

github.com/censusreporter/censusreporter - d35acaeee4cec4ed13340c9794e2193b41c2d8eb authored over 1 year ago by Ian Dees <[email protected]>
Add 2022 1yr ACS data support

github.com/censusreporter/census-api - 4c9fe5ca8198f4b68fa6596db582e596bfa23cf6 authored over 1 year ago by Ian Dees <[email protected]>
Use 2021 5yr data for AIANNH data index script

github.com/censusreporter/census-postgres-scripts - 48ca19ede7e81d2a997efebc30a21d9a53fb0d6f authored over 1 year ago by Ian Dees <[email protected]>
The PUMA columns all have 20 suffix instead of 10 now

github.com/censusreporter/census-postgres-scripts - 1a82d27f32d37f6e29ce1853a7deed1b445be7af authored over 1 year ago by Ian Dees <[email protected]>
The PUMA geoid columns is geoid20 now

github.com/censusreporter/census-postgres-scripts - 8fd6f08abe3dd38d84f080d5f3be17bb32ad626a authored over 1 year ago by Ian Dees <[email protected]>
Removing containment operations for geos that don't seem to exist in TIGER 2022

github.com/censusreporter/census-postgres-scripts - b78f5ad2258e31ad5cab799a48f37ca269f03309 authored over 1 year ago by Ian Dees <[email protected]>
Removing containment operations for geos that don't seem to exist in TIGER 2022

github.com/censusreporter/census-postgres-scripts - fce831126026af2fb0676dfa067979a1c9678780 authored over 1 year ago by Ian Dees <[email protected]>
Use 2021 5yr data for TIGER 2022 data index script

github.com/censusreporter/census-postgres-scripts - f79a6de7b9cd0425b9125551951e3631d0ee78d3 authored over 1 year ago by Ian Dees <[email protected]>
Fix bug in shp2pgsql generated SQL

github.com/censusreporter/census-postgres-scripts - 7c169de59e62a6a852bf52dc9b26bd95f80d94ee authored over 1 year ago by Ian Dees <[email protected]>
Fix typo in the drop schema tables script

github.com/censusreporter/census-postgres - 67428a23c2ebf127bfc0b9847cdc498b68d8223d authored over 1 year ago by Ian Dees <[email protected]>
Fix path to the fix_geoids script in both spots

github.com/censusreporter/census-postgres-scripts - 44211a36cb2367cbbfad6369cc4ea9d4daa78039 authored over 1 year ago by Ian Dees <[email protected]>
Fix path to the fix_geoids script

github.com/censusreporter/census-postgres-scripts - 6f10d124d015f9589675e2311b35a0920d18170c authored over 1 year ago by Ian Dees <[email protected]>
Not using _tables suffix

github.com/censusreporter/census-postgres - 10efbf79589b9eba2dc89ef41102f4caa425a553 authored over 1 year ago by Ian Dees <[email protected]>
Not using _tables suffix

github.com/censusreporter/census-postgres - 6ab5a30898d78a21e033885b2c7ee142ebf271de authored over 1 year ago by Ian Dees <[email protected]>
Add scripts for acs2022_1yr

github.com/censusreporter/census-postgres - 07d6fddb0065dfb801b0c791e7edfebcf4dd76d4 authored over 1 year ago by Ian Dees <[email protected]>
Use argparse in the build_table_based_sql script

github.com/censusreporter/census-postgres - 5c413b5437d292f4026ee5e0184ec17288bc71db authored over 1 year ago by Ian Dees <[email protected]>
Move the fix_geoids script to meta-scripts where the other scripts are

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

github.com/censusreporter/census-postgres - a8548473e7a7ea265e4738727de53436d27ffdad authored over 1 year ago by Ian Dees <[email protected]>
Don't try to download the stuff that isn't in TIGER 2022. Also it seems to be in UTF8 now.

github.com/censusreporter/census-postgres-scripts - ec30b30cbf99eb6dc38721a9605319998c3ab5e8 authored over 1 year ago by Ian Dees <[email protected]>
Add scripts for TIGER 2022

github.com/censusreporter/census-postgres-scripts - fce10c42ac3088fe88abcd197d431e4cdbb21766 authored over 1 year ago by Ian Dees <[email protected]>
Add scripts for 2022 1yr ACS

github.com/censusreporter/census-postgres-scripts - bd6a005178810ff6bdb824e3468938e0cbd6f1d4 authored over 1 year ago by Ian Dees <[email protected]>
Add info for acs2022_1yr release

github.com/censusreporter/census-table-metadata - ff20fdfa0963e4477df3ff23a743467a479f7d6a authored over 1 year ago by Ian Dees <[email protected]>
prepare for new table-only data.

github.com/censusreporter/census-postgres-scripts - 89df4e66b728c31d96a7b3a08f049e4ee20b7ae0 authored over 1 year ago by Joe Germuska <[email protected]>
need to create before you can load

github.com/censusreporter/census-table-metadata - dc3ae9f1adf4c7b27b520307150b4920c8668945 authored over 1 year ago by Joe Germuska <[email protected]>
log SQL for table-based metadata

github.com/censusreporter/census-table-metadata - 7ae99b4b21a7eae78ddb9f28052688e67983db14 authored over 1 year ago by Joe Germuska <[email protected]>
handle denominator column

github.com/censusreporter/census-table-metadata - 53e59448b7b2cc5d96ca8c4a79c18f566fe61646 authored over 1 year ago by Joe Germuska <[email protected]>
add strategy for making metadata from new table-based offering

github.com/censusreporter/census-table-metadata - 34497d294baaf58c190e067a2adffbabd553e622 authored over 1 year ago by Joe Germuska <[email protected]>
Merge pull request #11 from censusreporter/dependabot/pip/certifi-2022.12.7

Bump certifi from 2020.6.20 to 2022.12.7

github.com/censusreporter/census-table-metadata - 903c40003cd17f34aca9bb64496932833e4bb1df authored over 1 year ago by Joe Germuska <[email protected]>
fill in missing housing tables

github.com/censusreporter/censusreporter - e8418d657b546482a80e92c6cd17332ab22c40c0 authored over 1 year ago by Joe Germuska <[email protected]>
rename

github.com/censusreporter/census-postgres - e9e21c4718edb80a789e0849889cc3fa6e287e35 authored over 1 year ago by Joe Germuska <[email protected]>
try another way to drop tables

github.com/censusreporter/census-postgres - 7e99ab5452c362c72f7bfa33ca75e8c22e70aee4 authored over 1 year ago by Joe Germuska <[email protected]>
drop tables the hard way

github.com/censusreporter/census-postgres - 84af62e3022d272c2f4c0d6ae059634aa1805c8d authored over 1 year ago by Joe Germuska <[email protected]>
try dropping a different way

github.com/censusreporter/census-postgres - e037427ec701f4203a050fad3f014b1d43e08b5a authored over 1 year ago by Joe Germuska <[email protected]>
drop tables the hard way

github.com/censusreporter/census-postgres - 284bacd67894c939c10cb64fe8f827c8ec8899da authored over 1 year ago by Joe Germuska <[email protected]>
fix merge

github.com/censusreporter/census-postgres - 1dd9fa5bdbcf9aca444f6bba023d073f1a79bbdd authored over 1 year ago by Joe Germuska <[email protected]>
have to fix geoheaders too.

github.com/censusreporter/census-postgres - 759bd2cb0b517ff3d666662954ff9d32fd4bb5e2 authored over 1 year ago by Joe Germuska <[email protected]>
have to fix geoheaders too

github.com/censusreporter/census-postgres - 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

github.com/censusreporter/census-postgres - c18f06be196d9c03aae47a38fab5f89e153cb4d9 authored over 1 year ago by Joe Germuska <[email protected]>
skip technical tables; minor cleanup

github.com/censusreporter/census-postgres - be41cc8c255004ea0a6f0d28ab9709d0b4aaf7fa authored over 1 year ago by Joe Germuska <[email protected]>
who needs tech tables

github.com/censusreporter/census-postgres - 80a71611a91fc5582cd1742cf17952ad4b4fcb0d authored over 1 year ago by Joe Germuska <[email protected]>
whoops handle label-only rows for views too

github.com/censusreporter/census-postgres - 0a374fa895a2dde963e5688d85d9aed6c670be3b authored over 1 year ago by Joe Germuska <[email protected]>
try all numeric maybe that's easier

github.com/censusreporter/census-postgres - 5171ce38939debd2f4668c7b3e94581ec31e292d authored over 1 year ago by Joe Germuska <[email protected]>
whoops wrong table for bigint values

github.com/censusreporter/census-postgres - 61c1ba583d2ae40d7a9d2c231a769d3812c32acc authored over 1 year ago by Joe Germuska <[email protected]>
technical tables don't have MOE

github.com/censusreporter/census-postgres - b9ea4498f2ddcb4593e8c2cd156ad3646a4b8333 authored over 1 year ago by Joe Germuska <[email protected]>
account for large value in B08013 and switch data type

github.com/censusreporter/census-postgres - 55cf927013d1af1817b6bcf0ba2fe38db48dcd5e authored over 1 year ago by Joe Germuska <[email protected]>
account for non-variable rows in table shell data

github.com/censusreporter/census-postgres - 6da0eac30c6f9c6e8d19f8524abe1b71c665d65d authored over 1 year ago by Joe Germuska <[email protected]>
fix typo

github.com/censusreporter/census-postgres - c67b632b4e487e68267269ecc4834c4afde4ca9b authored over 1 year ago by Joe Germuska <[email protected]>
WIP on table-based summary files

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

github.com/censusreporter/census-postgres - c697a90c7fb1c1f804d9087c19a2ffffc856d05f authored over 1 year ago by Joe Germuska <[email protected]>
add geoid primary key

github.com/censusreporter/census-postgres - 14bc176ca4c9ff6f4c331b2119535785c8c9a139 authored over 1 year ago by Joe Germuska <[email protected]>
fix copy/paste error

github.com/censusreporter/census-api - c8d2c04c7be19cdee1000001772adda541710a80 authored over 1 year ago by Joe Germuska <[email protected]>
Merge branch 'map-update'

github.com/censusreporter/census-api - 5e3e226b5fa035b26749991e4e7f7f87cd550f49 authored over 1 year ago by Joe Germuska <[email protected]>
don't reproject every geometry, instead reproject bounding box

github.com/censusreporter/census-api - f799cdb98ea27f435335c3b43f87ac7cde981ffd authored over 1 year ago by Joe Germuska <[email protected]>
fix scheme for MVT embeds

github.com/censusreporter/censusreporter - 36c2f0b00709537656093bcb726d7e78441b1f0f authored over 1 year ago by Joe Germuska <[email protected]>
update for GA-4

github.com/censusreporter/censusreporter - 38fa1982285fae7c249cc83b1220fcc4ec571916 authored over 1 year ago by Joe Germuska <[email protected]>
Merge branch 'map-update'

github.com/censusreporter/census-api - e0e39717d0283964c8a336fd75338ed2c3c77aed authored over 1 year ago by Joe Germuska <[email protected]>
remove more leaflet references

github.com/censusreporter/censusreporter - c9c04cd19605871b057ab81c597fff17427602e8 authored over 1 year ago by Joe Germuska <[email protected]>
chart maps pretty much work

github.com/censusreporter/censusreporter - 7cad9d51fec1d9149ca97cd8bbbeac494833d4b6 authored over 1 year ago by Joe Germuska <[email protected]>
profile page updated

github.com/censusreporter/censusreporter - 7a828f7ac8927641fe11fb5c36007c61c37bf914 authored over 1 year ago by Joe Germuska <[email protected]>
support MVT tiles for profile pages

github.com/censusreporter/census-api - f315eac5924891c7dcfd4b12ee2fcf72c9532ac2 authored over 1 year ago by Joe Germuska <[email protected]>
WIP

github.com/censusreporter/censusreporter - 77d09b1e07a814ab433bd2ba8e72214b20e74e15 authored over 1 year ago by Joe Germuska <[email protected]>
create_mvt_result works

github.com/censusreporter/census-api - 565d16c2da339887155e7136fa201d39cde7f43b authored over 1 year ago by Joe Germuska <[email protected]>
Try a different query for MVT generation

github.com/censusreporter/census-api - f83620ae2547860c2f6f41b4f4697fb855bc2218 authored over 1 year ago by Ian Dees <[email protected]>
WIP on MVT for profile pages

github.com/censusreporter/census-api - 5fe08e3de6cb0bc0c52f31e1980e5e1a18683984 authored over 1 year ago by Joe Germuska <[email protected]>
WIP on MVT for profile pages

github.com/censusreporter/censusreporter - f029fc326cfd63c5d9f5d630cfa79cc33ed0ecc0 authored over 1 year ago by Joe Germuska <[email protected]>
locate seems ready with mapboxgl

github.com/censusreporter/censusreporter - bd5062c2d133117c98151292f28cf602a66a7a26 authored over 1 year ago by Joe Germuska <[email protected]>
WIP moving /locate/ to mapboxgl

github.com/censusreporter/censusreporter - 91354f044e389340f3e9dbfd1e85aef617de6ba8 authored over 1 year ago by Joe Germuska <[email protected]>
fix link to example narrative profile

github.com/censusreporter/censusreporter - 5c4f96d7e68793dbeaeb9a8ab0e6122f56c8fd50 authored almost 2 years ago by Joe Germuska <[email protected]>
updates and clarifications

github.com/censusreporter/censusreporter - e58914060deaab9c9182aa8fd2f0cb1321a46725 authored almost 2 years ago by Joe Germuska <[email protected]>
update homepage bulletin

github.com/censusreporter/censusreporter - 37affe72b1ae29295ad52ac18d7612a51a5ca690 authored almost 2 years ago by Joe Germuska <[email protected]>
add some aggregation records

github.com/censusreporter/census-api - 0bed031fc40ab0ce42734e81abd5dd48b22e9a9b authored about 2 years ago by Joe Germuska <[email protected]>
Add acs2021_5yr

github.com/censusreporter/censusreporter - 4d00648516e4bf900bd2f64922599590a521cbfe authored about 2 years ago by Ian Dees <[email protected]>
Switch to acs2021_5yr

github.com/censusreporter/census-api - 258018a3c9b6f26ed6f40de7c5fd56271e9239e8 authored about 2 years ago by Ian Dees <[email protected]>
Not sure where I got 189 from

github.com/censusreporter/census-postgres-scripts - 34e9510045ea77aa7d2fdda3c7ba63a388efb769 authored about 2 years ago by Ian Dees <[email protected]>
Adjust import scripts to match new non-EC2 instance we're using

github.com/censusreporter/census-postgres-scripts - c330c76fd176d761594551a0cafcd9ccf5a17a1d authored about 2 years ago by Ian Dees <[email protected]>
Add acs2021 5yr

github.com/censusreporter/census-postgres - c06ae9a6cbb69f388b3faea1404a6ec22ffc9a36 authored about 2 years ago by Ian Dees <[email protected]>
Add 2021 5yr to the build_sql_files.py script

github.com/censusreporter/census-postgres - 8eed3280589ae8906d2e86ca130a5c3e0cd1ca37 authored about 2 years ago by Ian Dees <[email protected]>
Add in the sequence-based-SF/ part of the URL

github.com/censusreporter/census-postgres-scripts - a7bbfbd4bea77244b2db5d285c852c86b2db445e authored about 2 years ago by Ian Dees <[email protected]>
Forgot to fix copy/paste error for 2020->2021

github.com/censusreporter/census-postgres-scripts - cfe4d6735894cef4e04115455e3f72ae7a4af5bd authored about 2 years ago by Ian Dees <[email protected]>
Add scripts for 2021 5yr ACS

github.com/censusreporter/census-postgres-scripts - 4ba7815b6341fbeae6b74a4c03489bd70e5caed7 authored about 2 years ago by Ian Dees <[email protected]>
Add info for acs2021_5yr release

github.com/censusreporter/census-table-metadata - f68b5c752aaabe2e81a6a8b472a37a08972fd86c authored about 2 years ago by Ian Dees <[email protected]>
Bump certifi from 2020.6.20 to 2022.12.7

Bumps [certifi](https://github.com/certifi/python-certifi) from 2020.6.20 to 2022.12.7.
- [Relea...

github.com/censusreporter/census-table-metadata - 349739645ba0361f0dbe57b65e7f096a54afa8cf authored about 2 years ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
update dependencies

github.com/censusreporter/nicar20-advanced-census-python - 07f118e1cca6774325cb9fbe4ba1e05a77c1f9ea authored about 2 years ago by Joe Germuska <[email protected]>
update links for GCT/R tables

github.com/censusreporter/censusreporter - 648574d763f370adf38c74e93430892c78e34bd9 authored about 2 years ago by Joe Germuska <[email protected]>
prevent Island Areas UACs from going into census_name_lookup. fixes censusreporter/censusreporter#244

github.com/censusreporter/census-postgres-scripts - 7a66993eac38c19f8bda381c01f9c31de777bfc4 authored about 2 years ago by Joe Germuska <[email protected]>
export profileData to window scope for chart embeds

github.com/censusreporter/censusreporter - 7b2296329688aae7f367a81900c535b202909539 authored about 2 years ago by Joe Germuska <[email protected]>
add a note about overlap between race and ancestry

github.com/censusreporter/censusreporter - b5fd17916b2b2ba75d73c110bb68b62ccf3976d1 authored about 2 years ago by Joe Germuska <[email protected]>
update flask send_file call to account for removal of deprecated kwarg. Fixes censusreporter/censusreporter#312

github.com/censusreporter/census-api - 239a52b9fe5ac89708aeda107c097d671ebdd604 authored about 2 years ago by Joe Germuska <[email protected]>
back out change due to pandemic issues; properly fall back to 5-year release if 1-year data is missing. Fixes censusreporter/censusreporter#311

github.com/censusreporter/census-api - 975c8609a300a46a488576fda4aa037643c24646 authored about 2 years ago by Joe Germuska <[email protected]>
update dependency versions

github.com/censusreporter/census-api - 8e222b6d2c6edfa808fe8cb08230f7c552aef1cd authored about 2 years ago by Joe Germuska <[email protected]>
fix up async issues causing problems on Safari

github.com/censusreporter/censusreporter - 207d035f3524a5504798279a72c16952c44366cd authored about 2 years ago by Joe Germuska <[email protected]>
don't load mapbox on pages that don't need it; update about text

github.com/censusreporter/censusreporter - 25368148ed4a8ea5c405ba8de46856452269659f authored about 2 years ago by Joe Germuska <[email protected]>
update aggregation metadata

github.com/censusreporter/census-api - 17233028de995bbdbc52a21b8c10dd49bb416f3b authored about 2 years ago by Joe Germuska <[email protected]>
Merge branch 'master' of github.com:censusreporter/censusreporter

github.com/censusreporter/censusreporter - f34c2538174e4d7149b896d17c64236ede45863d authored about 2 years ago by Joe Germuska <[email protected]>
switch to locally hosted fontawesome, some other tweaks to reduce page load time re fonts

github.com/censusreporter/censusreporter - e6d3d5c7cef1f6167f1678d9ec5023f3bcc1d019 authored about 2 years ago by Joe Germuska <[email protected]>