ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,692 rows where state = "New York" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Broome 786
- Chenango 786
- Clinton 786
- Delaware 786
- Dutchess 786
- Erie 786
- Essex 786
- Greene 786
- Hamilton 786
- Herkimer 786
- Jefferson 786
- Livingston 786
- Monroe 786
- Montgomery 786
- Nassau 786
- New York City 786
- Onondaga 786
- Ontario 786
- Orange 786
- Putnam 786
- Rensselaer 786
- Rockland 786
- Saratoga 786
- Schenectady 786
- Schoharie 786
- Suffolk 786
- Sullivan 786
- Tioga 786
- Tompkins 786
- Ulster 786
- …
state 1
- New York · 45,492 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4865 | 4865 | 2020-03-19 | Broome | New York | 36007 | 2 | 0 |
4866 | 4866 | 2020-03-19 | Chenango | New York | 36017 | 1 | 0 |
4867 | 4867 | 2020-03-19 | Clinton | New York | 36019 | 1 | 0 |
4868 | 4868 | 2020-03-19 | Delaware | New York | 36025 | 1 | 0 |
4869 | 4869 | 2020-03-19 | Dutchess | New York | 36027 | 31 | 0 |
4870 | 4870 | 2020-03-19 | Erie | New York | 36029 | 28 | 0 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
4872 | 4872 | 2020-03-19 | Greene | New York | 36039 | 2 | 0 |
4873 | 4873 | 2020-03-19 | Hamilton | New York | 36041 | 1 | 0 |
4874 | 4874 | 2020-03-19 | Herkimer | New York | 36043 | 1 | 0 |
4875 | 4875 | 2020-03-19 | Jefferson | New York | 36045 | 1 | 0 |
4876 | 4876 | 2020-03-19 | Livingston | New York | 36051 | 1 | 0 |
4877 | 4877 | 2020-03-19 | Monroe | New York | 36055 | 28 | 0 |
4878 | 4878 | 2020-03-19 | Montgomery | New York | 36057 | 1 | 0 |
4879 | 4879 | 2020-03-19 | Nassau | New York | 36059 | 382 | 3 |
4880 | 4880 | 2020-03-19 | New York City | New York | 2477 | 31 | |
4881 | 4881 | 2020-03-19 | Onondaga | New York | 36067 | 2 | 0 |
4882 | 4882 | 2020-03-19 | Ontario | New York | 36069 | 1 | 0 |
4883 | 4883 | 2020-03-19 | Orange | New York | 36071 | 51 | 0 |
4884 | 4884 | 2020-03-19 | Putnam | New York | 36079 | 2 | 0 |
4885 | 4885 | 2020-03-19 | Rensselaer | New York | 36083 | 4 | 0 |
4886 | 4886 | 2020-03-19 | Rockland | New York | 36087 | 53 | 2 |
4887 | 4887 | 2020-03-19 | Saratoga | New York | 36091 | 14 | 0 |
4888 | 4888 | 2020-03-19 | Schenectady | New York | 36093 | 21 | 0 |
4889 | 4889 | 2020-03-19 | Schoharie | New York | 36095 | 1 | 0 |
4890 | 4890 | 2020-03-19 | Suffolk | New York | 36103 | 178 | 3 |
4891 | 4891 | 2020-03-19 | Sullivan | New York | 36105 | 8 | 0 |
4892 | 4892 | 2020-03-19 | Tioga | New York | 36107 | 1 | 0 |
4893 | 4893 | 2020-03-19 | Tompkins | New York | 36109 | 7 | 0 |
4894 | 4894 | 2020-03-19 | Ulster | New York | 36111 | 12 | 0 |
4895 | 4895 | 2020-03-19 | Warren | New York | 36113 | 1 | 0 |
4896 | 4896 | 2020-03-19 | Washington | New York | 36115 | 1 | 0 |
4897 | 4897 | 2020-03-19 | Wayne | New York | 36117 | 1 | 0 |
4898 | 4898 | 2020-03-19 | Westchester | New York | 36119 | 797 | 0 |
4899 | 4899 | 2020-03-19 | Wyoming | New York | 36121 | 2 | 0 |
5709 | 5709 | 2020-03-20 | Albany | New York | 36001 | 61 | 0 |
5710 | 5710 | 2020-03-20 | Allegany | New York | 36003 | 2 | 0 |
5711 | 5711 | 2020-03-20 | Broome | New York | 36007 | 2 | 0 |
5712 | 5712 | 2020-03-20 | Chenango | New York | 36017 | 2 | 0 |
5713 | 5713 | 2020-03-20 | Clinton | New York | 36019 | 2 | 0 |
5714 | 5714 | 2020-03-20 | Columbia | New York | 36021 | 1 | 0 |
5715 | 5715 | 2020-03-20 | Delaware | New York | 36025 | 1 | 0 |
5716 | 5716 | 2020-03-20 | Dutchess | New York | 36027 | 36 | 0 |
5717 | 5717 | 2020-03-20 | Erie | New York | 36029 | 31 | 0 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
5719 | 5719 | 2020-03-20 | Fulton | New York | 36035 | 1 | 0 |
5720 | 5720 | 2020-03-20 | Genesee | New York | 36037 | 1 | 0 |
5721 | 5721 | 2020-03-20 | Greene | New York | 36039 | 2 | 0 |
5722 | 5722 | 2020-03-20 | Hamilton | New York | 36041 | 2 | 0 |
5723 | 5723 | 2020-03-20 | Herkimer | New York | 36043 | 2 | 0 |
5724 | 5724 | 2020-03-20 | Jefferson | New York | 36045 | 1 | 0 |
5725 | 5725 | 2020-03-20 | Livingston | New York | 36051 | 1 | 0 |
5726 | 5726 | 2020-03-20 | Monroe | New York | 36055 | 32 | 0 |
5727 | 5727 | 2020-03-20 | Montgomery | New York | 36057 | 2 | 0 |
5728 | 5728 | 2020-03-20 | Nassau | New York | 36059 | 754 | 4 |
5729 | 5729 | 2020-03-20 | New York City | New York | 4419 | 54 | |
5730 | 5730 | 2020-03-20 | Niagara | New York | 36063 | 3 | 0 |
5731 | 5731 | 2020-03-20 | Oneida | New York | 36065 | 2 | 0 |
5732 | 5732 | 2020-03-20 | Onondaga | New York | 36067 | 8 | 0 |
5733 | 5733 | 2020-03-20 | Ontario | New York | 36069 | 3 | 0 |
5734 | 5734 | 2020-03-20 | Orange | New York | 36071 | 84 | 0 |
5735 | 5735 | 2020-03-20 | Putnam | New York | 36079 | 7 | 0 |
5736 | 5736 | 2020-03-20 | Rensselaer | New York | 36083 | 8 | 0 |
5737 | 5737 | 2020-03-20 | Rockland | New York | 36087 | 101 | 3 |
5738 | 5738 | 2020-03-20 | Saratoga | New York | 36091 | 24 | 0 |
5739 | 5739 | 2020-03-20 | Schenectady | New York | 36093 | 21 | 0 |
5740 | 5740 | 2020-03-20 | Schoharie | New York | 36095 | 1 | 0 |
5741 | 5741 | 2020-03-20 | Suffolk | New York | 36103 | 371 | 7 |
5742 | 5742 | 2020-03-20 | Sullivan | New York | 36105 | 8 | 0 |
5743 | 5743 | 2020-03-20 | Tioga | New York | 36107 | 1 | 0 |
5744 | 5744 | 2020-03-20 | Tompkins | New York | 36109 | 7 | 0 |
5745 | 5745 | 2020-03-20 | Ulster | New York | 36111 | 12 | 0 |
5746 | 5746 | 2020-03-20 | Warren | New York | 36113 | 1 | 0 |
5747 | 5747 | 2020-03-20 | Washington | New York | 36115 | 1 | 0 |
5748 | 5748 | 2020-03-20 | Wayne | New York | 36117 | 1 | 0 |
5749 | 5749 | 2020-03-20 | Westchester | New York | 36119 | 1091 | 0 |
5750 | 5750 | 2020-03-20 | Wyoming | New York | 36121 | 2 | 0 |
6703 | 6703 | 2020-03-21 | Albany | New York | 36001 | 88 | 0 |
6704 | 6704 | 2020-03-21 | Allegany | New York | 36003 | 2 | 0 |
6705 | 6705 | 2020-03-21 | Broome | New York | 36007 | 2 | 1 |
6706 | 6706 | 2020-03-21 | Chenango | New York | 36017 | 2 | 0 |
6707 | 6707 | 2020-03-21 | Clinton | New York | 36019 | 4 | 0 |
6708 | 6708 | 2020-03-21 | Columbia | New York | 36021 | 2 | 0 |
6709 | 6709 | 2020-03-21 | Delaware | New York | 36025 | 1 | 0 |
6710 | 6710 | 2020-03-21 | Dutchess | New York | 36027 | 49 | 0 |
6711 | 6711 | 2020-03-21 | Erie | New York | 36029 | 38 | 0 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
6713 | 6713 | 2020-03-21 | Fulton | New York | 36035 | 1 | 0 |
6714 | 6714 | 2020-03-21 | Genesee | New York | 36037 | 1 | 0 |
6715 | 6715 | 2020-03-21 | Greene | New York | 36039 | 2 | 0 |
6716 | 6716 | 2020-03-21 | Hamilton | New York | 36041 | 2 | 0 |
6717 | 6717 | 2020-03-21 | Herkimer | New York | 36043 | 3 | 0 |
6718 | 6718 | 2020-03-21 | Jefferson | New York | 36045 | 1 | 0 |
6719 | 6719 | 2020-03-21 | Livingston | New York | 36051 | 2 | 0 |
6720 | 6720 | 2020-03-21 | Monroe | New York | 36055 | 42 | 0 |
6721 | 6721 | 2020-03-21 | Montgomery | New York | 36057 | 3 | 0 |
6722 | 6722 | 2020-03-21 | Nassau | New York | 36059 | 1234 | 7 |
6723 | 6723 | 2020-03-21 | New York City | New York | 6226 | 75 | |
6724 | 6724 | 2020-03-21 | Niagara | New York | 36063 | 4 | 0 |
6725 | 6725 | 2020-03-21 | Oneida | New York | 36065 | 4 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);