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

Unzip the downloaded 2008 files correctly.

github.com/censusreporter/census-postgres-scripts - 3f32c774ce004e71363679ec39c6022749a67938 authored over 11 years ago by Ian Dees <[email protected]>
Add the CSV versions of the sqn lookup for 2008.

github.com/censusreporter/census-postgres - 69910ccce5ca0d2e9f872cb7165f647bb974244c authored over 11 years ago by Ian Dees <[email protected]>
Add download scripts for 2008 one and three years.

github.com/censusreporter/census-postgres-scripts - 382265aa2f489e3206d605151ecb417cfdb6e4ef authored over 11 years ago by Ian Dees <[email protected]>
readme add /apps dir to path

github.com/censusreporter/censusreporter - 0e9913e8869a64276b7b05c8934ffa7de40dd42c authored over 11 years ago by Ryan Pitts <[email protected]>
you know, let's not match project and app name, for python's sake

github.com/censusreporter/censusreporter - 20b138c2f994d8ab7e1167fefab70e86decd2dab authored over 11 years ago by Ryan Pitts <[email protected]>
quick readme

github.com/censusreporter/censusreporter - 36ddce6e81fd2bb75b22336271cc51b35f35287a authored over 11 years ago by Ryan Pitts <[email protected]>
skeleton app for censusreporter public site

github.com/censusreporter/censusreporter - ddc315e30f53387572858ebf4f1ebd0e42aef960 authored over 11 years ago by Ryan Pitts <[email protected]>
Use drop sql instead of a shell script.

github.com/censusreporter/census-postgres-scripts - 559a6eca8839a7b6062b603e7a067f16eafcd0cd authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2009 5yr.

github.com/censusreporter/census-postgres - 7fabd6e458998195089f6199af95165668a6b6a4 authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2009 1yr.

github.com/censusreporter/census-postgres - ef9bfbd41b43d59a7a42dd5cf8f11cc47b140d14 authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2009 3yr.

github.com/censusreporter/census-postgres - 7f94e4cd7c008ad35cfa5ff0a26f0d2490baf9f3 authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2010 3yr.

github.com/censusreporter/census-postgres - 92c98e9ba73e70b18ca2199720f57dc10dab72cd authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2010 1yr.

github.com/censusreporter/census-postgres - f9b8926b89c256bb9c4cb6dde9c332fec8f8ab4a authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2011 1yr.

github.com/censusreporter/census-postgres - 48c3bc1df1ba6e30081b19228c29521d6592aba2 authored over 11 years ago by Ian Dees <[email protected]>
Fixing column names for 2011 3yr.

github.com/censusreporter/census-postgres - f8c337fae0817ce79b005c2faaee46927dbd19ca authored over 11 years ago by Ian Dees <[email protected]>
Add .gitignore

github.com/censusreporter/census-postgres - 0a4bab330deec7d28854a448ad3e93af1c53c2a0 authored over 11 years ago by Ian Dees <[email protected]>
Pad with 3 zeroes instead of 4 for the column names.

github.com/censusreporter/census-postgres - f3b8810005bdc4d87d24199c7a08e4fc5ac17741 authored over 11 years ago by Ian Dees <[email protected]>
add some d3 choroplething

github.com/censusreporter/census-mockups - e1236bcbca76ad1d61a7692b15efea5100aec430 authored over 11 years ago by Ryan Pitts <[email protected]>
Add totals to the age population groupings.

github.com/censusreporter/census-api - 3376f2d1a72c356e234676f038828a84ddcf25d6 authored over 11 years ago by Ian Dees <[email protected]>
smarter hovering on selected points

github.com/censusreporter/census-mockups - 2b97df95051d71d91c8b2ca100d5e2bfbacc0502 authored over 11 years ago by Ryan Pitts <[email protected]>
use colorbrewer scale for multiple dot selections

github.com/censusreporter/census-mockups - 32d681aa7935165c4eed1c1558938b05bb4087a8 authored over 11 years ago by Ryan Pitts <[email protected]>
select2 for chart select

github.com/censusreporter/census-mockups - c03888565bcd37f3ec901ced898ecf2c82ae9bd1 authored over 11 years ago by Ryan Pitts <[email protected]>
dropdown geo finder

