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
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Tennessee 795
- New York 788
- New Hampshire 783
- Indiana 781
- Pennsylvania 770
- Missouri 741
county 1
- Sullivan · 4,658 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1130 | 1130 | 2020-03-10 | Sullivan | Tennessee | 47163 | 1 | 0 |
1326 | 1326 | 2020-03-11 | Sullivan | Tennessee | 47163 | 1 | 0 |
1573 | 1573 | 2020-03-12 | Sullivan | Tennessee | 47163 | 1 | 0 |
1877 | 1877 | 2020-03-13 | Sullivan | Tennessee | 47163 | 1 | 0 |
2242 | 2242 | 2020-03-14 | Sullivan | Tennessee | 47163 | 1 | 0 |
2667 | 2667 | 2020-03-15 | Sullivan | Tennessee | 47163 | 1 | 0 |
3134 | 3134 | 2020-03-16 | Sullivan | Tennessee | 47163 | 1 | 0 |
3560 | 3560 | 2020-03-17 | Sullivan | New York | 36105 | 1 | 0 |
3667 | 3667 | 2020-03-17 | Sullivan | Tennessee | 47163 | 1 | 0 |
4161 | 4161 | 2020-03-18 | Sullivan | New York | 36105 | 1 | 0 |
4289 | 4289 | 2020-03-18 | Sullivan | Tennessee | 47163 | 1 | 0 |
4891 | 4891 | 2020-03-19 | Sullivan | New York | 36105 | 8 | 0 |
5037 | 5037 | 2020-03-19 | Sullivan | Tennessee | 47163 | 1 | 0 |
5742 | 5742 | 2020-03-20 | Sullivan | New York | 36105 | 8 | 0 |
5925 | 5925 | 2020-03-20 | Sullivan | Tennessee | 47163 | 1 | 0 |
6737 | 6737 | 2020-03-21 | Sullivan | New York | 36105 | 12 | 0 |
6942 | 6942 | 2020-03-21 | Sullivan | Tennessee | 47163 | 1 | 0 |
7763 | 7763 | 2020-03-22 | Sullivan | New Hampshire | 33019 | 1 | 0 |
7833 | 7833 | 2020-03-22 | Sullivan | New York | 36105 | 16 | 0 |
8072 | 8072 | 2020-03-22 | Sullivan | Tennessee | 47163 | 1 | 0 |
8959 | 8959 | 2020-03-23 | Sullivan | New Hampshire | 33019 | 1 | 0 |
9033 | 9033 | 2020-03-23 | Sullivan | New York | 36105 | 23 | 0 |
9290 | 9290 | 2020-03-23 | Sullivan | Tennessee | 47163 | 1 | 0 |
9879 | 9879 | 2020-03-24 | Sullivan | Indiana | 18153 | 1 | 0 |
10263 | 10263 | 2020-03-24 | Sullivan | New Hampshire | 33019 | 1 | 0 |
10341 | 10341 | 2020-03-24 | Sullivan | New York | 36105 | 30 | 0 |
10624 | 10624 | 2020-03-24 | Sullivan | Tennessee | 47163 | 2 | 0 |
11275 | 11275 | 2020-03-25 | Sullivan | Indiana | 18153 | 1 | 0 |
11695 | 11695 | 2020-03-25 | Sullivan | New Hampshire | 33019 | 1 | 0 |
11777 | 11777 | 2020-03-25 | Sullivan | New York | 36105 | 39 | 0 |
12103 | 12103 | 2020-03-25 | Sullivan | Tennessee | 47163 | 2 | 0 |
12835 | 12835 | 2020-03-26 | Sullivan | Indiana | 18153 | 1 | 0 |
13298 | 13298 | 2020-03-26 | Sullivan | New Hampshire | 33019 | 2 | 0 |
13380 | 13380 | 2020-03-26 | Sullivan | New York | 36105 | 53 | 0 |
13729 | 13729 | 2020-03-26 | Sullivan | Tennessee | 47163 | 4 | 0 |
14521 | 14521 | 2020-03-27 | Sullivan | Indiana | 18153 | 1 | 0 |
15030 | 15030 | 2020-03-27 | Sullivan | New Hampshire | 33019 | 2 | 0 |
15114 | 15114 | 2020-03-27 | Sullivan | New York | 36105 | 64 | 0 |
15482 | 15482 | 2020-03-27 | Sullivan | Tennessee | 47163 | 6 | 0 |
16320 | 16320 | 2020-03-28 | Sullivan | Indiana | 18153 | 1 | 0 |
16859 | 16859 | 2020-03-28 | Sullivan | New Hampshire | 33019 | 2 | 0 |
16945 | 16945 | 2020-03-28 | Sullivan | New York | 36105 | 72 | 0 |
17346 | 17346 | 2020-03-28 | Sullivan | Tennessee | 47163 | 6 | 0 |
18225 | 18225 | 2020-03-29 | Sullivan | Indiana | 18153 | 1 | 0 |
18783 | 18783 | 2020-03-29 | Sullivan | New Hampshire | 33019 | 3 | 0 |
18870 | 18870 | 2020-03-29 | Sullivan | New York | 36105 | 88 | 0 |
19296 | 19296 | 2020-03-29 | Sullivan | Tennessee | 47163 | 8 | 0 |
20231 | 20231 | 2020-03-30 | Sullivan | Indiana | 18153 | 1 | 0 |
20821 | 20821 | 2020-03-30 | Sullivan | New Hampshire | 33019 | 3 | 0 |
20909 | 20909 | 2020-03-30 | Sullivan | New York | 36105 | 101 | 0 |
21353 | 21353 | 2020-03-30 | Sullivan | Tennessee | 47163 | 11 | 0 |
22326 | 22326 | 2020-03-31 | Sullivan | Indiana | 18153 | 2 | 0 |
22944 | 22944 | 2020-03-31 | Sullivan | New Hampshire | 33019 | 4 | 0 |
23033 | 23033 | 2020-03-31 | Sullivan | New York | 36105 | 109 | 1 |
23492 | 23492 | 2020-03-31 | Sullivan | Tennessee | 47163 | 11 | 0 |
24497 | 24497 | 2020-04-01 | Sullivan | Indiana | 18153 | 3 | 0 |
25135 | 25135 | 2020-04-01 | Sullivan | New Hampshire | 33019 | 4 | 1 |
25227 | 25227 | 2020-04-01 | Sullivan | New York | 36105 | 121 | 4 |
25695 | 25695 | 2020-04-01 | Sullivan | Tennessee | 47163 | 17 | 0 |
26737 | 26737 | 2020-04-02 | Sullivan | Indiana | 18153 | 3 | 0 |
27395 | 27395 | 2020-04-02 | Sullivan | New Hampshire | 33019 | 5 | 1 |
27487 | 27487 | 2020-04-02 | Sullivan | New York | 36105 | 156 | 5 |
27975 | 27975 | 2020-04-02 | Sullivan | Tennessee | 47163 | 17 | 1 |
29048 | 29048 | 2020-04-03 | Sullivan | Indiana | 18153 | 3 | 0 |
29718 | 29718 | 2020-04-03 | Sullivan | New Hampshire | 33019 | 5 | 1 |
29811 | 29811 | 2020-04-03 | Sullivan | New York | 36105 | 156 | 5 |
30310 | 30310 | 2020-04-03 | Sullivan | Tennessee | 47163 | 18 | 1 |
31415 | 31415 | 2020-04-04 | Sullivan | Indiana | 18153 | 3 | 0 |
32102 | 32102 | 2020-04-04 | Sullivan | New Hampshire | 33019 | 5 | 1 |
32197 | 32197 | 2020-04-04 | Sullivan | New York | 36105 | 193 | 5 |
32534 | 32534 | 2020-04-04 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
32702 | 32702 | 2020-04-04 | Sullivan | Tennessee | 47163 | 18 | 1 |
33826 | 33826 | 2020-04-05 | Sullivan | Indiana | 18153 | 3 | 0 |
34533 | 34533 | 2020-04-05 | Sullivan | New Hampshire | 33019 | 6 | 1 |
34628 | 34628 | 2020-04-05 | Sullivan | New York | 36105 | 234 | 5 |
34970 | 34970 | 2020-04-05 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
35139 | 35139 | 2020-04-05 | Sullivan | Tennessee | 47163 | 21 | 1 |
36280 | 36280 | 2020-04-06 | Sullivan | Indiana | 18153 | 3 | 0 |
37003 | 37003 | 2020-04-06 | Sullivan | New Hampshire | 33019 | 6 | 1 |
37098 | 37098 | 2020-04-06 | Sullivan | New York | 36105 | 259 | 7 |
37445 | 37445 | 2020-04-06 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
37615 | 37615 | 2020-04-06 | Sullivan | Tennessee | 47163 | 25 | 1 |
38778 | 38778 | 2020-04-07 | Sullivan | Indiana | 18153 | 3 | 0 |
39518 | 39518 | 2020-04-07 | Sullivan | New Hampshire | 33019 | 6 | 1 |
39613 | 39613 | 2020-04-07 | Sullivan | New York | 36105 | 270 | 7 |
39968 | 39968 | 2020-04-07 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
40138 | 40138 | 2020-04-07 | Sullivan | Tennessee | 47163 | 26 | 1 |
41324 | 41324 | 2020-04-08 | Sullivan | Indiana | 18153 | 4 | 0 |
42075 | 42075 | 2020-04-08 | Sullivan | New Hampshire | 33019 | 6 | 1 |
42170 | 42170 | 2020-04-08 | Sullivan | New York | 36105 | 279 | 7 |
42528 | 42528 | 2020-04-08 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
42700 | 42700 | 2020-04-08 | Sullivan | Tennessee | 47163 | 27 | 1 |
43900 | 43900 | 2020-04-09 | Sullivan | Indiana | 18153 | 4 | 0 |
44658 | 44658 | 2020-04-09 | Sullivan | New Hampshire | 33019 | 6 | 1 |
44753 | 44753 | 2020-04-09 | Sullivan | New York | 36105 | 294 | 7 |
45114 | 45114 | 2020-04-09 | Sullivan | Pennsylvania | 42113 | 1 | 0 |
45287 | 45287 | 2020-04-09 | Sullivan | Tennessee | 47163 | 34 | 1 |
46505 | 46505 | 2020-04-10 | Sullivan | Indiana | 18153 | 4 | 0 |
47270 | 47270 | 2020-04-10 | Sullivan | New Hampshire | 33019 | 6 | 1 |
47366 | 47366 | 2020-04-10 | Sullivan | New York | 36105 | 318 | 7 |
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);