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

Try to keep the order of the data from the database instead of inverting it.

github.com/censusreporter/census-api - 9fb14486dcb8628105b40c2f4fa3fa7170129c86 authored about 11 years ago by Ian Dees <[email protected]>
Let the view specify sort order for census_names.

github.com/censusreporter/census-api - e7bc056f445863cbee508244ce7ede939fa8856a authored about 11 years ago by Ian Dees <[email protected]>
Drop the census_names view before trying to add it.

github.com/censusreporter/census-postgres-scripts - 3fa9ded4765d7d6c710f579c0e8b12dc247ca3f8 authored about 11 years ago by Ian Dees <[email protected]>
Don't index block names for now because it takes too darn long.

github.com/censusreporter/census-postgres-scripts - 8c127b2d0a24fa9be9c4de6b316b5a212d887175 authored about 11 years ago by Ian Dees <[email protected]>
Use the full text search column for geo search.

github.com/censusreporter/census-api - 63991630abe6e07992900baf73bd32372d2936d8 authored about 11 years ago by Ian Dees <[email protected]>
Move the tiger indexing stuff to a separate SQL script and execute it.

github.com/censusreporter/census-postgres-scripts - 4d11f24efdb0457f59baa451e0b97485c3518848 authored about 11 years ago by Ian Dees <[email protected]>
slidey menu at narrow widths

github.com/censusreporter/censusreporter - 043b5e18315912358d8325c80b2be59715303d5d authored about 11 years ago by Ryan Pitts <[email protected]>
move fonts into imports in primary css

github.com/censusreporter/censusreporter - 6fc6f6a06204f300922833f74315a7e3922ed1f4 authored about 11 years ago by Ryan Pitts <[email protected]>
support 2012 1-year, for Joe and everyone!

github.com/censusreporter/censusreporter - 27231f25ab5ae0b7f4e44438366af0e02f3ad6cc authored about 11 years ago by Ryan Pitts <[email protected]>
allow rowcounts endpoint to take multiple years

github.com/censusreporter/census-api - 1d622753dbc8726760ec9d0600162efe467812d8 authored about 11 years ago by Ryan Pitts <[email protected]>
add optional qualifier for profile data from different release

github.com/censusreporter/censusreporter - 6f792fc3cfa9010047a0eac4a39a4a64f67d21f2 authored about 11 years ago by Ryan Pitts <[email protected]>
add get_data_fallback method for when requested release doesn't have data for geography

github.com/censusreporter/census-api - 18910aa3e6ee94dda06b387dee6c9fdf4d51cfff authored about 11 years ago by Ryan Pitts <[email protected]>
disable the slippy on narrow-screen maps

github.com/censusreporter/censusreporter - 71e794e88dff4be0a02f37c25aa9dd6a95f8d520 authored about 11 years ago by Ryan Pitts <[email protected]>
add space around some hyphens for label breaks

github.com/censusreporter/census-api - 5051261670e02cd02272e0d56cd6a963235beb3f authored about 11 years ago by Ryan Pitts <[email protected]>
unify some inner workings of query bar vs. comparison builder

github.com/censusreporter/censusreporter - cb10c4ed0f84096f6bc704aaef70fa8013dc1e08 authored about 11 years ago by Ryan Pitts <[email protected]>
Missed a couple spots where child_geoids wasn't used.

github.com/censusreporter/census-api - 6a2b1a8b41a726b3f42dc100e228274bc13c1ebc authored about 11 years ago by Ian Dees <[email protected]>
Pop the geoid off the results from the database data views.

github.com/censusreporter/census-api - cdc6197f02a226f995a364bb61a702c558c9746b authored about 11 years ago by Ian Dees <[email protected]>
Sequence number is not needed for table metadata now.

github.com/censusreporter/census-api - b573536f17fdfb9a5f98ab38dad72609e86956a0 authored about 11 years ago by Ian Dees <[email protected]>
Switch to using geoid instead of stusab,logrecno.

github.com/censusreporter/census-api - 1529d9becb4239f48b83f7c579a1ab56c055956a authored about 11 years ago by Ian Dees <[email protected]>
fix map vs. cover profile spacing at tablet width

