ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18039 and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-19 1
- …
state 1
- Indiana · 784 ✖
fips 1
- 18039 · 784 ✖
county 1
- Elkhart 784
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6367 | 6367 | 2020-03-21 | Elkhart | Indiana | 18039 | 1 | 0 |
7421 | 7421 | 2020-03-22 | Elkhart | Indiana | 18039 | 1 | 0 |
8579 | 8579 | 2020-03-23 | Elkhart | Indiana | 18039 | 4 | 0 |
9846 | 9846 | 2020-03-24 | Elkhart | Indiana | 18039 | 4 | 0 |
11240 | 11240 | 2020-03-25 | Elkhart | Indiana | 18039 | 5 | 0 |
12796 | 12796 | 2020-03-26 | Elkhart | Indiana | 18039 | 7 | 0 |
14476 | 14476 | 2020-03-27 | Elkhart | Indiana | 18039 | 9 | 0 |
16274 | 16274 | 2020-03-28 | Elkhart | Indiana | 18039 | 11 | 0 |
18176 | 18176 | 2020-03-29 | Elkhart | Indiana | 18039 | 12 | 0 |
20182 | 20182 | 2020-03-30 | Elkhart | Indiana | 18039 | 12 | 0 |
22276 | 22276 | 2020-03-31 | Elkhart | Indiana | 18039 | 20 | 1 |
24446 | 24446 | 2020-04-01 | Elkhart | Indiana | 18039 | 23 | 2 |
26685 | 26685 | 2020-04-02 | Elkhart | Indiana | 18039 | 27 | 3 |
28995 | 28995 | 2020-04-03 | Elkhart | Indiana | 18039 | 29 | 3 |
31361 | 31361 | 2020-04-04 | Elkhart | Indiana | 18039 | 31 | 3 |
33772 | 33772 | 2020-04-05 | Elkhart | Indiana | 18039 | 35 | 3 |
36225 | 36225 | 2020-04-06 | Elkhart | Indiana | 18039 | 36 | 3 |
38723 | 38723 | 2020-04-07 | Elkhart | Indiana | 18039 | 43 | 3 |
41269 | 41269 | 2020-04-08 | Elkhart | Indiana | 18039 | 46 | 3 |
43845 | 43845 | 2020-04-09 | Elkhart | Indiana | 18039 | 56 | 3 |
46449 | 46449 | 2020-04-10 | Elkhart | Indiana | 18039 | 61 | 3 |
49083 | 49083 | 2020-04-11 | Elkhart | Indiana | 18039 | 71 | 3 |
51746 | 51746 | 2020-04-12 | Elkhart | Indiana | 18039 | 83 | 3 |
54427 | 54427 | 2020-04-13 | Elkhart | Indiana | 18039 | 89 | 3 |
57120 | 57120 | 2020-04-14 | Elkhart | Indiana | 18039 | 100 | 3 |
59828 | 59828 | 2020-04-15 | Elkhart | Indiana | 18039 | 105 | 3 |
62549 | 62549 | 2020-04-16 | Elkhart | Indiana | 18039 | 123 | 3 |
65283 | 65283 | 2020-04-17 | Elkhart | Indiana | 18039 | 130 | 3 |
68032 | 68032 | 2020-04-18 | Elkhart | Indiana | 18039 | 148 | 3 |
70794 | 70794 | 2020-04-19 | Elkhart | Indiana | 18039 | 152 | 3 |
73565 | 73565 | 2020-04-20 | Elkhart | Indiana | 18039 | 164 | 3 |
76342 | 76342 | 2020-04-21 | Elkhart | Indiana | 18039 | 179 | 3 |
79126 | 79126 | 2020-04-22 | Elkhart | Indiana | 18039 | 185 | 3 |
81919 | 81919 | 2020-04-23 | Elkhart | Indiana | 18039 | 196 | 4 |
84719 | 84719 | 2020-04-24 | Elkhart | Indiana | 18039 | 211 | 4 |
87529 | 87529 | 2020-04-25 | Elkhart | Indiana | 18039 | 238 | 4 |
90345 | 90345 | 2020-04-26 | Elkhart | Indiana | 18039 | 245 | 4 |
93164 | 93164 | 2020-04-27 | Elkhart | Indiana | 18039 | 247 | 5 |
95996 | 95996 | 2020-04-28 | Elkhart | Indiana | 18039 | 269 | 7 |
98840 | 98840 | 2020-04-29 | Elkhart | Indiana | 18039 | 281 | 7 |
101691 | 101691 | 2020-04-30 | Elkhart | Indiana | 18039 | 287 | 7 |
104547 | 104547 | 2020-05-01 | Elkhart | Indiana | 18039 | 296 | 9 |
107412 | 107412 | 2020-05-02 | Elkhart | Indiana | 18039 | 298 | 9 |
110282 | 110282 | 2020-05-03 | Elkhart | Indiana | 18039 | 314 | 12 |
113157 | 113157 | 2020-05-04 | Elkhart | Indiana | 18039 | 324 | 13 |
116040 | 116040 | 2020-05-05 | Elkhart | Indiana | 18039 | 345 | 13 |
119000 | 119000 | 2020-05-06 | Elkhart | Indiana | 18039 | 364 | 16 |
121970 | 121970 | 2020-05-07 | Elkhart | Indiana | 18039 | 390 | 16 |
124950 | 124950 | 2020-05-08 | Elkhart | Indiana | 18039 | 413 | 16 |
127937 | 127937 | 2020-05-09 | Elkhart | Indiana | 18039 | 439 | 18 |
130928 | 130928 | 2020-05-10 | Elkhart | Indiana | 18039 | 487 | 18 |
133918 | 133918 | 2020-05-11 | Elkhart | Indiana | 18039 | 497 | 18 |
136907 | 136907 | 2020-05-12 | Elkhart | Indiana | 18039 | 528 | 21 |
139899 | 139899 | 2020-05-13 | Elkhart | Indiana | 18039 | 552 | 21 |
142895 | 142895 | 2020-05-14 | Elkhart | Indiana | 18039 | 592 | 22 |
145895 | 145895 | 2020-05-15 | Elkhart | Indiana | 18039 | 612 | 22 |
148899 | 148899 | 2020-05-16 | Elkhart | Indiana | 18039 | 641 | 23 |
151908 | 151908 | 2020-05-17 | Elkhart | Indiana | 18039 | 671 | 23 |
154920 | 154920 | 2020-05-18 | Elkhart | Indiana | 18039 | 690 | 23 |
157936 | 157936 | 2020-05-19 | Elkhart | Indiana | 18039 | 738 | 25 |
160962 | 160962 | 2020-05-20 | Elkhart | Indiana | 18039 | 782 | 27 |
163990 | 163990 | 2020-05-21 | Elkhart | Indiana | 18039 | 849 | 28 |
167023 | 167023 | 2020-05-22 | Elkhart | Indiana | 18039 | 908 | 28 |
170060 | 170060 | 2020-05-23 | Elkhart | Indiana | 18039 | 943 | 28 |
173101 | 173101 | 2020-05-24 | Elkhart | Indiana | 18039 | 996 | 28 |
176145 | 176145 | 2020-05-25 | Elkhart | Indiana | 18039 | 1013 | 28 |
179189 | 179189 | 2020-05-26 | Elkhart | Indiana | 18039 | 1063 | 30 |
182233 | 182233 | 2020-05-27 | Elkhart | Indiana | 18039 | 1076 | 30 |
185287 | 185287 | 2020-05-28 | Elkhart | Indiana | 18039 | 1107 | 30 |
188345 | 188345 | 2020-05-29 | Elkhart | Indiana | 18039 | 1169 | 30 |
191410 | 191410 | 2020-05-30 | Elkhart | Indiana | 18039 | 1268 | 30 |
194477 | 194477 | 2020-05-31 | Elkhart | Indiana | 18039 | 1328 | 30 |
197547 | 197547 | 2020-06-01 | Elkhart | Indiana | 18039 | 1328 | 30 |
200620 | 200620 | 2020-06-02 | Elkhart | Indiana | 18039 | 1402 | 30 |
203696 | 203696 | 2020-06-03 | Elkhart | Indiana | 18039 | 1456 | 31 |
206776 | 206776 | 2020-06-04 | Elkhart | Indiana | 18039 | 1516 | 30 |
209857 | 209857 | 2020-06-05 | Elkhart | Indiana | 18039 | 1611 | 30 |
212942 | 212942 | 2020-06-06 | Elkhart | Indiana | 18039 | 1663 | 31 |
216029 | 216029 | 2020-06-07 | Elkhart | Indiana | 18039 | 1743 | 31 |
219121 | 219121 | 2020-06-08 | Elkhart | Indiana | 18039 | 1767 | 31 |
222216 | 222216 | 2020-06-09 | Elkhart | Indiana | 18039 | 1826 | 31 |
225311 | 225311 | 2020-06-10 | Elkhart | Indiana | 18039 | 1858 | 31 |
228413 | 228413 | 2020-06-11 | Elkhart | Indiana | 18039 | 1902 | 32 |
231516 | 231516 | 2020-06-12 | Elkhart | Indiana | 18039 | 1955 | 34 |
234622 | 234622 | 2020-06-13 | Elkhart | Indiana | 18039 | 2075 | 34 |
237729 | 237729 | 2020-06-14 | Elkhart | Indiana | 18039 | 2126 | 36 |
240837 | 240837 | 2020-06-15 | Elkhart | Indiana | 18039 | 2213 | 36 |
243948 | 243948 | 2020-06-16 | Elkhart | Indiana | 18039 | 2295 | 37 |
247061 | 247061 | 2020-06-17 | Elkhart | Indiana | 18039 | 2330 | 37 |
250173 | 250173 | 2020-06-18 | Elkhart | Indiana | 18039 | 2454 | 38 |
253288 | 253288 | 2020-06-19 | Elkhart | Indiana | 18039 | 2532 | 41 |
256408 | 256408 | 2020-06-20 | Elkhart | Indiana | 18039 | 2593 | 41 |
259534 | 259534 | 2020-06-21 | Elkhart | Indiana | 18039 | 2658 | 41 |
262661 | 262661 | 2020-06-22 | Elkhart | Indiana | 18039 | 2680 | 41 |
265789 | 265789 | 2020-06-23 | Elkhart | Indiana | 18039 | 2721 | 42 |
268919 | 268919 | 2020-06-24 | Elkhart | Indiana | 18039 | 2761 | 43 |
272056 | 272056 | 2020-06-25 | Elkhart | Indiana | 18039 | 2862 | 44 |
275198 | 275198 | 2020-06-26 | Elkhart | Indiana | 18039 | 2921 | 44 |
278346 | 278346 | 2020-06-27 | Elkhart | Indiana | 18039 | 2988 | 45 |
281494 | 281494 | 2020-06-28 | Elkhart | Indiana | 18039 | 3036 | 45 |
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);