ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and fips = 27027 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- Minnesota 785
fips 1
- 27027 · 785 ✖
county 1
- Clay · 785 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5586 | 5586 | 2020-03-20 | Clay | Minnesota | 27027 | 1 | 0 |
6554 | 6554 | 2020-03-21 | Clay | Minnesota | 27027 | 1 | 0 |
7635 | 7635 | 2020-03-22 | Clay | Minnesota | 27027 | 2 | 0 |
8813 | 8813 | 2020-03-23 | Clay | Minnesota | 27027 | 2 | 0 |
10108 | 10108 | 2020-03-24 | Clay | Minnesota | 27027 | 3 | 0 |
11525 | 11525 | 2020-03-25 | Clay | Minnesota | 27027 | 3 | 0 |
13113 | 13113 | 2020-03-26 | Clay | Minnesota | 27027 | 4 | 0 |
14826 | 14826 | 2020-03-27 | Clay | Minnesota | 27027 | 4 | 0 |
16647 | 16647 | 2020-03-28 | Clay | Minnesota | 27027 | 4 | 0 |
18563 | 18563 | 2020-03-29 | Clay | Minnesota | 27027 | 4 | 0 |
20583 | 20583 | 2020-03-30 | Clay | Minnesota | 27027 | 4 | 0 |
22697 | 22697 | 2020-03-31 | Clay | Minnesota | 27027 | 6 | 0 |
24877 | 24877 | 2020-04-01 | Clay | Minnesota | 27027 | 7 | 0 |
27130 | 27130 | 2020-04-02 | Clay | Minnesota | 27027 | 8 | 0 |
29449 | 29449 | 2020-04-03 | Clay | Minnesota | 27027 | 8 | 0 |
31827 | 31827 | 2020-04-04 | Clay | Minnesota | 27027 | 13 | 0 |
34252 | 34252 | 2020-04-05 | Clay | Minnesota | 27027 | 13 | 0 |
36712 | 36712 | 2020-04-06 | Clay | Minnesota | 27027 | 19 | 0 |
39221 | 39221 | 2020-04-07 | Clay | Minnesota | 27027 | 19 | 0 |
41774 | 41774 | 2020-04-08 | Clay | Minnesota | 27027 | 20 | 0 |
44350 | 44350 | 2020-04-09 | Clay | Minnesota | 27027 | 23 | 0 |
46959 | 46959 | 2020-04-10 | Clay | Minnesota | 27027 | 29 | 0 |
49604 | 49604 | 2020-04-11 | Clay | Minnesota | 27027 | 29 | 0 |
52274 | 52274 | 2020-04-12 | Clay | Minnesota | 27027 | 40 | 0 |
54956 | 54956 | 2020-04-13 | Clay | Minnesota | 27027 | 40 | 0 |
57654 | 57654 | 2020-04-14 | Clay | Minnesota | 27027 | 42 | 0 |
60364 | 60364 | 2020-04-15 | Clay | Minnesota | 27027 | 43 | 1 |
63086 | 63086 | 2020-04-16 | Clay | Minnesota | 27027 | 43 | 1 |
65825 | 65825 | 2020-04-17 | Clay | Minnesota | 27027 | 44 | 2 |
68576 | 68576 | 2020-04-18 | Clay | Minnesota | 27027 | 48 | 2 |
71340 | 71340 | 2020-04-19 | Clay | Minnesota | 27027 | 55 | 2 |
74113 | 74113 | 2020-04-20 | Clay | Minnesota | 27027 | 62 | 3 |
76893 | 76893 | 2020-04-21 | Clay | Minnesota | 27027 | 68 | 3 |
79678 | 79678 | 2020-04-22 | Clay | Minnesota | 27027 | 79 | 3 |
82474 | 82474 | 2020-04-23 | Clay | Minnesota | 27027 | 84 | 4 |
85278 | 85278 | 2020-04-24 | Clay | Minnesota | 27027 | 100 | 4 |
88088 | 88088 | 2020-04-25 | Clay | Minnesota | 27027 | 113 | 7 |
90904 | 90904 | 2020-04-26 | Clay | Minnesota | 27027 | 125 | 9 |
93725 | 93725 | 2020-04-27 | Clay | Minnesota | 27027 | 131 | 9 |
96560 | 96560 | 2020-04-28 | Clay | Minnesota | 27027 | 149 | 10 |
99406 | 99406 | 2020-04-29 | Clay | Minnesota | 27027 | 152 | 10 |
102258 | 102258 | 2020-04-30 | Clay | Minnesota | 27027 | 157 | 11 |
105118 | 105118 | 2020-05-01 | Clay | Minnesota | 27027 | 165 | 11 |
107982 | 107982 | 2020-05-02 | Clay | Minnesota | 27027 | 169 | 13 |
110853 | 110853 | 2020-05-03 | Clay | Minnesota | 27027 | 176 | 13 |
113732 | 113732 | 2020-05-04 | Clay | Minnesota | 27027 | 190 | 13 |
116613 | 116613 | 2020-05-05 | Clay | Minnesota | 27027 | 201 | 14 |
119573 | 119573 | 2020-05-06 | Clay | Minnesota | 27027 | 215 | 14 |
122546 | 122546 | 2020-05-07 | Clay | Minnesota | 27027 | 222 | 15 |
125528 | 125528 | 2020-05-08 | Clay | Minnesota | 27027 | 229 | 15 |
128515 | 128515 | 2020-05-09 | Clay | Minnesota | 27027 | 233 | 16 |
131505 | 131505 | 2020-05-10 | Clay | Minnesota | 27027 | 235 | 17 |
134496 | 134496 | 2020-05-11 | Clay | Minnesota | 27027 | 247 | 17 |
137486 | 137486 | 2020-05-12 | Clay | Minnesota | 27027 | 254 | 17 |
140480 | 140480 | 2020-05-13 | Clay | Minnesota | 27027 | 254 | 17 |
143475 | 143475 | 2020-05-14 | Clay | Minnesota | 27027 | 273 | 18 |
146475 | 146475 | 2020-05-15 | Clay | Minnesota | 27027 | 279 | 18 |
149480 | 149480 | 2020-05-16 | Clay | Minnesota | 27027 | 291 | 19 |
152491 | 152491 | 2020-05-17 | Clay | Minnesota | 27027 | 293 | 20 |
155505 | 155505 | 2020-05-18 | Clay | Minnesota | 27027 | 310 | 20 |
158523 | 158523 | 2020-05-19 | Clay | Minnesota | 27027 | 318 | 21 |
161549 | 161549 | 2020-05-20 | Clay | Minnesota | 27027 | 328 | 21 |
164578 | 164578 | 2020-05-21 | Clay | Minnesota | 27027 | 344 | 22 |
167614 | 167614 | 2020-05-22 | Clay | Minnesota | 27027 | 356 | 22 |
170651 | 170651 | 2020-05-23 | Clay | Minnesota | 27027 | 361 | 23 |
173693 | 173693 | 2020-05-24 | Clay | Minnesota | 27027 | 366 | 23 |
176736 | 176736 | 2020-05-25 | Clay | Minnesota | 27027 | 373 | 24 |
179780 | 179780 | 2020-05-26 | Clay | Minnesota | 27027 | 386 | 25 |
182826 | 182826 | 2020-05-27 | Clay | Minnesota | 27027 | 406 | 25 |
185881 | 185881 | 2020-05-28 | Clay | Minnesota | 27027 | 416 | 25 |
188939 | 188939 | 2020-05-29 | Clay | Minnesota | 27027 | 420 | 25 |
195071 | 195071 | 2020-05-31 | Clay | Minnesota | 27027 | 423 | 28 |
192003 | 192003 | 2020-05-30 | Clay | Minnesota | 27027 | 424 | 26 |
198142 | 198142 | 2020-06-01 | Clay | Minnesota | 27027 | 427 | 28 |
201215 | 201215 | 2020-06-02 | Clay | Minnesota | 27027 | 430 | 29 |
204292 | 204292 | 2020-06-03 | Clay | Minnesota | 27027 | 435 | 29 |
207373 | 207373 | 2020-06-04 | Clay | Minnesota | 27027 | 441 | 29 |
210454 | 210454 | 2020-06-05 | Clay | Minnesota | 27027 | 449 | 30 |
213538 | 213538 | 2020-06-06 | Clay | Minnesota | 27027 | 457 | 30 |
216626 | 216626 | 2020-06-07 | Clay | Minnesota | 27027 | 462 | 30 |
219718 | 219718 | 2020-06-08 | Clay | Minnesota | 27027 | 469 | 30 |
222813 | 222813 | 2020-06-09 | Clay | Minnesota | 27027 | 481 | 30 |
225911 | 225911 | 2020-06-10 | Clay | Minnesota | 27027 | 490 | 31 |
229013 | 229013 | 2020-06-11 | Clay | Minnesota | 27027 | 499 | 31 |
232117 | 232117 | 2020-06-12 | Clay | Minnesota | 27027 | 503 | 36 |
238329 | 238329 | 2020-06-14 | Clay | Minnesota | 27027 | 504 | 36 |
241438 | 241438 | 2020-06-15 | Clay | Minnesota | 27027 | 506 | 36 |
244549 | 244549 | 2020-06-16 | Clay | Minnesota | 27027 | 506 | 37 |
235222 | 235222 | 2020-06-13 | Clay | Minnesota | 27027 | 507 | 36 |
247662 | 247662 | 2020-06-17 | Clay | Minnesota | 27027 | 512 | 37 |
250774 | 250774 | 2020-06-18 | Clay | Minnesota | 27027 | 516 | 37 |
253889 | 253889 | 2020-06-19 | Clay | Minnesota | 27027 | 521 | 37 |
257009 | 257009 | 2020-06-20 | Clay | Minnesota | 27027 | 522 | 37 |
260135 | 260135 | 2020-06-21 | Clay | Minnesota | 27027 | 526 | 37 |
263264 | 263264 | 2020-06-22 | Clay | Minnesota | 27027 | 528 | 37 |
266390 | 266390 | 2020-06-23 | Clay | Minnesota | 27027 | 530 | 37 |
269523 | 269523 | 2020-06-24 | Clay | Minnesota | 27027 | 537 | 37 |
272660 | 272660 | 2020-06-25 | Clay | Minnesota | 27027 | 537 | 37 |
275803 | 275803 | 2020-06-26 | Clay | Minnesota | 27027 | 545 | 37 |
278951 | 278951 | 2020-06-27 | Clay | Minnesota | 27027 | 556 | 37 |
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);