ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where county = "Westchester" and state = "New York" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- …
state 1
- New York · 801 ✖
fips 1
- 36119 801
county 1
- Westchester · 801 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
520 | 520 | 2020-03-04 | Westchester | New York | 36119 | 9 | 0 |
567 | 567 | 2020-03-05 | Westchester | New York | 36119 | 17 | 0 |
630 | 630 | 2020-03-06 | Westchester | New York | 36119 | 33 | 0 |
719 | 719 | 2020-03-07 | Westchester | New York | 36119 | 69 | 0 |
826 | 826 | 2020-03-08 | Westchester | New York | 36119 | 81 | 0 |
953 | 953 | 2020-03-09 | Westchester | New York | 36119 | 97 | 0 |
1104 | 1104 | 2020-03-10 | Westchester | New York | 36119 | 107 | 0 |
1291 | 1291 | 2020-03-11 | Westchester | New York | 36119 | 120 | 0 |
1528 | 1528 | 2020-03-12 | Westchester | New York | 36119 | 147 | 0 |
1822 | 1822 | 2020-03-13 | Westchester | New York | 36119 | 157 | 0 |
2173 | 2173 | 2020-03-14 | Westchester | New York | 36119 | 178 | 0 |
2585 | 2585 | 2020-03-15 | Westchester | New York | 36119 | 195 | 0 |
3046 | 3046 | 2020-03-16 | Westchester | New York | 36119 | 219 | 0 |
3564 | 3564 | 2020-03-17 | Westchester | New York | 36119 | 379 | 0 |
4167 | 4167 | 2020-03-18 | Westchester | New York | 36119 | 537 | 0 |
4898 | 4898 | 2020-03-19 | Westchester | New York | 36119 | 797 | 0 |
5749 | 5749 | 2020-03-20 | Westchester | New York | 36119 | 1091 | 0 |
6744 | 6744 | 2020-03-21 | Westchester | New York | 36119 | 1387 | 0 |
7840 | 7840 | 2020-03-22 | Westchester | New York | 36119 | 1873 | 0 |
9040 | 9040 | 2020-03-23 | Westchester | New York | 36119 | 2894 | 0 |
10348 | 10348 | 2020-03-24 | Westchester | New York | 36119 | 3891 | 6 |
11784 | 11784 | 2020-03-25 | Westchester | New York | 36119 | 4691 | 6 |
13387 | 13387 | 2020-03-26 | Westchester | New York | 36119 | 5944 | 8 |
15121 | 15121 | 2020-03-27 | Westchester | New York | 36119 | 7187 | 10 |
16952 | 16952 | 2020-03-28 | Westchester | New York | 36119 | 7875 | 10 |
18878 | 18878 | 2020-03-29 | Westchester | New York | 36119 | 8519 | 10 |
20917 | 20917 | 2020-03-30 | Westchester | New York | 36119 | 9326 | 19 |
23041 | 23041 | 2020-03-31 | Westchester | New York | 36119 | 9967 | 25 |
25235 | 25235 | 2020-04-01 | Westchester | New York | 36119 | 10683 | 25 |
27495 | 27495 | 2020-04-02 | Westchester | New York | 36119 | 11566 | 67 |
29819 | 29819 | 2020-04-03 | Westchester | New York | 36119 | 12350 | 67 |
32205 | 32205 | 2020-04-04 | Westchester | New York | 36119 | 13080 | 197 |
34636 | 34636 | 2020-04-05 | Westchester | New York | 36119 | 13722 | 197 |
37105 | 37105 | 2020-04-06 | Westchester | New York | 36119 | 14293 | 253 |
39620 | 39620 | 2020-04-07 | Westchester | New York | 36119 | 14804 | 304 |
42177 | 42177 | 2020-04-08 | Westchester | New York | 36119 | 15887 | 343 |
44760 | 44760 | 2020-04-09 | Westchester | New York | 36119 | 17004 | 389 |
47373 | 47373 | 2020-04-10 | Westchester | New York | 36119 | 18077 | 428 |
50028 | 50028 | 2020-04-11 | Westchester | New York | 36119 | 18729 | 505 |
52701 | 52701 | 2020-04-12 | Westchester | New York | 36119 | 19313 | 562 |
55384 | 55384 | 2020-04-13 | Westchester | New York | 36119 | 19785 | 610 |
58084 | 58084 | 2020-04-14 | Westchester | New York | 36119 | 20191 | 654 |
60798 | 60798 | 2020-04-15 | Westchester | New York | 36119 | 20947 | 708 |
63524 | 63524 | 2020-04-16 | Westchester | New York | 36119 | 21828 | 738 |
66267 | 66267 | 2020-04-17 | Westchester | New York | 36119 | 22476 | 738 |
69024 | 69024 | 2020-04-18 | Westchester | New York | 36119 | 23179 | 738 |
71790 | 71790 | 2020-04-19 | Westchester | New York | 36119 | 23803 | 831 |
74565 | 74565 | 2020-04-20 | Westchester | New York | 36119 | 24306 | 867 |
77346 | 77346 | 2020-04-21 | Westchester | New York | 36119 | 24655 | 904 |
80135 | 80135 | 2020-04-22 | Westchester | New York | 36119 | 25275 | 932 |
82934 | 82934 | 2020-04-23 | Westchester | New York | 36119 | 25959 | 962 |
85738 | 85738 | 2020-04-24 | Westchester | New York | 36119 | 26632 | 989 |
88550 | 88550 | 2020-04-25 | Westchester | New York | 36119 | 27230 | 1022 |
91365 | 91365 | 2020-04-26 | Westchester | New York | 36119 | 27664 | 1054 |
94190 | 94190 | 2020-04-27 | Westchester | New York | 36119 | 28007 | 1077 |
97026 | 97026 | 2020-04-28 | Westchester | New York | 36119 | 28245 | 1096 |
99873 | 99873 | 2020-04-29 | Westchester | New York | 36119 | 28625 | 1119 |
102726 | 102726 | 2020-04-30 | Westchester | New York | 36119 | 28969 | 1144 |
105588 | 105588 | 2020-05-01 | Westchester | New York | 36119 | 29231 | 1165 |
108455 | 108455 | 2020-05-02 | Westchester | New York | 36119 | 29626 | 1183 |
111328 | 111328 | 2020-05-03 | Westchester | New York | 36119 | 29884 | 1203 |
114209 | 114209 | 2020-05-04 | Westchester | New York | 36119 | 30097 | 1220 |
117089 | 117089 | 2020-05-05 | Westchester | New York | 36119 | 30239 | 1236 |
120050 | 120050 | 2020-05-06 | Westchester | New York | 36119 | 30426 | 1285 |
123025 | 123025 | 2020-05-07 | Westchester | New York | 36119 | 30709 | 1305 |
126008 | 126008 | 2020-05-08 | Westchester | New York | 36119 | 30904 | 1316 |
128997 | 128997 | 2020-05-09 | Westchester | New York | 36119 | 31086 | 1328 |
131986 | 131986 | 2020-05-10 | Westchester | New York | 36119 | 31293 | 1341 |
134977 | 134977 | 2020-05-11 | Westchester | New York | 36119 | 31383 | 1349 |
137967 | 137967 | 2020-05-12 | Westchester | New York | 36119 | 31471 | 1360 |
140963 | 140963 | 2020-05-13 | Westchester | New York | 36119 | 31610 | 1368 |
143958 | 143958 | 2020-05-14 | Westchester | New York | 36119 | 31791 | 1380 |
146959 | 146959 | 2020-05-15 | Westchester | New York | 36119 | 31942 | 1392 |
149966 | 149966 | 2020-05-16 | Westchester | New York | 36119 | 32096 | 1398 |
152976 | 152976 | 2020-05-17 | Westchester | New York | 36119 | 32223 | 1412 |
155993 | 155993 | 2020-05-18 | Westchester | New York | 36119 | 32322 | 1419 |
159011 | 159011 | 2020-05-19 | Westchester | New York | 36119 | 32401 | 1424 |
162038 | 162038 | 2020-05-20 | Westchester | New York | 36119 | 32516 | 1430 |
165067 | 165067 | 2020-05-21 | Westchester | New York | 36119 | 32672 | 1438 |
168102 | 168102 | 2020-05-22 | Westchester | New York | 36119 | 32766 | 1444 |
171141 | 171141 | 2020-05-23 | Westchester | New York | 36119 | 32880 | 1451 |
174183 | 174183 | 2020-05-24 | Westchester | New York | 36119 | 32967 | 1462 |
177227 | 177227 | 2020-05-25 | Westchester | New York | 36119 | 33048 | 1467 |
180270 | 180270 | 2020-05-26 | Westchester | New York | 36119 | 33106 | 1469 |
183318 | 183318 | 2020-05-27 | Westchester | New York | 36119 | 33185 | 1476 |
186375 | 186375 | 2020-05-28 | Westchester | New York | 36119 | 33292 | 1481 |
189435 | 189435 | 2020-05-29 | Westchester | New York | 36119 | 33348 | 1484 |
192499 | 192499 | 2020-05-30 | Westchester | New York | 36119 | 33428 | 1492 |
195569 | 195569 | 2020-05-31 | Westchester | New York | 36119 | 33480 | 1499 |
198642 | 198642 | 2020-06-01 | Westchester | New York | 36119 | 33551 | 1501 |
201716 | 201716 | 2020-06-02 | Westchester | New York | 36119 | 33632 | 1506 |
204793 | 204793 | 2020-06-03 | Westchester | New York | 36119 | 33690 | 1510 |
207874 | 207874 | 2020-06-04 | Westchester | New York | 36119 | 33766 | 1514 |
210956 | 210956 | 2020-06-05 | Westchester | New York | 36119 | 33853 | 1519 |
214040 | 214040 | 2020-06-06 | Westchester | New York | 36119 | 33923 | 1523 |
217130 | 217130 | 2020-06-07 | Westchester | New York | 36119 | 33953 | 1523 |
220222 | 220222 | 2020-06-08 | Westchester | New York | 36119 | 33999 | 1526 |
223316 | 223316 | 2020-06-09 | Westchester | New York | 36119 | 34034 | 1527 |
226416 | 226416 | 2020-06-10 | Westchester | New York | 36119 | 34075 | 1530 |
229520 | 229520 | 2020-06-11 | Westchester | New York | 36119 | 34105 | 1531 |
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);