ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18005 and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2886 | 2886 | 2020-03-16 | Bartholomew | Indiana | 18005 | 1 | 0 |
3375 | 3375 | 2020-03-17 | Bartholomew | Indiana | 18005 | 1 | 0 |
3945 | 3945 | 2020-03-18 | Bartholomew | Indiana | 18005 | 1 | 0 |
4621 | 4621 | 2020-03-19 | Bartholomew | Indiana | 18005 | 1 | 0 |
5428 | 5428 | 2020-03-20 | Bartholomew | Indiana | 18005 | 1 | 0 |
6363 | 6363 | 2020-03-21 | Bartholomew | Indiana | 18005 | 2 | 0 |
7417 | 7417 | 2020-03-22 | Bartholomew | Indiana | 18005 | 5 | 0 |
8574 | 8574 | 2020-03-23 | Bartholomew | Indiana | 18005 | 5 | 0 |
9838 | 9838 | 2020-03-24 | Bartholomew | Indiana | 18005 | 5 | 0 |
11231 | 11231 | 2020-03-25 | Bartholomew | Indiana | 18005 | 5 | 0 |
12787 | 12787 | 2020-03-26 | Bartholomew | Indiana | 18005 | 6 | 0 |
14465 | 14465 | 2020-03-27 | Bartholomew | Indiana | 18005 | 6 | 0 |
16262 | 16262 | 2020-03-28 | Bartholomew | Indiana | 18005 | 7 | 0 |
18163 | 18163 | 2020-03-29 | Bartholomew | Indiana | 18005 | 10 | 0 |
20169 | 20169 | 2020-03-30 | Bartholomew | Indiana | 18005 | 10 | 0 |
22262 | 22262 | 2020-03-31 | Bartholomew | Indiana | 18005 | 13 | 0 |
24432 | 24432 | 2020-04-01 | Bartholomew | Indiana | 18005 | 13 | 0 |
26670 | 26670 | 2020-04-02 | Bartholomew | Indiana | 18005 | 15 | 0 |
28980 | 28980 | 2020-04-03 | Bartholomew | Indiana | 18005 | 23 | 0 |
31346 | 31346 | 2020-04-04 | Bartholomew | Indiana | 18005 | 45 | 0 |
33756 | 33756 | 2020-04-05 | Bartholomew | Indiana | 18005 | 54 | 0 |
36209 | 36209 | 2020-04-06 | Bartholomew | Indiana | 18005 | 55 | 2 |
38707 | 38707 | 2020-04-07 | Bartholomew | Indiana | 18005 | 56 | 5 |
41253 | 41253 | 2020-04-08 | Bartholomew | Indiana | 18005 | 68 | 6 |
43829 | 43829 | 2020-04-09 | Bartholomew | Indiana | 18005 | 85 | 6 |
46433 | 46433 | 2020-04-10 | Bartholomew | Indiana | 18005 | 85 | 6 |
49067 | 49067 | 2020-04-11 | Bartholomew | Indiana | 18005 | 110 | 6 |
51729 | 51729 | 2020-04-12 | Bartholomew | Indiana | 18005 | 112 | 6 |
54410 | 54410 | 2020-04-13 | Bartholomew | Indiana | 18005 | 112 | 6 |
57103 | 57103 | 2020-04-14 | Bartholomew | Indiana | 18005 | 112 | 6 |
59811 | 59811 | 2020-04-15 | Bartholomew | Indiana | 18005 | 115 | 6 |
62532 | 62532 | 2020-04-16 | Bartholomew | Indiana | 18005 | 119 | 8 |
65266 | 65266 | 2020-04-17 | Bartholomew | Indiana | 18005 | 133 | 9 |
68015 | 68015 | 2020-04-18 | Bartholomew | Indiana | 18005 | 134 | 9 |
70777 | 70777 | 2020-04-19 | Bartholomew | Indiana | 18005 | 139 | 9 |
73548 | 73548 | 2020-04-20 | Bartholomew | Indiana | 18005 | 143 | 9 |
76325 | 76325 | 2020-04-21 | Bartholomew | Indiana | 18005 | 143 | 10 |
79109 | 79109 | 2020-04-22 | Bartholomew | Indiana | 18005 | 149 | 10 |
81902 | 81902 | 2020-04-23 | Bartholomew | Indiana | 18005 | 166 | 11 |
84702 | 84702 | 2020-04-24 | Bartholomew | Indiana | 18005 | 178 | 11 |
87512 | 87512 | 2020-04-25 | Bartholomew | Indiana | 18005 | 201 | 13 |
90328 | 90328 | 2020-04-26 | Bartholomew | Indiana | 18005 | 209 | 13 |
93147 | 93147 | 2020-04-27 | Bartholomew | Indiana | 18005 | 235 | 13 |
95979 | 95979 | 2020-04-28 | Bartholomew | Indiana | 18005 | 241 | 14 |
98823 | 98823 | 2020-04-29 | Bartholomew | Indiana | 18005 | 244 | 15 |
101674 | 101674 | 2020-04-30 | Bartholomew | Indiana | 18005 | 253 | 15 |
104530 | 104530 | 2020-05-01 | Bartholomew | Indiana | 18005 | 264 | 15 |
107395 | 107395 | 2020-05-02 | Bartholomew | Indiana | 18005 | 269 | 17 |
110265 | 110265 | 2020-05-03 | Bartholomew | Indiana | 18005 | 271 | 17 |
113140 | 113140 | 2020-05-04 | Bartholomew | Indiana | 18005 | 272 | 17 |
116023 | 116023 | 2020-05-05 | Bartholomew | Indiana | 18005 | 300 | 20 |
118983 | 118983 | 2020-05-06 | Bartholomew | Indiana | 18005 | 317 | 22 |
121953 | 121953 | 2020-05-07 | Bartholomew | Indiana | 18005 | 319 | 24 |
124933 | 124933 | 2020-05-08 | Bartholomew | Indiana | 18005 | 334 | 25 |
127920 | 127920 | 2020-05-09 | Bartholomew | Indiana | 18005 | 345 | 26 |
130911 | 130911 | 2020-05-10 | Bartholomew | Indiana | 18005 | 349 | 29 |
133901 | 133901 | 2020-05-11 | Bartholomew | Indiana | 18005 | 363 | 29 |
136890 | 136890 | 2020-05-12 | Bartholomew | Indiana | 18005 | 371 | 30 |
139882 | 139882 | 2020-05-13 | Bartholomew | Indiana | 18005 | 374 | 30 |
142878 | 142878 | 2020-05-14 | Bartholomew | Indiana | 18005 | 387 | 32 |
145878 | 145878 | 2020-05-15 | Bartholomew | Indiana | 18005 | 398 | 33 |
148882 | 148882 | 2020-05-16 | Bartholomew | Indiana | 18005 | 412 | 33 |
151891 | 151891 | 2020-05-17 | Bartholomew | Indiana | 18005 | 424 | 33 |
154903 | 154903 | 2020-05-18 | Bartholomew | Indiana | 18005 | 436 | 33 |
157919 | 157919 | 2020-05-19 | Bartholomew | Indiana | 18005 | 442 | 34 |
160945 | 160945 | 2020-05-20 | Bartholomew | Indiana | 18005 | 452 | 34 |
163973 | 163973 | 2020-05-21 | Bartholomew | Indiana | 18005 | 456 | 36 |
167006 | 167006 | 2020-05-22 | Bartholomew | Indiana | 18005 | 460 | 36 |
170043 | 170043 | 2020-05-23 | Bartholomew | Indiana | 18005 | 471 | 36 |
173084 | 173084 | 2020-05-24 | Bartholomew | Indiana | 18005 | 478 | 36 |
176128 | 176128 | 2020-05-25 | Bartholomew | Indiana | 18005 | 484 | 36 |
179172 | 179172 | 2020-05-26 | Bartholomew | Indiana | 18005 | 485 | 36 |
182216 | 182216 | 2020-05-27 | Bartholomew | Indiana | 18005 | 490 | 37 |
185270 | 185270 | 2020-05-28 | Bartholomew | Indiana | 18005 | 495 | 37 |
188328 | 188328 | 2020-05-29 | Bartholomew | Indiana | 18005 | 505 | 37 |
191393 | 191393 | 2020-05-30 | Bartholomew | Indiana | 18005 | 513 | 37 |
194460 | 194460 | 2020-05-31 | Bartholomew | Indiana | 18005 | 516 | 38 |
197530 | 197530 | 2020-06-01 | Bartholomew | Indiana | 18005 | 520 | 38 |
200603 | 200603 | 2020-06-02 | Bartholomew | Indiana | 18005 | 526 | 41 |
203679 | 203679 | 2020-06-03 | Bartholomew | Indiana | 18005 | 527 | 41 |
206759 | 206759 | 2020-06-04 | Bartholomew | Indiana | 18005 | 532 | 42 |
209840 | 209840 | 2020-06-05 | Bartholomew | Indiana | 18005 | 536 | 42 |
212925 | 212925 | 2020-06-06 | Bartholomew | Indiana | 18005 | 537 | 43 |
216012 | 216012 | 2020-06-07 | Bartholomew | Indiana | 18005 | 539 | 43 |
219104 | 219104 | 2020-06-08 | Bartholomew | Indiana | 18005 | 541 | 43 |
222199 | 222199 | 2020-06-09 | Bartholomew | Indiana | 18005 | 544 | 43 |
225294 | 225294 | 2020-06-10 | Bartholomew | Indiana | 18005 | 545 | 43 |
228396 | 228396 | 2020-06-11 | Bartholomew | Indiana | 18005 | 547 | 43 |
231499 | 231499 | 2020-06-12 | Bartholomew | Indiana | 18005 | 552 | 44 |
234605 | 234605 | 2020-06-13 | Bartholomew | Indiana | 18005 | 554 | 44 |
237712 | 237712 | 2020-06-14 | Bartholomew | Indiana | 18005 | 556 | 44 |
240820 | 240820 | 2020-06-15 | Bartholomew | Indiana | 18005 | 559 | 44 |
243931 | 243931 | 2020-06-16 | Bartholomew | Indiana | 18005 | 563 | 45 |
247044 | 247044 | 2020-06-17 | Bartholomew | Indiana | 18005 | 566 | 45 |
250156 | 250156 | 2020-06-18 | Bartholomew | Indiana | 18005 | 567 | 45 |
253271 | 253271 | 2020-06-19 | Bartholomew | Indiana | 18005 | 571 | 46 |
256391 | 256391 | 2020-06-20 | Bartholomew | Indiana | 18005 | 570 | 46 |
259517 | 259517 | 2020-06-21 | Bartholomew | Indiana | 18005 | 572 | 46 |
262644 | 262644 | 2020-06-22 | Bartholomew | Indiana | 18005 | 571 | 46 |
265772 | 265772 | 2020-06-23 | Bartholomew | Indiana | 18005 | 573 | 46 |
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);