Code Monkey home page Code Monkey logo

nlrb-cats's People

Contributors

fgregg avatar reuning avatar

Stargazers

 avatar  avatar  avatar  avatar

Forkers

reuning

nlrb-cats's Issues

remove duplicate rows

We have cases that look like this the the "case" table

r_case_number case_type status nlrb_office_id docket_num inquiry_id case_name date_filed hearing_target_date election_target_date employer_on_petition union_involved_on_petition union_involved_on_petition self_certification post_elect_self_cert naics_code num_employees_requested
37-UC-00091 UC Close 37 91 Lunalilo Home 2006-08-25T00:00:00 2006-09-08T00:00:00 2006-10-06T00:00:00 Lunalilo Home United Public Workers, AFSCME Local 646, AFL-CIO 0 0 623110 26
37-UC-00091 UC 37 91 Lunalilo Home 2006-08-25T00:00:00 Lunalilo Home United Public Workers, AFSCME Local 646, AFL-CIO 0 0 623110 26

Source files

  1. https://web.archive.org/web/20151106084159/http://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-bulk-19990101-20110930-in-xml

  2. https://web.archive.org/web/20151101212104/http://catalog.data.gov/dataset/nlrb-cats-r-case-data-bulk-19991001-20091202-in-xml

  3. https://web.archive.org/web/20201123172513/https://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-bulk-19990101-20110930-in-xml

  4. https://web.archive.org/web/20151105135240/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-bulk-19990101-20110930-in-xml

  5. https://web.archive.org/web/20151106084221/http://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2011

  6. https://web.archive.org/web/20170801224204/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2009

  7. https://web.archive.org/web/20151119012106/http://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2007

  8. https://web.archive.org/web/20201128151600/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2006

  9. https://web.archive.org/web/20201127003934/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2005

  10. https://web.archive.org/web/20170801224416/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2004

  11. https://web.archive.org/web/20170801223537/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2003

  12. https://web.archive.org/web/20170801224311/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2002

  13. https://web.archive.org/web/20170801224343/https://catalog.data.gov/dataset/nlrb-cats-final-r-case-data-in-xml-2001

  14. https://web.archive.org/web/20201104025058/https://catalog.data.gov/dataset/nlrb-cats-r-case-data-in-xml-2000

  15. https://web.archive.org/web/20170601194455/https://catalog.data.gov/dataset/nlrb-cats-r-case-data-in-xml-1999

  16. https://web.archive.org/web/20170620144754/https://www.nlrb.gov/nlrb/datagov/C_2011.zip

  17. https://web.archive.org/web/20170620144451/https://www.nlrb.gov/nlrb/datagov/C_2010.zip

  18. https://web.archive.org/web/20151025100524/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2009

  19. https://web.archive.org/web/20150913170712/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2008

  20. https://web.archive.org/web/20151106084148/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2007

  21. https://web.archive.org/web/20151025100518/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2006

  22. https://web.archive.org/web/20151017135453/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2005

  23. https://web.archive.org/web/20151106084136/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2004

  24. https://web.archive.org/web/20151105135303/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2003

  25. https://web.archive.org/web/20150913165904/http://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2002

  26. https://web.archive.org/web/20201205001908/https://catalog.data.gov/dataset/nlrb-cats-final-c-case-data-in-xml-2001

  27. https://web.archive.org/web/20151017140307/http://catalog.data.gov/dataset/nlrb-cats-c-case-data-in-xml-2000

  28. https://web.archive.org/web/20170505051224/https://catalog.data.gov/dataset/nlrb-cats-c-case-data-in-xml-1999

  29. https://web.archive.org/web/20160705015251/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2010

  30. https://web.archive.org/web/20151105135358/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2009

  31. https://web.archive.org/web/20170801223846/https://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2008

  32. https://web.archive.org/web/20150912192520/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2007

  33. https://web.archive.org/web/20150912165016/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2006

  34. https://web.archive.org/web/20160705073921/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2005

  35. https://web.archive.org/web/20151027234104/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2004

  36. https://web.archive.org/web/20170601194139/https://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2003

  37. https://web.archive.org/web/20151119012117/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2002

  38. https://web.archive.org/web/20151105135347/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2001

  39. https://web.archive.org/web/20151105135336/http://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-2000

  40. https://web.archive.org/web/20170801224236/https://catalog.data.gov/dataset/nlrb-cats-r-case-frf-in-xml-1999

  41. https://web.archive.org/web/20170505052015/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2010

  42. https://web.archive.org/web/20170505052550/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2009

  43. https://web.archive.org/web/20170505050104/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2008

  44. https://web.archive.org/web/20201201064554/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2007

  45. https://web.archive.org/web/20170801223810/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2006

  46. https://web.archive.org/web/20170505053305/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2005

  47. https://web.archive.org/web/20170505050832/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2004

  48. https://web.archive.org/web/20151017150309/http://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2003

  49. https://web.archive.org/web/20170505053029/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2002

  50. https://web.archive.org/web/20170801224002/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2001

  51. https://web.archive.org/web/20170801224036/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-2000

  52. https://web.archive.org/web/20170505045408/https://catalog.data.gov/dataset/nlrb-cats-c-case-frf-in-xml-1999

  53. https://web.archive.org/web/20160612203634/http://catalog.data.gov/dataset/nlrb-cats-lookupreference-data-in-xml

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.