ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,658 rows where county = "Sullivan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Tennessee 696
- New York 688
- New Hampshire 683
- Indiana 681
- Pennsylvania 671
- Missouri 641
county 1
- Sullivan · 4,060 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179770 | 2179770 | 2022-02-03 | Sullivan | Pennsylvania | 42113 | 1019 | 32 |
2180059 | 2180059 | 2022-02-03 | Sullivan | Tennessee | 47163 | 40582 | 598 |
2174976 | 2174976 | 2022-02-02 | Sullivan | Indiana | 18153 | 5038 | 70 |
2175800 | 2175800 | 2022-02-02 | Sullivan | Missouri | 29211 | 1626 | 19 |
2175986 | 2175986 | 2022-02-02 | Sullivan | New Hampshire | 33019 | 8267 | 62 |
2176092 | 2176092 | 2022-02-02 | Sullivan | New York | 36105 | 17676 | 119 |
2176519 | 2176519 | 2022-02-02 | Sullivan | Pennsylvania | 42113 | 1013 | 32 |
2176808 | 2176808 | 2022-02-02 | Sullivan | Tennessee | 47163 | 40582 | 598 |
2171723 | 2171723 | 2022-02-01 | Sullivan | Indiana | 18153 | 5000 | 69 |
2172547 | 2172547 | 2022-02-01 | Sullivan | Missouri | 29211 | 1617 | 19 |
2172733 | 2172733 | 2022-02-01 | Sullivan | New Hampshire | 33019 | 8212 | 61 |
2172839 | 2172839 | 2022-02-01 | Sullivan | New York | 36105 | 17635 | 118 |
2173265 | 2173265 | 2022-02-01 | Sullivan | Pennsylvania | 42113 | 1007 | 32 |
2173554 | 2173554 | 2022-02-01 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2168470 | 2168470 | 2022-01-31 | Sullivan | Indiana | 18153 | 4984 | 69 |
2169294 | 2169294 | 2022-01-31 | Sullivan | Missouri | 29211 | 1604 | 19 |
2169480 | 2169480 | 2022-01-31 | Sullivan | New Hampshire | 33019 | 8202 | 60 |
2169586 | 2169586 | 2022-01-31 | Sullivan | New York | 36105 | 17599 | 118 |
2170013 | 2170013 | 2022-01-31 | Sullivan | Pennsylvania | 42113 | 1003 | 32 |
2170302 | 2170302 | 2022-01-31 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2165215 | 2165215 | 2022-01-30 | Sullivan | Indiana | 18153 | 4843 | 68 |
2166039 | 2166039 | 2022-01-30 | Sullivan | Missouri | 29211 | 1602 | 19 |
2166225 | 2166225 | 2022-01-30 | Sullivan | New Hampshire | 33019 | 8008 | 60 |
2166331 | 2166331 | 2022-01-30 | Sullivan | New York | 36105 | 17583 | 118 |
2166759 | 2166759 | 2022-01-30 | Sullivan | Pennsylvania | 42113 | 1001 | 32 |
2167048 | 2167048 | 2022-01-30 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2161960 | 2161960 | 2022-01-29 | Sullivan | Indiana | 18153 | 4843 | 68 |
2162784 | 2162784 | 2022-01-29 | Sullivan | Missouri | 29211 | 1597 | 19 |
2162970 | 2162970 | 2022-01-29 | Sullivan | New Hampshire | 33019 | 8008 | 60 |
2163076 | 2163076 | 2022-01-29 | Sullivan | New York | 36105 | 17552 | 118 |
2163504 | 2163504 | 2022-01-29 | Sullivan | Pennsylvania | 42113 | 997 | 32 |
2163793 | 2163793 | 2022-01-29 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2158705 | 2158705 | 2022-01-28 | Sullivan | Indiana | 18153 | 4843 | 68 |
2159529 | 2159529 | 2022-01-28 | Sullivan | Missouri | 29211 | 1577 | 19 |
2159715 | 2159715 | 2022-01-28 | Sullivan | New Hampshire | 33019 | 8008 | 60 |
2159821 | 2159821 | 2022-01-28 | Sullivan | New York | 36105 | 17494 | 117 |
2160249 | 2160249 | 2022-01-28 | Sullivan | Pennsylvania | 42113 | 993 | 32 |
2160538 | 2160538 | 2022-01-28 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2155451 | 2155451 | 2022-01-27 | Sullivan | Indiana | 18153 | 4757 | 68 |
2156275 | 2156275 | 2022-01-27 | Sullivan | Missouri | 29211 | 1570 | 19 |
2156461 | 2156461 | 2022-01-27 | Sullivan | New Hampshire | 33019 | 7923 | 59 |
2156566 | 2156566 | 2022-01-27 | Sullivan | New York | 36105 | 17424 | 116 |
2156993 | 2156993 | 2022-01-27 | Sullivan | Pennsylvania | 42113 | 985 | 32 |
2157282 | 2157282 | 2022-01-27 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2152198 | 2152198 | 2022-01-26 | Sullivan | Indiana | 18153 | 4689 | 68 |
2153022 | 2153022 | 2022-01-26 | Sullivan | Missouri | 29211 | 1548 | 19 |
2153208 | 2153208 | 2022-01-26 | Sullivan | New Hampshire | 33019 | 7858 | 58 |
2153313 | 2153313 | 2022-01-26 | Sullivan | New York | 36105 | 17330 | 116 |
2153740 | 2153740 | 2022-01-26 | Sullivan | Pennsylvania | 42113 | 976 | 32 |
2154029 | 2154029 | 2022-01-26 | Sullivan | Tennessee | 47163 | 37990 | 587 |
2148946 | 2148946 | 2022-01-25 | Sullivan | Indiana | 18153 | 4672 | 68 |
2149770 | 2149770 | 2022-01-25 | Sullivan | Missouri | 29211 | 1539 | 19 |
2149956 | 2149956 | 2022-01-25 | Sullivan | New Hampshire | 33019 | 7827 | 58 |
2150061 | 2150061 | 2022-01-25 | Sullivan | New York | 36105 | 17235 | 116 |
2150488 | 2150488 | 2022-01-25 | Sullivan | Pennsylvania | 42113 | 969 | 32 |
2150777 | 2150777 | 2022-01-25 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2145694 | 2145694 | 2022-01-24 | Sullivan | Indiana | 18153 | 4627 | 68 |
2146518 | 2146518 | 2022-01-24 | Sullivan | Missouri | 29211 | 1524 | 19 |
2146704 | 2146704 | 2022-01-24 | Sullivan | New Hampshire | 33019 | 7779 | 57 |
2146809 | 2146809 | 2022-01-24 | Sullivan | New York | 36105 | 17172 | 115 |
2147236 | 2147236 | 2022-01-24 | Sullivan | Pennsylvania | 42113 | 964 | 32 |
2147525 | 2147525 | 2022-01-24 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2142439 | 2142439 | 2022-01-23 | Sullivan | Indiana | 18153 | 4505 | 68 |
2143263 | 2143263 | 2022-01-23 | Sullivan | Missouri | 29211 | 1516 | 19 |
2143449 | 2143449 | 2022-01-23 | Sullivan | New Hampshire | 33019 | 7557 | 57 |
2143555 | 2143555 | 2022-01-23 | Sullivan | New York | 36105 | 17125 | 114 |
2143982 | 2143982 | 2022-01-23 | Sullivan | Pennsylvania | 42113 | 964 | 32 |
2144271 | 2144271 | 2022-01-23 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2139184 | 2139184 | 2022-01-22 | Sullivan | Indiana | 18153 | 4505 | 68 |
2140008 | 2140008 | 2022-01-22 | Sullivan | Missouri | 29211 | 1508 | 19 |
2140194 | 2140194 | 2022-01-22 | Sullivan | New Hampshire | 33019 | 7557 | 57 |
2140300 | 2140300 | 2022-01-22 | Sullivan | New York | 36105 | 17033 | 114 |
2140727 | 2140727 | 2022-01-22 | Sullivan | Pennsylvania | 42113 | 955 | 32 |
2141016 | 2141016 | 2022-01-22 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2135928 | 2135928 | 2022-01-21 | Sullivan | Indiana | 18153 | 4505 | 68 |
2136752 | 2136752 | 2022-01-21 | Sullivan | Missouri | 29211 | 1492 | 19 |
2136938 | 2136938 | 2022-01-21 | Sullivan | New Hampshire | 33019 | 7557 | 57 |
2137044 | 2137044 | 2022-01-21 | Sullivan | New York | 36105 | 16901 | 112 |
2137471 | 2137471 | 2022-01-21 | Sullivan | Pennsylvania | 42113 | 950 | 32 |
2137760 | 2137760 | 2022-01-21 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2132676 | 2132676 | 2022-01-20 | Sullivan | Indiana | 18153 | 4437 | 67 |
2133500 | 2133500 | 2022-01-20 | Sullivan | Missouri | 29211 | 1482 | 20 |
2133686 | 2133686 | 2022-01-20 | Sullivan | New Hampshire | 33019 | 7473 | 57 |
2133791 | 2133791 | 2022-01-20 | Sullivan | New York | 36105 | 16741 | 110 |
2134217 | 2134217 | 2022-01-20 | Sullivan | Pennsylvania | 42113 | 944 | 32 |
2134506 | 2134506 | 2022-01-20 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2129423 | 2129423 | 2022-01-19 | Sullivan | Indiana | 18153 | 4381 | 67 |
2130247 | 2130247 | 2022-01-19 | Sullivan | Missouri | 29211 | 1454 | 20 |
2130433 | 2130433 | 2022-01-19 | Sullivan | New Hampshire | 33019 | 7407 | 57 |
2130539 | 2130539 | 2022-01-19 | Sullivan | New York | 36105 | 16603 | 110 |
2130965 | 2130965 | 2022-01-19 | Sullivan | Pennsylvania | 42113 | 934 | 32 |
2131254 | 2131254 | 2022-01-19 | Sullivan | Tennessee | 47163 | 35225 | 574 |
2126169 | 2126169 | 2022-01-18 | Sullivan | Indiana | 18153 | 4341 | 67 |
2126993 | 2126993 | 2022-01-18 | Sullivan | Missouri | 29211 | 1441 | 20 |
2127179 | 2127179 | 2022-01-18 | Sullivan | New Hampshire | 33019 | 7394 | 57 |
2127285 | 2127285 | 2022-01-18 | Sullivan | New York | 36105 | 16511 | 110 |
2127711 | 2127711 | 2022-01-18 | Sullivan | Pennsylvania | 42113 | 924 | 32 |
2128000 | 2128000 | 2022-01-18 | Sullivan | Tennessee | 47163 | 32969 | 560 |
2122917 | 2122917 | 2022-01-17 | Sullivan | Indiana | 18153 | 4328 | 66 |
2123741 | 2123741 | 2022-01-17 | Sullivan | Missouri | 29211 | 1416 | 20 |
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);