ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and state = "Iowa" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- …
state 1
- Iowa · 775 ✖
fips 1
- 19047 775
county 1
- Crawford · 775 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
20260 | 20260 | 2020-03-30 | Crawford | Iowa | 19047 | 1 | 0 |
22356 | 22356 | 2020-03-31 | Crawford | Iowa | 19047 | 1 | 0 |
24528 | 24528 | 2020-04-01 | Crawford | Iowa | 19047 | 1 | 0 |
26769 | 26769 | 2020-04-02 | Crawford | Iowa | 19047 | 1 | 0 |
29080 | 29080 | 2020-04-03 | Crawford | Iowa | 19047 | 4 | 0 |
31448 | 31448 | 2020-04-04 | Crawford | Iowa | 19047 | 4 | 0 |
33860 | 33860 | 2020-04-05 | Crawford | Iowa | 19047 | 4 | 0 |
36314 | 36314 | 2020-04-06 | Crawford | Iowa | 19047 | 5 | 0 |
38813 | 38813 | 2020-04-07 | Crawford | Iowa | 19047 | 5 | 0 |
41359 | 41359 | 2020-04-08 | Crawford | Iowa | 19047 | 6 | 0 |
43935 | 43935 | 2020-04-09 | Crawford | Iowa | 19047 | 6 | 0 |
46540 | 46540 | 2020-04-10 | Crawford | Iowa | 19047 | 6 | 0 |
49174 | 49174 | 2020-04-11 | Crawford | Iowa | 19047 | 6 | 1 |
51838 | 51838 | 2020-04-12 | Crawford | Iowa | 19047 | 6 | 1 |
54520 | 54520 | 2020-04-13 | Crawford | Iowa | 19047 | 6 | 1 |
57213 | 57213 | 2020-04-14 | Crawford | Iowa | 19047 | 6 | 1 |
59921 | 59921 | 2020-04-15 | Crawford | Iowa | 19047 | 6 | 1 |
62642 | 62642 | 2020-04-16 | Crawford | Iowa | 19047 | 6 | 1 |
65376 | 65376 | 2020-04-17 | Crawford | Iowa | 19047 | 6 | 1 |
68125 | 68125 | 2020-04-18 | Crawford | Iowa | 19047 | 6 | 1 |
70887 | 70887 | 2020-04-19 | Crawford | Iowa | 19047 | 6 | 1 |
73658 | 73658 | 2020-04-20 | Crawford | Iowa | 19047 | 6 | 1 |
76436 | 76436 | 2020-04-21 | Crawford | Iowa | 19047 | 6 | 1 |
79220 | 79220 | 2020-04-22 | Crawford | Iowa | 19047 | 6 | 1 |
82013 | 82013 | 2020-04-23 | Crawford | Iowa | 19047 | 6 | 1 |
84813 | 84813 | 2020-04-24 | Crawford | Iowa | 19047 | 8 | 1 |
87623 | 87623 | 2020-04-25 | Crawford | Iowa | 19047 | 10 | 1 |
90439 | 90439 | 2020-04-26 | Crawford | Iowa | 19047 | 14 | 1 |
93258 | 93258 | 2020-04-27 | Crawford | Iowa | 19047 | 14 | 1 |
96090 | 96090 | 2020-04-28 | Crawford | Iowa | 19047 | 19 | 1 |
98934 | 98934 | 2020-04-29 | Crawford | Iowa | 19047 | 21 | 1 |
101785 | 101785 | 2020-04-30 | Crawford | Iowa | 19047 | 21 | 1 |
104642 | 104642 | 2020-05-01 | Crawford | Iowa | 19047 | 24 | 1 |
107507 | 107507 | 2020-05-02 | Crawford | Iowa | 19047 | 31 | 1 |
110377 | 110377 | 2020-05-03 | Crawford | Iowa | 19047 | 51 | 1 |
113252 | 113252 | 2020-05-04 | Crawford | Iowa | 19047 | 78 | 1 |
116135 | 116135 | 2020-05-05 | Crawford | Iowa | 19047 | 96 | 1 |
119095 | 119095 | 2020-05-06 | Crawford | Iowa | 19047 | 103 | 1 |
122065 | 122065 | 2020-05-07 | Crawford | Iowa | 19047 | 124 | 1 |
125045 | 125045 | 2020-05-08 | Crawford | Iowa | 19047 | 149 | 1 |
128032 | 128032 | 2020-05-09 | Crawford | Iowa | 19047 | 175 | 1 |
131023 | 131023 | 2020-05-10 | Crawford | Iowa | 19047 | 176 | 1 |
134013 | 134013 | 2020-05-11 | Crawford | Iowa | 19047 | 191 | 1 |
137002 | 137002 | 2020-05-12 | Crawford | Iowa | 19047 | 197 | 1 |
139994 | 139994 | 2020-05-13 | Crawford | Iowa | 19047 | 207 | 1 |
142990 | 142990 | 2020-05-14 | Crawford | Iowa | 19047 | 300 | 1 |
145990 | 145990 | 2020-05-15 | Crawford | Iowa | 19047 | 336 | 1 |
148994 | 148994 | 2020-05-16 | Crawford | Iowa | 19047 | 348 | 1 |
152004 | 152004 | 2020-05-17 | Crawford | Iowa | 19047 | 380 | 1 |
155016 | 155016 | 2020-05-18 | Crawford | Iowa | 19047 | 384 | 1 |
158032 | 158032 | 2020-05-19 | Crawford | Iowa | 19047 | 394 | 1 |
161058 | 161058 | 2020-05-20 | Crawford | Iowa | 19047 | 420 | 1 |
164086 | 164086 | 2020-05-21 | Crawford | Iowa | 19047 | 435 | 2 |
167119 | 167119 | 2020-05-22 | Crawford | Iowa | 19047 | 445 | 2 |
170156 | 170156 | 2020-05-23 | Crawford | Iowa | 19047 | 445 | 2 |
173197 | 173197 | 2020-05-24 | Crawford | Iowa | 19047 | 484 | 2 |
176241 | 176241 | 2020-05-25 | Crawford | Iowa | 19047 | 486 | 2 |
179285 | 179285 | 2020-05-26 | Crawford | Iowa | 19047 | 487 | 2 |
182329 | 182329 | 2020-05-27 | Crawford | Iowa | 19047 | 488 | 2 |
185383 | 185383 | 2020-05-28 | Crawford | Iowa | 19047 | 495 | 2 |
188441 | 188441 | 2020-05-29 | Crawford | Iowa | 19047 | 504 | 2 |
191506 | 191506 | 2020-05-30 | Crawford | Iowa | 19047 | 517 | 2 |
194573 | 194573 | 2020-05-31 | Crawford | Iowa | 19047 | 524 | 2 |
197643 | 197643 | 2020-06-01 | Crawford | Iowa | 19047 | 528 | 2 |
200716 | 200716 | 2020-06-02 | Crawford | Iowa | 19047 | 530 | 2 |
203792 | 203792 | 2020-06-03 | Crawford | Iowa | 19047 | 543 | 2 |
206872 | 206872 | 2020-06-04 | Crawford | Iowa | 19047 | 548 | 2 |
209953 | 209953 | 2020-06-05 | Crawford | Iowa | 19047 | 557 | 2 |
213038 | 213038 | 2020-06-06 | Crawford | Iowa | 19047 | 568 | 2 |
216125 | 216125 | 2020-06-07 | Crawford | Iowa | 19047 | 573 | 2 |
219217 | 219217 | 2020-06-08 | Crawford | Iowa | 19047 | 576 | 2 |
222312 | 222312 | 2020-06-09 | Crawford | Iowa | 19047 | 583 | 2 |
225407 | 225407 | 2020-06-10 | Crawford | Iowa | 19047 | 589 | 2 |
228509 | 228509 | 2020-06-11 | Crawford | Iowa | 19047 | 592 | 2 |
231612 | 231612 | 2020-06-12 | Crawford | Iowa | 19047 | 595 | 2 |
234718 | 234718 | 2020-06-13 | Crawford | Iowa | 19047 | 614 | 2 |
237825 | 237825 | 2020-06-14 | Crawford | Iowa | 19047 | 618 | 2 |
240933 | 240933 | 2020-06-15 | Crawford | Iowa | 19047 | 622 | 2 |
244044 | 244044 | 2020-06-16 | Crawford | Iowa | 19047 | 623 | 2 |
247157 | 247157 | 2020-06-17 | Crawford | Iowa | 19047 | 630 | 2 |
250269 | 250269 | 2020-06-18 | Crawford | Iowa | 19047 | 633 | 2 |
253384 | 253384 | 2020-06-19 | Crawford | Iowa | 19047 | 635 | 2 |
256504 | 256504 | 2020-06-20 | Crawford | Iowa | 19047 | 637 | 2 |
259630 | 259630 | 2020-06-21 | Crawford | Iowa | 19047 | 640 | 2 |
262757 | 262757 | 2020-06-22 | Crawford | Iowa | 19047 | 641 | 2 |
265885 | 265885 | 2020-06-23 | Crawford | Iowa | 19047 | 642 | 2 |
269015 | 269015 | 2020-06-24 | Crawford | Iowa | 19047 | 647 | 2 |
272152 | 272152 | 2020-06-25 | Crawford | Iowa | 19047 | 650 | 2 |
275294 | 275294 | 2020-06-26 | Crawford | Iowa | 19047 | 658 | 2 |
278442 | 278442 | 2020-06-27 | Crawford | Iowa | 19047 | 659 | 2 |
281590 | 281590 | 2020-06-28 | Crawford | Iowa | 19047 | 661 | 2 |
284735 | 284735 | 2020-06-29 | Crawford | Iowa | 19047 | 667 | 2 |
287884 | 287884 | 2020-06-30 | Crawford | Iowa | 19047 | 667 | 2 |
291034 | 291034 | 2020-07-01 | Crawford | Iowa | 19047 | 667 | 2 |
294188 | 294188 | 2020-07-02 | Crawford | Iowa | 19047 | 675 | 2 |
297346 | 297346 | 2020-07-03 | Crawford | Iowa | 19047 | 675 | 2 |
300508 | 300508 | 2020-07-04 | Crawford | Iowa | 19047 | 677 | 2 |
303672 | 303672 | 2020-07-05 | Crawford | Iowa | 19047 | 678 | 2 |
306837 | 306837 | 2020-07-06 | Crawford | Iowa | 19047 | 677 | 2 |
310005 | 310005 | 2020-07-07 | Crawford | Iowa | 19047 | 678 | 3 |
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);