github.com/censusreporter/censusreporter - de5b771a72506acf2f305765356e79d118d7fab8 authored about 11 years ago by Ryan Pitts <[email protected]>
Add acs2012 1yr to the api.py stuff.

github.com/censusreporter/census-api - 75073ffad3d79af63d57aa1ce6b0c757b2cd7859 authored about 11 years ago by Ian Dees <[email protected]>
block groups in county comparison enabled

github.com/censusreporter/censusreporter - 585f49f43419d3e64c5d84c1f5c08577e0637a24 authored about 11 years ago by Ryan Pitts <[email protected]>
tweak data release line

github.com/censusreporter/censusreporter - 1fc0888bd17f291d972e77d213db2ee25a2ba755 authored about 11 years ago by Ryan Pitts <[email protected]>
profile page uses "latest" API endpoint to get best possible data

github.com/censusreporter/censusreporter - d696712f36e733ed741a8f31af87b93f541cfbda authored about 11 years ago by Ryan Pitts <[email protected]>
classier handling of top of profile page at narrower widths

github.com/censusreporter/censusreporter - 9c46eae97913f1aecb7e05fe21ba28f7b48a6d2a authored about 11 years ago by Ryan Pitts <[email protected]>
automatic legend re-positioning when pie charts get too narrow

github.com/censusreporter/censusreporter - c5d9830dee9e525d17d575905e0e458ed16d0494 authored about 11 years ago by Ryan Pitts <[email protected]>
Fix some of the tiger indexing steps.

github.com/censusreporter/census-postgres-scripts - 1e766c619f217de2cac89c0f0c40af43e04c7c89 authored about 11 years ago by Ian Dees <[email protected]>
Fix ragged CSV ends and set the psql password correctly.

github.com/censusreporter/census-postgres-scripts - c1a8cefb6e1afda7f5f706c15b7fef43d114b242 authored about 11 years ago by Ian Dees <[email protected]>
Correct the tiger directory name.

github.com/censusreporter/census-postgres-scripts - 802359fca61925e3e1b4efa59ead8ec2d39ce677 authored about 11 years ago by Ian Dees <[email protected]>
Improve the hierarchy and deal with wide tables better.

github.com/censusreporter/census-table-metadata - f7830da9b313e93a36afcc507839efae6a30f034 authored about 11 years ago by Ian Dees <[email protected]>
Keep the heirarchy around until the table_id changes, then write it out.

github.com/censusreporter/census-table-metadata - 250256acfbfadf489b651a64ad15bb4e8a4d48c6 authored about 11 years ago by Ian Dees <[email protected]>
Drop the duplicate tables.

github.com/censusreporter/census-table-metadata - 28a0db0ed4dab92f2d1bde14347b6e2fe86da030 authored about 11 years ago by Ian Dees <[email protected]>
Was deduping with the wrong table ID.

github.com/censusreporter/census-table-metadata - 01fedd9a4f6bdb61686d1c5428d61f069c9b1ff0 authored about 11 years ago by Ian Dees <[email protected]>
Add/drop the 2012 1yr metadata too.

github.com/censusreporter/census-table-metadata - 6a94fd7139f858035c1680e1c9ea172779370f91 authored about 11 years ago by Ian Dees <[email protected]>
Remove the duplicate tables from the 07 and 08 table metadata.

github.com/censusreporter/census-table-metadata - 8677b428eb21839106e7682d4181714c1a1625eb authored about 11 years ago by Ian Dees <[email protected]>
Dedupe table IDs for the merge file.

github.com/censusreporter/census-table-metadata - 4e779adc1139a33c9f95e288796e4edd6052bb2f authored about 11 years ago by Ian Dees <[email protected]>
Sequence number can't be part of the primary key.

github.com/censusreporter/census-table-metadata - df6bf7f29351366eae30c3753f4dbb1d7438901a authored about 11 years ago by Ian Dees <[email protected]>
Add 2012 1yr table metadata.

github.com/censusreporter/census-table-metadata - d3559f5eb2b0061133b638a3786f2258cfd3f19b authored about 11 years ago by Ian Dees <[email protected]>
Removing sequence number from the precomputed data.

github.com/censusreporter/census-table-metadata - 88ea00c86b530aca7746c69009744a39a90108f1 authored about 11 years ago by Ian Dees <[email protected]>
Manually remove C07202, C07203, and C05001 from insertion step.

