ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sullivan" and state = "New York" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3560 | 3560 | 2020-03-17 | Sullivan | New York | 36105 | 1 | 0 |
4161 | 4161 | 2020-03-18 | Sullivan | New York | 36105 | 1 | 0 |
4891 | 4891 | 2020-03-19 | Sullivan | New York | 36105 | 8 | 0 |
5742 | 5742 | 2020-03-20 | Sullivan | New York | 36105 | 8 | 0 |
6737 | 6737 | 2020-03-21 | Sullivan | New York | 36105 | 12 | 0 |
7833 | 7833 | 2020-03-22 | Sullivan | New York | 36105 | 16 | 0 |
9033 | 9033 | 2020-03-23 | Sullivan | New York | 36105 | 23 | 0 |
10341 | 10341 | 2020-03-24 | Sullivan | New York | 36105 | 30 | 0 |
11777 | 11777 | 2020-03-25 | Sullivan | New York | 36105 | 39 | 0 |
13380 | 13380 | 2020-03-26 | Sullivan | New York | 36105 | 53 | 0 |
15114 | 15114 | 2020-03-27 | Sullivan | New York | 36105 | 64 | 0 |
16945 | 16945 | 2020-03-28 | Sullivan | New York | 36105 | 72 | 0 |
18870 | 18870 | 2020-03-29 | Sullivan | New York | 36105 | 88 | 0 |
20909 | 20909 | 2020-03-30 | Sullivan | New York | 36105 | 101 | 0 |
23033 | 23033 | 2020-03-31 | Sullivan | New York | 36105 | 109 | 1 |
25227 | 25227 | 2020-04-01 | Sullivan | New York | 36105 | 121 | 4 |
27487 | 27487 | 2020-04-02 | Sullivan | New York | 36105 | 156 | 5 |
29811 | 29811 | 2020-04-03 | Sullivan | New York | 36105 | 156 | 5 |
32197 | 32197 | 2020-04-04 | Sullivan | New York | 36105 | 193 | 5 |
34628 | 34628 | 2020-04-05 | Sullivan | New York | 36105 | 234 | 5 |
37098 | 37098 | 2020-04-06 | Sullivan | New York | 36105 | 259 | 7 |
39613 | 39613 | 2020-04-07 | Sullivan | New York | 36105 | 270 | 7 |
42170 | 42170 | 2020-04-08 | Sullivan | New York | 36105 | 279 | 7 |
44753 | 44753 | 2020-04-09 | Sullivan | New York | 36105 | 294 | 7 |
47366 | 47366 | 2020-04-10 | Sullivan | New York | 36105 | 318 | 7 |
50021 | 50021 | 2020-04-11 | Sullivan | New York | 36105 | 340 | 7 |
52694 | 52694 | 2020-04-12 | Sullivan | New York | 36105 | 358 | 7 |
55377 | 55377 | 2020-04-13 | Sullivan | New York | 36105 | 380 | 7 |
58077 | 58077 | 2020-04-14 | Sullivan | New York | 36105 | 415 | 7 |
60791 | 60791 | 2020-04-15 | Sullivan | New York | 36105 | 424 | 7 |
63517 | 63517 | 2020-04-16 | Sullivan | New York | 36105 | 437 | 7 |
66259 | 66259 | 2020-04-17 | Sullivan | New York | 36105 | 505 | 7 |
69016 | 69016 | 2020-04-18 | Sullivan | New York | 36105 | 524 | 7 |
71783 | 71783 | 2020-04-19 | Sullivan | New York | 36105 | 537 | 8 |
74558 | 74558 | 2020-04-20 | Sullivan | New York | 36105 | 544 | 8 |
77339 | 77339 | 2020-04-21 | Sullivan | New York | 36105 | 555 | 8 |
80128 | 80128 | 2020-04-22 | Sullivan | New York | 36105 | 561 | 8 |
82927 | 82927 | 2020-04-23 | Sullivan | New York | 36105 | 580 | 8 |
85731 | 85731 | 2020-04-24 | Sullivan | New York | 36105 | 628 | 9 |
88543 | 88543 | 2020-04-25 | Sullivan | New York | 36105 | 689 | 9 |
91358 | 91358 | 2020-04-26 | Sullivan | New York | 36105 | 724 | 10 |
94183 | 94183 | 2020-04-27 | Sullivan | New York | 36105 | 748 | 11 |
97019 | 97019 | 2020-04-28 | Sullivan | New York | 36105 | 769 | 12 |
99866 | 99866 | 2020-04-29 | Sullivan | New York | 36105 | 811 | 12 |
102719 | 102719 | 2020-04-30 | Sullivan | New York | 36105 | 838 | 12 |
105581 | 105581 | 2020-05-01 | Sullivan | New York | 36105 | 880 | 12 |
108448 | 108448 | 2020-05-02 | Sullivan | New York | 36105 | 931 | 12 |
111321 | 111321 | 2020-05-03 | Sullivan | New York | 36105 | 951 | 13 |
114202 | 114202 | 2020-05-04 | Sullivan | New York | 36105 | 976 | 13 |
117082 | 117082 | 2020-05-05 | Sullivan | New York | 36105 | 984 | 13 |
120043 | 120043 | 2020-05-06 | Sullivan | New York | 36105 | 996 | 20 |
123018 | 123018 | 2020-05-07 | Sullivan | New York | 36105 | 1021 | 20 |
126001 | 126001 | 2020-05-08 | Sullivan | New York | 36105 | 1039 | 20 |
128990 | 128990 | 2020-05-09 | Sullivan | New York | 36105 | 1071 | 20 |
131979 | 131979 | 2020-05-10 | Sullivan | New York | 36105 | 1093 | 22 |
134970 | 134970 | 2020-05-11 | Sullivan | New York | 36105 | 1109 | 22 |
137960 | 137960 | 2020-05-12 | Sullivan | New York | 36105 | 1119 | 24 |
140956 | 140956 | 2020-05-13 | Sullivan | New York | 36105 | 1135 | 24 |
143951 | 143951 | 2020-05-14 | Sullivan | New York | 36105 | 1168 | 24 |
146952 | 146952 | 2020-05-15 | Sullivan | New York | 36105 | 1189 | 24 |
149959 | 149959 | 2020-05-16 | Sullivan | New York | 36105 | 1217 | 24 |
152969 | 152969 | 2020-05-17 | Sullivan | New York | 36105 | 1231 | 24 |
155986 | 155986 | 2020-05-18 | Sullivan | New York | 36105 | 1246 | 24 |
159004 | 159004 | 2020-05-19 | Sullivan | New York | 36105 | 1258 | 24 |
162031 | 162031 | 2020-05-20 | Sullivan | New York | 36105 | 1267 | 24 |
165060 | 165060 | 2020-05-21 | Sullivan | New York | 36105 | 1281 | 24 |
168095 | 168095 | 2020-05-22 | Sullivan | New York | 36105 | 1287 | 24 |
171134 | 171134 | 2020-05-23 | Sullivan | New York | 36105 | 1297 | 24 |
174176 | 174176 | 2020-05-24 | Sullivan | New York | 36105 | 1310 | 26 |
177220 | 177220 | 2020-05-25 | Sullivan | New York | 36105 | 1324 | 26 |
180263 | 180263 | 2020-05-26 | Sullivan | New York | 36105 | 1338 | 27 |
183311 | 183311 | 2020-05-27 | Sullivan | New York | 36105 | 1340 | 27 |
186368 | 186368 | 2020-05-28 | Sullivan | New York | 36105 | 1351 | 27 |
189428 | 189428 | 2020-05-29 | Sullivan | New York | 36105 | 1364 | 28 |
192492 | 192492 | 2020-05-30 | Sullivan | New York | 36105 | 1375 | 28 |
195562 | 195562 | 2020-05-31 | Sullivan | New York | 36105 | 1387 | 29 |
198635 | 198635 | 2020-06-01 | Sullivan | New York | 36105 | 1389 | 29 |
201709 | 201709 | 2020-06-02 | Sullivan | New York | 36105 | 1392 | 29 |
204786 | 204786 | 2020-06-03 | Sullivan | New York | 36105 | 1393 | 29 |
207867 | 207867 | 2020-06-04 | Sullivan | New York | 36105 | 1405 | 29 |
210949 | 210949 | 2020-06-05 | Sullivan | New York | 36105 | 1409 | 31 |
214033 | 214033 | 2020-06-06 | Sullivan | New York | 36105 | 1411 | 31 |
217123 | 217123 | 2020-06-07 | Sullivan | New York | 36105 | 1415 | 31 |
220215 | 220215 | 2020-06-08 | Sullivan | New York | 36105 | 1417 | 31 |
223309 | 223309 | 2020-06-09 | Sullivan | New York | 36105 | 1418 | 31 |
226409 | 226409 | 2020-06-10 | Sullivan | New York | 36105 | 1425 | 31 |
229513 | 229513 | 2020-06-11 | Sullivan | New York | 36105 | 1426 | 31 |
232618 | 232618 | 2020-06-12 | Sullivan | New York | 36105 | 1428 | 31 |
235723 | 235723 | 2020-06-13 | Sullivan | New York | 36105 | 1430 | 31 |
238831 | 238831 | 2020-06-14 | Sullivan | New York | 36105 | 1430 | 31 |
241940 | 241940 | 2020-06-15 | Sullivan | New York | 36105 | 1432 | 31 |
245052 | 245052 | 2020-06-16 | Sullivan | New York | 36105 | 1433 | 31 |
248165 | 248165 | 2020-06-17 | Sullivan | New York | 36105 | 1433 | 31 |
251280 | 251280 | 2020-06-18 | Sullivan | New York | 36105 | 1434 | 31 |
254395 | 254395 | 2020-06-19 | Sullivan | New York | 36105 | 1434 | 31 |
257518 | 257518 | 2020-06-20 | Sullivan | New York | 36105 | 1435 | 31 |
260645 | 260645 | 2020-06-21 | Sullivan | New York | 36105 | 1437 | 31 |
263773 | 263773 | 2020-06-22 | Sullivan | New York | 36105 | 1438 | 31 |
266901 | 266901 | 2020-06-23 | Sullivan | New York | 36105 | 1440 | 31 |
270035 | 270035 | 2020-06-24 | Sullivan | New York | 36105 | 1447 | 31 |
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);