ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18043 and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 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
- …
state 1
- Indiana · 789 ✖
fips 1
- 18043 · 789 ✖
county 1
- Floyd 789
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2888 | 2888 | 2020-03-16 | Floyd | Indiana | 18043 | 1 | 0 |
3377 | 3377 | 2020-03-17 | Floyd | Indiana | 18043 | 1 | 0 |
3949 | 3949 | 2020-03-18 | Floyd | Indiana | 18043 | 1 | 0 |
4625 | 4625 | 2020-03-19 | Floyd | Indiana | 18043 | 1 | 0 |
5432 | 5432 | 2020-03-20 | Floyd | Indiana | 18043 | 2 | 0 |
6369 | 6369 | 2020-03-21 | Floyd | Indiana | 18043 | 2 | 0 |
7423 | 7423 | 2020-03-22 | Floyd | Indiana | 18043 | 3 | 0 |
8581 | 8581 | 2020-03-23 | Floyd | Indiana | 18043 | 4 | 0 |
9848 | 9848 | 2020-03-24 | Floyd | Indiana | 18043 | 6 | 0 |
11242 | 11242 | 2020-03-25 | Floyd | Indiana | 18043 | 6 | 0 |
12798 | 12798 | 2020-03-26 | Floyd | Indiana | 18043 | 7 | 0 |
14478 | 14478 | 2020-03-27 | Floyd | Indiana | 18043 | 11 | 0 |
16276 | 16276 | 2020-03-28 | Floyd | Indiana | 18043 | 13 | 0 |
18178 | 18178 | 2020-03-29 | Floyd | Indiana | 18043 | 14 | 0 |
20184 | 20184 | 2020-03-30 | Floyd | Indiana | 18043 | 20 | 0 |
22278 | 22278 | 2020-03-31 | Floyd | Indiana | 18043 | 21 | 0 |
24448 | 24448 | 2020-04-01 | Floyd | Indiana | 18043 | 21 | 0 |
26687 | 26687 | 2020-04-02 | Floyd | Indiana | 18043 | 34 | 0 |
28997 | 28997 | 2020-04-03 | Floyd | Indiana | 18043 | 37 | 0 |
31363 | 31363 | 2020-04-04 | Floyd | Indiana | 18043 | 41 | 0 |
33774 | 33774 | 2020-04-05 | Floyd | Indiana | 18043 | 50 | 0 |
36227 | 36227 | 2020-04-06 | Floyd | Indiana | 18043 | 58 | 1 |
38725 | 38725 | 2020-04-07 | Floyd | Indiana | 18043 | 74 | 1 |
41271 | 41271 | 2020-04-08 | Floyd | Indiana | 18043 | 77 | 3 |
43847 | 43847 | 2020-04-09 | Floyd | Indiana | 18043 | 88 | 3 |
46451 | 46451 | 2020-04-10 | Floyd | Indiana | 18043 | 93 | 3 |
49085 | 49085 | 2020-04-11 | Floyd | Indiana | 18043 | 105 | 4 |
51748 | 51748 | 2020-04-12 | Floyd | Indiana | 18043 | 107 | 4 |
54429 | 54429 | 2020-04-13 | Floyd | Indiana | 18043 | 108 | 4 |
57122 | 57122 | 2020-04-14 | Floyd | Indiana | 18043 | 111 | 5 |
59830 | 59830 | 2020-04-15 | Floyd | Indiana | 18043 | 116 | 5 |
62551 | 62551 | 2020-04-16 | Floyd | Indiana | 18043 | 125 | 5 |
65285 | 65285 | 2020-04-17 | Floyd | Indiana | 18043 | 130 | 6 |
68034 | 68034 | 2020-04-18 | Floyd | Indiana | 18043 | 137 | 7 |
70796 | 70796 | 2020-04-19 | Floyd | Indiana | 18043 | 142 | 7 |
73567 | 73567 | 2020-04-20 | Floyd | Indiana | 18043 | 143 | 8 |
76344 | 76344 | 2020-04-21 | Floyd | Indiana | 18043 | 143 | 8 |
79128 | 79128 | 2020-04-22 | Floyd | Indiana | 18043 | 150 | 10 |
81921 | 81921 | 2020-04-23 | Floyd | Indiana | 18043 | 153 | 10 |
84721 | 84721 | 2020-04-24 | Floyd | Indiana | 18043 | 163 | 11 |
87531 | 87531 | 2020-04-25 | Floyd | Indiana | 18043 | 164 | 12 |
90347 | 90347 | 2020-04-26 | Floyd | Indiana | 18043 | 165 | 13 |
93166 | 93166 | 2020-04-27 | Floyd | Indiana | 18043 | 164 | 12 |
95998 | 95998 | 2020-04-28 | Floyd | Indiana | 18043 | 173 | 13 |
98842 | 98842 | 2020-04-29 | Floyd | Indiana | 18043 | 175 | 17 |
101693 | 101693 | 2020-04-30 | Floyd | Indiana | 18043 | 179 | 17 |
104549 | 104549 | 2020-05-01 | Floyd | Indiana | 18043 | 183 | 17 |
107414 | 107414 | 2020-05-02 | Floyd | Indiana | 18043 | 201 | 18 |
110284 | 110284 | 2020-05-03 | Floyd | Indiana | 18043 | 204 | 18 |
113159 | 113159 | 2020-05-04 | Floyd | Indiana | 18043 | 205 | 19 |
116042 | 116042 | 2020-05-05 | Floyd | Indiana | 18043 | 213 | 28 |
119002 | 119002 | 2020-05-06 | Floyd | Indiana | 18043 | 219 | 28 |
121972 | 121972 | 2020-05-07 | Floyd | Indiana | 18043 | 225 | 29 |
124952 | 124952 | 2020-05-08 | Floyd | Indiana | 18043 | 227 | 29 |
127939 | 127939 | 2020-05-09 | Floyd | Indiana | 18043 | 231 | 29 |
130930 | 130930 | 2020-05-10 | Floyd | Indiana | 18043 | 233 | 29 |
133920 | 133920 | 2020-05-11 | Floyd | Indiana | 18043 | 233 | 30 |
136909 | 136909 | 2020-05-12 | Floyd | Indiana | 18043 | 239 | 31 |
139901 | 139901 | 2020-05-13 | Floyd | Indiana | 18043 | 247 | 32 |
142897 | 142897 | 2020-05-14 | Floyd | Indiana | 18043 | 251 | 33 |
145897 | 145897 | 2020-05-15 | Floyd | Indiana | 18043 | 255 | 33 |
148901 | 148901 | 2020-05-16 | Floyd | Indiana | 18043 | 299 | 39 |
151910 | 151910 | 2020-05-17 | Floyd | Indiana | 18043 | 299 | 39 |
154922 | 154922 | 2020-05-18 | Floyd | Indiana | 18043 | 303 | 39 |
157938 | 157938 | 2020-05-19 | Floyd | Indiana | 18043 | 306 | 40 |
160964 | 160964 | 2020-05-20 | Floyd | Indiana | 18043 | 308 | 40 |
163992 | 163992 | 2020-05-21 | Floyd | Indiana | 18043 | 311 | 40 |
167025 | 167025 | 2020-05-22 | Floyd | Indiana | 18043 | 313 | 40 |
170062 | 170062 | 2020-05-23 | Floyd | Indiana | 18043 | 313 | 40 |
173103 | 173103 | 2020-05-24 | Floyd | Indiana | 18043 | 314 | 40 |
176147 | 176147 | 2020-05-25 | Floyd | Indiana | 18043 | 315 | 40 |
179191 | 179191 | 2020-05-26 | Floyd | Indiana | 18043 | 316 | 40 |
182235 | 182235 | 2020-05-27 | Floyd | Indiana | 18043 | 317 | 41 |
185289 | 185289 | 2020-05-28 | Floyd | Indiana | 18043 | 319 | 41 |
188347 | 188347 | 2020-05-29 | Floyd | Indiana | 18043 | 320 | 41 |
191412 | 191412 | 2020-05-30 | Floyd | Indiana | 18043 | 320 | 41 |
194479 | 194479 | 2020-05-31 | Floyd | Indiana | 18043 | 320 | 41 |
197549 | 197549 | 2020-06-01 | Floyd | Indiana | 18043 | 320 | 41 |
200622 | 200622 | 2020-06-02 | Floyd | Indiana | 18043 | 321 | 42 |
203698 | 203698 | 2020-06-03 | Floyd | Indiana | 18043 | 323 | 42 |
206778 | 206778 | 2020-06-04 | Floyd | Indiana | 18043 | 325 | 42 |
209859 | 209859 | 2020-06-05 | Floyd | Indiana | 18043 | 321 | 43 |
212944 | 212944 | 2020-06-06 | Floyd | Indiana | 18043 | 325 | 43 |
216031 | 216031 | 2020-06-07 | Floyd | Indiana | 18043 | 328 | 43 |
219123 | 219123 | 2020-06-08 | Floyd | Indiana | 18043 | 330 | 43 |
222218 | 222218 | 2020-06-09 | Floyd | Indiana | 18043 | 329 | 44 |
225313 | 225313 | 2020-06-10 | Floyd | Indiana | 18043 | 331 | 44 |
228415 | 228415 | 2020-06-11 | Floyd | Indiana | 18043 | 334 | 44 |
231518 | 231518 | 2020-06-12 | Floyd | Indiana | 18043 | 335 | 44 |
234624 | 234624 | 2020-06-13 | Floyd | Indiana | 18043 | 335 | 44 |
237731 | 237731 | 2020-06-14 | Floyd | Indiana | 18043 | 335 | 44 |
240839 | 240839 | 2020-06-15 | Floyd | Indiana | 18043 | 337 | 44 |
243950 | 243950 | 2020-06-16 | Floyd | Indiana | 18043 | 339 | 44 |
247063 | 247063 | 2020-06-17 | Floyd | Indiana | 18043 | 340 | 44 |
250175 | 250175 | 2020-06-18 | Floyd | Indiana | 18043 | 341 | 45 |
253290 | 253290 | 2020-06-19 | Floyd | Indiana | 18043 | 344 | 45 |
256410 | 256410 | 2020-06-20 | Floyd | Indiana | 18043 | 346 | 45 |
259536 | 259536 | 2020-06-21 | Floyd | Indiana | 18043 | 346 | 45 |
262663 | 262663 | 2020-06-22 | Floyd | Indiana | 18043 | 347 | 45 |
265791 | 265791 | 2020-06-23 | Floyd | Indiana | 18043 | 349 | 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);