github.com/censusreporter/census-postgres - a5be381bcc14361021d223d5f27830bd7f22eede authored about 11 years ago by Ian Dees <[email protected]>
Manually remove C07202 and C07203 from sequence 175 of 2009 1yr.

github.com/censusreporter/census-postgres - ea51c434c98d08d426f4e155c5711daf8f7c78c9 authored about 11 years ago by Ian Dees <[email protected]>
Manually remove C05001 from sequence 169 because it doesn't exist in the data.

github.com/censusreporter/census-postgres - ef49eb7c156de3e140c37d8b9519ac9b19106b26 authored about 11 years ago by Ian Dees <[email protected]>
Manually fix the 2007 release geoheaders.

github.com/censusreporter/census-postgres - a9452ede1bd5fa2f2a599ff306d55ab8896e7473 authored about 11 years ago by Ian Dees <[email protected]>
Manually fix 2007 1yr's extra column in sequence 141.

github.com/censusreporter/census-postgres - 3af38e49e89c5885541b3c4bd843f6002bcfde81 authored about 11 years ago by Ian Dees <[email protected]>
Add a script that fixes broken 2007 CSV data.

github.com/censusreporter/census-postgres - d91da4fd54ea2cc6d3e0d1b4c4bc8d16dfecb366 authored about 11 years ago by Ian Dees <[email protected]>
Manually add blank rows to the 2007 1yr import tables.

github.com/censusreporter/census-postgres - 332d6b7817c05c85d855139aba32aae90e1a15e8 authored about 11 years ago by Ian Dees <[email protected]>
Manually fix 2008 3yr typo.

github.com/censusreporter/census-postgres - 097c2cce65ba9738ecab3abcac41a316aa76f3b7 authored about 11 years ago by Ian Dees <[email protected]>
Manually fixing B25010 in 2008_3yr.

github.com/censusreporter/census-postgres - cf01375dbb7a45925c15a210e43f2395a38a0a3d authored about 11 years ago by Ian Dees <[email protected]>
Manually fix the geoheader columns since 2008 is slightly different.

github.com/censusreporter/census-postgres - 3391276a1edcf03ced5845cdb22f80992dfdb1c9 authored about 11 years ago by Ian Dees <[email protected]>
better maths on the pie charts

github.com/censusreporter/censusreporter - 4a380eb43a3c72882623bf6df55800bea830ceb4 authored about 11 years ago by Ryan Pitts <[email protected]>
Manually fix the incorrectly-labeled B25010 table columns.

github.com/censusreporter/census-postgres - 226184bb43ac4400648e5f36f166bd1e74751d04 authored about 11 years ago by Ian Dees <[email protected]>
Manually fix the incorrectly-labeled B23020 table columns.

github.com/censusreporter/census-postgres - e3660dc47e33c7ac8225e9e346c26dfef2f5fab4 authored about 11 years ago by Ian Dees <[email protected]>
convert pie chart legends to html elements

github.com/censusreporter/censusreporter - d9a18e190e5f5d90442bb47ec9d3eb775edb915c authored about 11 years ago by Ryan Pitts <[email protected]>
After expanding all this stuff, we don't need to keep it around.

github.com/censusreporter/census-postgres-scripts - 656894a3023aa8528bb311b87126f98ecee60734 authored about 11 years ago by Ian Dees <[email protected]>
Don't include the duplicate geoheader files.

github.com/censusreporter/census-postgres - 03a69bfa6d217baf83663475657d1d22b7acad08 authored about 11 years ago by Ian Dees <[email protected]>
pie chart responsive fix was in the column breaks all along

github.com/censusreporter/censusreporter - 4d168f98a0178debe17fbb7e9b35c2e6106695e9 authored about 11 years ago by Ryan Pitts <[email protected]>
convert pie chart center labels from svg text to html elements

github.com/censusreporter/censusreporter - 83ad5382ec23e38e19607217c1df86209dcc571a authored about 11 years ago by Ryan Pitts <[email protected]>
more consisent container naming for charts

github.com/censusreporter/censusreporter - 0e962d8f59fd68a0d409163470844b94379d8436 authored about 11 years ago by Ryan Pitts <[email protected]>
take svg completely out of column charts, except when rendering y axis