github.com/censusreporter/census-mockups - dff3a6de11d61a03a0118235cdf6a55742c0d0af authored over 11 years ago by Ryan Pitts <[email protected]>
revised not-line-plot handling on comparison template

github.com/censusreporter/census-mockups - 33b79b006e0b5dbee7a1658d8637ca2dc799c20e authored over 11 years ago by Ryan Pitts <[email protected]>
add tick marks, medians and such

github.com/censusreporter/census-mockups - b4475bc5a611339549038b3dfd0cf56afe13fcee authored over 11 years ago by Ryan Pitts <[email protected]>
comparison page with ALA-inspired line plots

github.com/censusreporter/census-mockups - ebf5775752e33bc4475a47c8e4379f8773bd7a31 authored over 11 years ago by Ryan Pitts <[email protected]>
working on some revisions to detail maybe

github.com/censusreporter/census-mockups - ae277b83034e2deeb59bad8fbe3de9460a7e72c4 authored over 11 years ago by Ryan Pitts <[email protected]>
Add a hacky comparison query.

github.com/censusreporter/census-api - af1049ba80bd07d9ffc91b3eb4ef33c9b3cc85aa authored over 11 years ago by Ian Dees <[email protected]>
Integerize all the people counts.

Fixes #6.

github.com/censusreporter/census-api - 29a3a0ad0faa9712756b0d693f39a8953f575904 authored over 11 years ago by Ian Dees <[email protected]>
readme oops

github.com/censusreporter/census-mockups - 2ea1535c53724df3713ebeb6f1f53d0c0f4d7647 authored over 11 years ago by Ryan Pitts <[email protected]>
initial commit

github.com/censusreporter/census-mockups - a2284e6458ed7c2c52111aee6c8cf367c81d5399 authored over 11 years ago by Ryan Pitts <[email protected]>
Make the sum function a bit clearer.

github.com/censusreporter/census-api - fe5c2c55f20708c0b6fcf430a4e261ef2741dbc6 authored over 11 years ago by Ian Dees <[email protected]>
Fix the summing function's handling of null.

github.com/censusreporter/census-api - 1b72cf05f61f0a8648f4fad6316c47f3d2c89bb1 authored over 11 years ago by Ian Dees <[email protected]>
Initial revision.

github.com/censusreporter/census-api - 5606deadf43838714d8e73c89a6f1343323bbe10 authored over 11 years ago by Ian Dees <[email protected]>
Remove duplicated columns from the generated SQL for 2009 3yr.

github.com/censusreporter/census-postgres - f97c46785e67ac9537131e215554839d5e0d7585 authored over 11 years ago by Ian Dees <[email protected]>
Don't reset the line number to zero.

Some tables cross sequence boundaries, so we need to let the line number increment past the sequ...

github.com/censusreporter/census-postgres - bf75cf253c667d435fe454b010b5e55d4d685f7b authored over 11 years ago by Ian Dees <[email protected]>
Try to let skipping go back to '1'.

github.com/censusreporter/census-postgres - 90225fa6b5f58ccf52a75d4949ef74d37665c6ca authored over 11 years ago by Ian Dees <[email protected]>
Try to do a better job of skipping labels.

github.com/censusreporter/census-postgres - 9b76530d1040d03634a6fb45a0ea323d503b9acb authored over 11 years ago by Ian Dees <[email protected]>
Also mark : as headers when linenumber ends in 5.

github.com/censusreporter/census-postgres - f6f761590ab4727ae2ea0d761094555f0e91e1c6 authored over 11 years ago by Ian Dees <[email protected]>
Remove some more duplicate columns.

github.com/censusreporter/census-postgres - 36a0712b70f9f4b8ef6cdaf4fda9c0c5f0e70b24 authored over 11 years ago by Ian Dees <[email protected]>
There aren't always spaces before the -- labels.

github.com/censusreporter/census-postgres - 582993bc5b332a7fdb4802a3dfd5c72f1aace75b authored over 11 years ago by Ian Dees <[email protected]>
Remove duplicate columns created from labels.

