ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison", fips = 18095 and state = "Indiana" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3958 | 3958 | 2020-03-18 | Madison | Indiana | 18095 | 1 | 0 |
4634 | 4634 | 2020-03-19 | Madison | Indiana | 18095 | 1 | 0 |
5442 | 5442 | 2020-03-20 | Madison | Indiana | 18095 | 1 | 0 |
6381 | 6381 | 2020-03-21 | Madison | Indiana | 18095 | 1 | 0 |
7435 | 7435 | 2020-03-22 | Madison | Indiana | 18095 | 3 | 1 |
8593 | 8593 | 2020-03-23 | Madison | Indiana | 18095 | 4 | 1 |
9863 | 9863 | 2020-03-24 | Madison | Indiana | 18095 | 4 | 1 |
11258 | 11258 | 2020-03-25 | Madison | Indiana | 18095 | 5 | 1 |
12815 | 12815 | 2020-03-26 | Madison | Indiana | 18095 | 5 | 1 |
14500 | 14500 | 2020-03-27 | Madison | Indiana | 18095 | 9 | 3 |
16298 | 16298 | 2020-03-28 | Madison | Indiana | 18095 | 15 | 4 |
18202 | 18202 | 2020-03-29 | Madison | Indiana | 18095 | 21 | 4 |
20208 | 20208 | 2020-03-30 | Madison | Indiana | 18095 | 32 | 4 |
22303 | 22303 | 2020-03-31 | Madison | Indiana | 18095 | 41 | 4 |
24474 | 24474 | 2020-04-01 | Madison | Indiana | 18095 | 49 | 5 |
26713 | 26713 | 2020-04-02 | Madison | Indiana | 18095 | 66 | 7 |
29023 | 29023 | 2020-04-03 | Madison | Indiana | 18095 | 71 | 11 |
31389 | 31389 | 2020-04-04 | Madison | Indiana | 18095 | 77 | 14 |
33800 | 33800 | 2020-04-05 | Madison | Indiana | 18095 | 92 | 15 |
36253 | 36253 | 2020-04-06 | Madison | Indiana | 18095 | 109 | 17 |
38751 | 38751 | 2020-04-07 | Madison | Indiana | 18095 | 145 | 19 |
41297 | 41297 | 2020-04-08 | Madison | Indiana | 18095 | 151 | 19 |
43873 | 43873 | 2020-04-09 | Madison | Indiana | 18095 | 154 | 19 |
46477 | 46477 | 2020-04-10 | Madison | Indiana | 18095 | 212 | 21 |
49111 | 49111 | 2020-04-11 | Madison | Indiana | 18095 | 243 | 21 |
51774 | 51774 | 2020-04-12 | Madison | Indiana | 18095 | 262 | 22 |
54455 | 54455 | 2020-04-13 | Madison | Indiana | 18095 | 269 | 23 |
57148 | 57148 | 2020-04-14 | Madison | Indiana | 18095 | 271 | 24 |
59856 | 59856 | 2020-04-15 | Madison | Indiana | 18095 | 281 | 32 |
62577 | 62577 | 2020-04-16 | Madison | Indiana | 18095 | 291 | 32 |
65311 | 65311 | 2020-04-17 | Madison | Indiana | 18095 | 313 | 36 |
68060 | 68060 | 2020-04-18 | Madison | Indiana | 18095 | 331 | 38 |
70822 | 70822 | 2020-04-19 | Madison | Indiana | 18095 | 340 | 40 |
73593 | 73593 | 2020-04-20 | Madison | Indiana | 18095 | 348 | 40 |
76370 | 76370 | 2020-04-21 | Madison | Indiana | 18095 | 354 | 42 |
79154 | 79154 | 2020-04-22 | Madison | Indiana | 18095 | 359 | 42 |
81947 | 81947 | 2020-04-23 | Madison | Indiana | 18095 | 367 | 46 |
84747 | 84747 | 2020-04-24 | Madison | Indiana | 18095 | 388 | 50 |
87557 | 87557 | 2020-04-25 | Madison | Indiana | 18095 | 404 | 52 |
90373 | 90373 | 2020-04-26 | Madison | Indiana | 18095 | 403 | 54 |
93192 | 93192 | 2020-04-27 | Madison | Indiana | 18095 | 404 | 53 |
96024 | 96024 | 2020-04-28 | Madison | Indiana | 18095 | 409 | 54 |
98868 | 98868 | 2020-04-29 | Madison | Indiana | 18095 | 417 | 56 |
101719 | 101719 | 2020-04-30 | Madison | Indiana | 18095 | 428 | 56 |
104575 | 104575 | 2020-05-01 | Madison | Indiana | 18095 | 437 | 58 |
107440 | 107440 | 2020-05-02 | Madison | Indiana | 18095 | 443 | 61 |
110310 | 110310 | 2020-05-03 | Madison | Indiana | 18095 | 448 | 61 |
113185 | 113185 | 2020-05-04 | Madison | Indiana | 18095 | 459 | 62 |
116068 | 116068 | 2020-05-05 | Madison | Indiana | 18095 | 461 | 64 |
119028 | 119028 | 2020-05-06 | Madison | Indiana | 18095 | 471 | 65 |
121998 | 121998 | 2020-05-07 | Madison | Indiana | 18095 | 483 | 65 |
124978 | 124978 | 2020-05-08 | Madison | Indiana | 18095 | 488 | 65 |
127965 | 127965 | 2020-05-09 | Madison | Indiana | 18095 | 506 | 65 |
130956 | 130956 | 2020-05-10 | Madison | Indiana | 18095 | 512 | 66 |
133946 | 133946 | 2020-05-11 | Madison | Indiana | 18095 | 518 | 66 |
136935 | 136935 | 2020-05-12 | Madison | Indiana | 18095 | 521 | 66 |
139927 | 139927 | 2020-05-13 | Madison | Indiana | 18095 | 536 | 66 |
142923 | 142923 | 2020-05-14 | Madison | Indiana | 18095 | 536 | 66 |
145923 | 145923 | 2020-05-15 | Madison | Indiana | 18095 | 544 | 66 |
148927 | 148927 | 2020-05-16 | Madison | Indiana | 18095 | 547 | 66 |
151936 | 151936 | 2020-05-17 | Madison | Indiana | 18095 | 552 | 66 |
154948 | 154948 | 2020-05-18 | Madison | Indiana | 18095 | 560 | 66 |
157964 | 157964 | 2020-05-19 | Madison | Indiana | 18095 | 562 | 66 |
160990 | 160990 | 2020-05-20 | Madison | Indiana | 18095 | 577 | 66 |
164018 | 164018 | 2020-05-21 | Madison | Indiana | 18095 | 582 | 66 |
167051 | 167051 | 2020-05-22 | Madison | Indiana | 18095 | 585 | 66 |
170088 | 170088 | 2020-05-23 | Madison | Indiana | 18095 | 585 | 67 |
173129 | 173129 | 2020-05-24 | Madison | Indiana | 18095 | 589 | 67 |
176173 | 176173 | 2020-05-25 | Madison | Indiana | 18095 | 591 | 67 |
179217 | 179217 | 2020-05-26 | Madison | Indiana | 18095 | 591 | 67 |
182261 | 182261 | 2020-05-27 | Madison | Indiana | 18095 | 591 | 68 |
185315 | 185315 | 2020-05-28 | Madison | Indiana | 18095 | 593 | 68 |
188373 | 188373 | 2020-05-29 | Madison | Indiana | 18095 | 594 | 68 |
191438 | 191438 | 2020-05-30 | Madison | Indiana | 18095 | 595 | 68 |
194505 | 194505 | 2020-05-31 | Madison | Indiana | 18095 | 595 | 68 |
197575 | 197575 | 2020-06-01 | Madison | Indiana | 18095 | 602 | 68 |
200648 | 200648 | 2020-06-02 | Madison | Indiana | 18095 | 603 | 70 |
203724 | 203724 | 2020-06-03 | Madison | Indiana | 18095 | 606 | 70 |
206804 | 206804 | 2020-06-04 | Madison | Indiana | 18095 | 608 | 70 |
209885 | 209885 | 2020-06-05 | Madison | Indiana | 18095 | 609 | 70 |
212970 | 212970 | 2020-06-06 | Madison | Indiana | 18095 | 613 | 71 |
216057 | 216057 | 2020-06-07 | Madison | Indiana | 18095 | 613 | 71 |
219149 | 219149 | 2020-06-08 | Madison | Indiana | 18095 | 615 | 71 |
222244 | 222244 | 2020-06-09 | Madison | Indiana | 18095 | 615 | 71 |
225339 | 225339 | 2020-06-10 | Madison | Indiana | 18095 | 616 | 71 |
228441 | 228441 | 2020-06-11 | Madison | Indiana | 18095 | 620 | 71 |
231544 | 231544 | 2020-06-12 | Madison | Indiana | 18095 | 622 | 71 |
234650 | 234650 | 2020-06-13 | Madison | Indiana | 18095 | 622 | 71 |
237757 | 237757 | 2020-06-14 | Madison | Indiana | 18095 | 624 | 71 |
240865 | 240865 | 2020-06-15 | Madison | Indiana | 18095 | 624 | 71 |
243976 | 243976 | 2020-06-16 | Madison | Indiana | 18095 | 625 | 72 |
247089 | 247089 | 2020-06-17 | Madison | Indiana | 18095 | 625 | 72 |
250201 | 250201 | 2020-06-18 | Madison | Indiana | 18095 | 628 | 72 |
253316 | 253316 | 2020-06-19 | Madison | Indiana | 18095 | 628 | 73 |
256436 | 256436 | 2020-06-20 | Madison | Indiana | 18095 | 628 | 73 |
259562 | 259562 | 2020-06-21 | Madison | Indiana | 18095 | 630 | 73 |
262689 | 262689 | 2020-06-22 | Madison | Indiana | 18095 | 631 | 73 |
265817 | 265817 | 2020-06-23 | Madison | Indiana | 18095 | 631 | 73 |
268947 | 268947 | 2020-06-24 | Madison | Indiana | 18095 | 634 | 73 |
272084 | 272084 | 2020-06-25 | Madison | Indiana | 18095 | 634 | 73 |
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);