github.com/censusreporter/censusreporter - dccd69a098073c811e0a956625e2a376d15bff84 authored about 11 years ago by Ryan Pitts <[email protected]>
turn column chart category labels into HTML elements

github.com/censusreporter/censusreporter - 2b66ba79c64f8f14d79f0979b7be074bc8a6fc3c authored about 11 years ago by Ryan Pitts <[email protected]>
gracefully convert column charts to bar charts depending on browser width

github.com/censusreporter/censusreporter - 1137b78d67c1f793a96e968cccd7ed25a5c861d9 authored about 11 years ago by Ryan Pitts <[email protected]>
add bar chart option to charts js

github.com/censusreporter/censusreporter - fcfeae65fe249aa947b0c971b7ee8ce087c1af74 authored about 11 years ago by Ryan Pitts <[email protected]>
convert chart titles to html elements, handle positioning accordingly

github.com/censusreporter/censusreporter - 639dd72079b8e63e1ee7a89f47aed7fefcc68f58 authored about 11 years ago by Ryan Pitts <[email protected]>
add birth rate row

github.com/censusreporter/censusreporter - 99ce4317952148ab8fcf07a8c11879b41b8bcc5c authored over 11 years ago by Ryan Pitts <[email protected]>
oops naming conflict

github.com/censusreporter/census-api - e09823353356eb566368a3d5235178e6e4004035 authored over 11 years ago by Ryan Pitts <[email protected]>
calculate birth rate in standard per 1000 fashion

github.com/censusreporter/census-api - 10237c2eeae33e6b39a4a2d41e5d8a71b64ffe62 authored over 11 years ago by Ryan Pitts <[email protected]>
add birth rate by age

github.com/censusreporter/census-api - 7be469dc580ba0e593df207ab4899031e06e4687 authored over 11 years ago by Ryan Pitts <[email protected]>
add family types with children

github.com/censusreporter/census-api - 7d26041f0fcb1da84b19fb72e34ae7660cac3329 authored over 11 years ago by Ryan Pitts <[email protected]>
add marital status by sex

github.com/censusreporter/census-api - ab7eeab0e91700e4f7ebf13eae1ff96bd378daed authored over 11 years ago by Ryan Pitts <[email protected]>
clean up some stuff to make responsive version better

github.com/censusreporter/censusreporter - 923d2d2698a5cafeff1a15b1bd0f62f5fd3906e2 authored over 11 years ago by Ryan Pitts <[email protected]>
add place of birth row

github.com/censusreporter/censusreporter - 1b0c66f8803a37e21587d4707c016f8582256b16 authored over 11 years ago by Ryan Pitts <[email protected]>
add place of birth distribution data

github.com/censusreporter/census-api - c678955540db186b4a488085017a2134ef4ca29d authored over 11 years ago by Ryan Pitts <[email protected]>
swap order of veteran service data

github.com/censusreporter/census-api - 44c3c6deebc82fab74e3bf87619ed37dba0fec8d authored over 11 years ago by Ryan Pitts <[email protected]>
clean up v1 profile page

github.com/censusreporter/censusreporter - 18ccb591417025af48bb65e146f8abfe7970d2fd authored over 11 years ago by Ryan Pitts <[email protected]>
default remove y axis from scaled percentage column charts

github.com/censusreporter/censusreporter - e7074e8fcb5eebcce2b6a964f65b200a21ba2121 authored over 11 years ago by Ryan Pitts <[email protected]>
add veterans bar

github.com/censusreporter/censusreporter - 8ca99d8096aabaeb8be9de0031dfa908d5fb78e4 authored over 11 years ago by Ryan Pitts <[email protected]>
shorter war names

github.com/censusreporter/census-api - 266b66f620861282abf45ebae7425e5163904386 authored over 11 years ago by Ryan Pitts <[email protected]>
tweak veteran category names

github.com/censusreporter/census-api - 42c5f7283b47268de22a69e39744322f348ae149 authored over 11 years ago by Ryan Pitts <[email protected]>
add veteran service, veterans by sex

github.com/censusreporter/census-api - b6ba3ee5c3546e3210df743d60efbcc060aa5b27 authored over 11 years ago by Ryan Pitts <[email protected]>
add language row