github.com/censusreporter/census-postgres - 5a3d8fa9ff3e4d152addea9affb1e7e442a80a46 authored over 11 years ago by Ian Dees <[email protected]>
Skip over labels with -- at the end of the title.

github.com/censusreporter/census-postgres - 88e0a10e711003380b26d1798bf9242a86ad7ceb authored over 11 years ago by Ian Dees <[email protected]>
Add ACS 2009 import scripts.

github.com/censusreporter/census-postgres-scripts - 2fb5d35911ef63569cd04cfbba91230a8c65bb06 authored over 11 years ago by Ian Dees <[email protected]>
Add generated ACS 2009 5yr.

github.com/censusreporter/census-postgres - 6b485a59a0a043733e7765c75db739d9d68c8f42 authored over 11 years ago by Ian Dees <[email protected]>
Revert "Try to skip over completely blank lines in the mapping file."

This reverts commit 7b9b0abf763690f4f2d70e926e5c0c44d5bfca25.

github.com/censusreporter/census-postgres - af97d086cb4e606d13c6f0cd1afc1fd34c1cd761 authored over 11 years ago by Ian Dees <[email protected]>
Try to skip over completely blank lines in the mapping file.

github.com/censusreporter/census-postgres - 7b9b0abf763690f4f2d70e926e5c0c44d5bfca25 authored over 11 years ago by Ian Dees <[email protected]>
Add generated ACS 2009 3yr.

github.com/censusreporter/census-postgres - 955c579dd9364fa73cde8857d69124a643309a42 authored over 11 years ago by Ian Dees <[email protected]>
Add generated ACS 2009 1yr.

github.com/censusreporter/census-postgres - 20d3f215aa8bb25de4b4ea128e31917b492121b0 authored over 11 years ago by Ian Dees <[email protected]>
Fix the 2009 1 and 3 year download scripts.

github.com/censusreporter/census-postgres-scripts - efbdad64cd067e7a6f3f0816dd1d0e671ddb60a3 authored over 11 years ago by Ian Dees <[email protected]>
Adding config stuff for acs2009.

github.com/censusreporter/census-postgres - 8ee9eb06cf15019aa46f4602ac9f564b5302b61f authored over 11 years ago by Ian Dees <[email protected]>
Fix unzipping for the 2009 5yr.

github.com/censusreporter/census-postgres-scripts - 2c05f1cae2334c48ab4e44e9fa1a596f675cb01d authored over 11 years ago by Ian Dees <[email protected]>
Add 2009 download scripts.

github.com/censusreporter/census-postgres-scripts - ad4163357a715f398f771eec33435451df5d25a5 authored over 11 years ago by Ian Dees <[email protected]>
Remove the schema set lines.

github.com/censusreporter/census-postgres - bc982a86dfaa20b31e875049b27f5d7ea591aa44 authored over 11 years ago by Ian Dees <[email protected]>
Add 3yr import scripts.

github.com/censusreporter/census-postgres-scripts - e1c6e2835834e4b2b850346c919e636ae7742cee authored over 11 years ago by Ian Dees <[email protected]>
Add generated 2010 3yr SQL.

github.com/censusreporter/census-postgres - fa44d0b609a409a6340399be528eb1d26e9c0cb2 authored over 11 years ago by Ian Dees <[email protected]>
Add generated 2011 3yr SQL.

github.com/censusreporter/census-postgres - a01aed28af7bc84cf3486cf675d510bd70f79003 authored over 11 years ago by Ian Dees <[email protected]>
Add 3yr download scripts.

github.com/censusreporter/census-postgres-scripts - ce688a642684887cdf234b8b741212c9b11bdc8a authored over 11 years ago by Ian Dees <[email protected]>
Add 2011 1yr import script and fix drops for 2010.

github.com/censusreporter/census-postgres-scripts - ba8ebead2ae0bdb5722d594259a8cb9294df4edf authored over 11 years ago by Ian Dees <[email protected]>
Add generated 2011 1-year ACS scripts.

github.com/censusreporter/census-postgres - 793002a234315ef4bc53afa64a64c62835e7c5ac authored over 11 years ago by Ian Dees <[email protected]>
2010, not 2011