github.com/censusreporter/censusreporter - 749541b11f7d1db73f5810b1b76f48baa614b84d authored over 11 years ago by Ryan Pitts <[email protected]>
derp wrong column

github.com/censusreporter/census-api - 16921977e0acf21c98f53f10e00c968dda2191a5 authored over 11 years ago by Ryan Pitts <[email protected]>
add language at home for children vs. adults

github.com/censusreporter/census-api - dd34e8b4b9c0473e5f4f78481667583da452cd82 authored over 11 years ago by Ryan Pitts <[email protected]>
Widening the geoid column.

github.com/censusreporter/census-postgres - d2b4ae8ae519b373aa3d0a27206f04e59466ce86 authored over 11 years ago by Ian Dees <[email protected]>
Give the sequence tables a wider geoid column.

github.com/censusreporter/census-postgres - 70a6faa20cca6250445863a9b6073fdab33f7e25 authored over 11 years ago by Ian Dees <[email protected]>
Correct spelling mistake.

github.com/censusreporter/census-postgres - 23a251a873706550651b89d98b42b05bf7e8bdbe authored over 11 years ago by Ian Dees <[email protected]>
Make the TIGER download script more robust.

github.com/censusreporter/census-postgres-scripts - 7dc71ba789be77f3323400e54d03e49b14d5dc7c authored over 11 years ago by Ian Dees <[email protected]>
Remove duplicate view creates based on table_id.

github.com/censusreporter/census-postgres - 97b5088addef935969c8dd947bd82db591482157 authored over 11 years ago by Ian Dees <[email protected]>
add travel time and means of transport to work

github.com/censusreporter/censusreporter - 778a3f8b8b2da7e425704c17c74239c2b7bc5809 authored over 11 years ago by Ryan Pitts <[email protected]>
Getting the current sqn is a bit too cumbersome here.

github.com/censusreporter/census-postgres - 1b0c795b023ce395cb460863c297db29a7f5051d authored over 11 years ago by Ian Dees <[email protected]>
add means of transport to work

github.com/censusreporter/census-api - c2812c15f3876980320d7b26caec7bda47f46b8a authored over 11 years ago by Ryan Pitts <[email protected]>
Don't sort in-place.

github.com/censusreporter/census-postgres - 2db09b2ed6a0441590714a69d8f974f7b801d40b authored over 11 years ago by Ian Dees <[email protected]>
Fix typo

github.com/censusreporter/census-postgres - ce5278d2dab4ad22f78759526327ba8f1f009a32 authored over 11 years ago by Ian Dees <[email protected]>
Keep track of the tables we've written out so that we don't let dupes through.

github.com/censusreporter/census-postgres - 9157140a29db018be47dc4c4b82cffb0fd3f8ab1 authored over 11 years ago by Ian Dees <[email protected]>
let there be housing!

github.com/censusreporter/censusreporter - 4e98a5cd57082cce64e8cc402b5ed006a3147d45 authored over 11 years ago by Ryan Pitts <[email protected]>
add structure distribution, remove vacancy distribution

github.com/censusreporter/census-api - d87b49f526c09ab1a90d3cad071e7413cb77d16f authored over 11 years ago by Ryan Pitts <[email protected]>
add length of tenure

github.com/censusreporter/census-api - 925dd09fec81c40f20cf505ab86a105dc1949b7f authored over 11 years ago by Ryan Pitts <[email protected]>
add aggregate migration figure

github.com/censusreporter/census-api - ca07068213f866b72cef9f25eeca33b1a77393eb authored over 11 years ago by Ryan Pitts <[email protected]>
add housing vacancy distribution

github.com/censusreporter/census-api - cf2fac015e836bce89e03bf1e1f300e76edc0178 authored over 11 years ago by Ryan Pitts <[email protected]>
add occupancy distribution

github.com/censusreporter/census-api - 919446839825fbf2b32775ac5f69f88f6ab29366 authored over 11 years ago by Ryan Pitts <[email protected]>
add ownership distribution, migration distribution

github.com/censusreporter/census-api - 28fb2cd9b648f5b9d052444ad1b25a462a4c9924 authored over 11 years ago by Ryan Pitts <[email protected]>