github.com/censusreporter/census-postgres - f24a79f6f975f86775cd26186065d68938680ed1 authored over 11 years ago by Ian Dees <[email protected]>
2011's mapping file has . as a null character too.

github.com/censusreporter/census-postgres - d2611c6cfbcedefd371289a85935d3b7ee9fc8bb authored over 11 years ago by Ian Dees <[email protected]>
Allow for year-specific line number column name.

github.com/censusreporter/census-postgres - fb19d1e38322f3e67e345af566a5aa9251eb5711 authored over 11 years ago by Ian Dees <[email protected]>
Fix the SELECT on the generated views file.

github.com/censusreporter/census-postgres - eecfb277a5c4dbd65e2361ea8abdf6a5872c8b92 authored over 11 years ago by Ian Dees <[email protected]>
Forgot the SELECTs when creating the view.

github.com/censusreporter/census-postgres - e8eb76288babe38863112916a8b9833a5dedfed2 authored over 11 years ago by Ian Dees <[email protected]>
Fix the parens on the generated views file.

github.com/censusreporter/census-postgres - 95fe767abd2235efa6edbb2458d3e2db597c0cc4 authored over 11 years ago by Ian Dees <[email protected]>
Ditch the parens.

github.com/censusreporter/census-postgres - 869a7dce2a09304ddc8368138882e9f69acc9bd2 authored over 11 years ago by Ian Dees <[email protected]>
Fix the view creation script for 2011 1-year.

github.com/censusreporter/census-postgres - 3c4c06cbac3e89e7d4e9e9f7de4090d2f7418532 authored over 11 years ago by Ian Dees <[email protected]>
Fix the format args.

github.com/censusreporter/census-postgres - 47dfee92d342be6637201178b9ab3361de8514d5 authored over 11 years ago by Ian Dees <[email protected]>
Fix the _moe view to include the _moe columns.

github.com/censusreporter/census-postgres - a64da362476ab1f8c47b381ebb636658564e4eda authored over 11 years ago by Ian Dees <[email protected]>
Removing some files that aren't created anymore.

github.com/censusreporter/census-postgres-scripts - 8d8eb2b7b7e92bbc146618a5c061dd3d170c241a authored over 11 years ago by Ian Dees <[email protected]>
Use the correct sqn column name and write out at the correct time.

github.com/censusreporter/census-postgres - 122a99424f6d7c51fe7a12024d9fa8c1dba9d35c authored over 11 years ago by Ian Dees <[email protected]>
Import the fixed-width .txt g* files instead of .csv.

github.com/censusreporter/census-postgres - 1ec5d25302f31b82f0543ae2093b4e44aaf431f3 authored over 11 years ago by Ian Dees <[email protected]>
Create 03_import_acs_2010_1yr.sh

github.com/censusreporter/census-postgres-scripts - 57488d53a68afa19e85a13d2a371e6476b64abc8 authored over 11 years ago by Ian Dees <[email protected]>
Initial try at the 2010 1-yr ACS.

github.com/censusreporter/census-postgres - 923fdab943ac972063a67c07c69325ac5dcf46b0 authored over 11 years ago by Ian Dees <[email protected]>
Oops, flipped these two dirs around.

github.com/censusreporter/census-postgres - 328de98dc5bda1ad8cd3cbd96591dd38f5305dad authored over 11 years ago by Ian Dees <[email protected]>
Push the config stuff into each module.

github.com/censusreporter/census-postgres - 66e4424912ef3568bddcfe26df16ddb3a47dca5a authored over 11 years ago by Ian Dees <[email protected]>
Forgot to modularize the tmp_sequence COPY builder.

github.com/censusreporter/census-postgres - 2695f04321f35c1b6e2fded62c4b98ebd7128525 authored over 11 years ago by Ian Dees <[email protected]>
Try to handle metadata column names changing between ACS releases.

github.com/censusreporter/census-postgres - 739d2f611f6bcf933427a378ff14d0f9640b930a authored over 11 years ago by Ian Dees <[email protected]>
Fix acs_dir example.

github.com/censusreporter/census-postgres - c2f9ed074f128e9df02550371add81e133fc3fe7 authored over 11 years ago by Ian Dees <[email protected]>
Refactor the scripts a bit so they can be run all at once.

github.com/censusreporter/census-postgres - f4d0bdee1af726d643cb1dbb1e1afc9cc2daf4a1 authored over 11 years ago by Ian Dees <[email protected]>
Use itertools across the board.

github.com/censusreporter/census-postgres - 8c00038d968d46870bea4e3133cf0542ac1fbac3 authored over 11 years ago by Ian Dees <[email protected]>
Try to use itertools to make the code a bit easier to read.

github.com/censusreporter/census-postgres - 82c7ea0baf94c1a5ca1395629f02fe0c884dd197 authored over 11 years ago by Ian Dees <[email protected]>
Fix the name of the output file.

github.com/censusreporter/census-postgres - 7f92f7dc36841bfb4119f70215396f83ed680e02 authored over 11 years ago by Ian Dees <[email protected]>
Add a views SQL builder script.

github.com/censusreporter/census-postgres - 036f1cb7d820c6b9efc441455ea7a3c665df3c08 authored over 11 years ago by Ian Dees <[email protected]>
Add a script that generates the create table for the real data.

github.com/censusreporter/census-postgres - 67bd971ffd5f73edd17140cf3b8688857c608c67 authored over 11 years ago by Ian Dees <[email protected]>
Add build_sequence_import script.

github.com/censusreporter/census-postgres - 75a3b75a2bc10e7e0e7ebbd23ba922fe991e8d08 authored over 11 years ago by Ian Dees <[email protected]>
Remove unused imports.

github.com/censusreporter/census-postgres - 602ef431ccf294c4406127bb440faab38ae3298f authored over 11 years ago by Ian Dees <[email protected]>
Use the correct index for the sequence number in the file name.

github.com/censusreporter/census-postgres - 9570733a62fa2061cd7dcb4974bd088ba62d284b authored over 11 years ago by Ian Dees <[email protected]>
Sort the files before writing them out.

github.com/censusreporter/census-postgres - 350ef1a6268335d1df73eb4cae11b4f363ebb5c8 authored over 11 years ago by Ian Dees <[email protected]>
Those .txt files are actually CSVs. Tricky.

github.com/censusreporter/census-postgres - bb51259f2aa496496473f7456d22e2f32cbf5bec authored over 11 years ago by Ian Dees <[email protected]>
First pass at a import tmp_seq generator.

github.com/censusreporter/census-postgres - 6c065a99ed5b7781e6ba5e61adc74cd258f8d1e9 authored over 11 years ago by Ian Dees <[email protected]>
My quick hack didn't do what I wanted it to do.

github.com/censusreporter/census-postgres - f55da7ce902f45e4f0d22a20c2d14adb7b68fc6c authored over 11 years ago by Ian Dees <[email protected]>
Include the _moe tmp tables.

github.com/censusreporter/census-postgres - 2b1cb4aabad4d6c02081165fd4cb30aba50f7156 authored over 11 years ago by Ian Dees <[email protected]>
Clean up and DRY-ify the tmp_seq python script.

github.com/censusreporter/census-postgres - e437b2ab37b196b83ff0d842f0133db24109f554 authored over 11 years ago by Ian Dees <[email protected]>
Update and rename build_ to build_tmp_sequence_sql.py

github.com/censusreporter/census-postgres - 11dc421fcede59a994fb37d10c82f050409d5b1c authored over 11 years ago by Ian Dees <[email protected]>
Create build_

github.com/censusreporter/census-postgres - 1570d05728af02b8780a6f9dfe48662ad49887e0 authored over 11 years ago by Ian Dees <[email protected]>
Initial geoheader import script.

github.com/censusreporter/census-postgres - 6f3da94493cbaad76f4adcf5dca03ac650cb4498 authored over 11 years ago by Ian Dees <[email protected]>
Add download steps for 1 and 3yr ACS.

github.com/censusreporter/census-postgres-scripts - 8c88477d5c74be4b4a63b5d14cde3a04c3ce4892 authored over 11 years ago by Ian Dees <[email protected]>
Return to the correct dir to complete tmp cleanup.

github.com/censusreporter/census-postgres-scripts - 3ef325c3abb79d299413a5c48743d813829ce8a7 authored over 11 years ago by Ian Dees <[email protected]>