ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Marion" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
614 | 614 | 2020-03-06 | Marion | Indiana | 18097 | 1 | 0 |
698 | 698 | 2020-03-07 | Marion | Indiana | 18097 | 1 | 0 |
796 | 796 | 2020-03-08 | Marion | Indiana | 18097 | 1 | 0 |
916 | 916 | 2020-03-09 | Marion | Indiana | 18097 | 1 | 0 |
1061 | 1061 | 2020-03-10 | Marion | Indiana | 18097 | 1 | 0 |
1238 | 1238 | 2020-03-11 | Marion | Indiana | 18097 | 1 | 0 |
1452 | 1452 | 2020-03-12 | Marion | Indiana | 18097 | 2 | 0 |
1723 | 1723 | 2020-03-13 | Marion | Indiana | 18097 | 2 | 0 |
2055 | 2055 | 2020-03-14 | Marion | Indiana | 18097 | 3 | 0 |
2449 | 2449 | 2020-03-15 | Marion | Indiana | 18097 | 6 | 0 |
2894 | 2894 | 2020-03-16 | Marion | Indiana | 18097 | 7 | 1 |
3385 | 3385 | 2020-03-17 | Marion | Indiana | 18097 | 9 | 1 |
3959 | 3959 | 2020-03-18 | Marion | Indiana | 18097 | 11 | 1 |
4635 | 4635 | 2020-03-19 | Marion | Indiana | 18097 | 19 | 1 |
5443 | 5443 | 2020-03-20 | Marion | Indiana | 18097 | 26 | 3 |
6382 | 6382 | 2020-03-21 | Marion | Indiana | 18097 | 47 | 3 |
7436 | 7436 | 2020-03-22 | Marion | Indiana | 18097 | 83 | 4 |
8594 | 8594 | 2020-03-23 | Marion | Indiana | 18097 | 111 | 4 |
9864 | 9864 | 2020-03-24 | Marion | Indiana | 18097 | 162 | 7 |
11259 | 11259 | 2020-03-25 | Marion | Indiana | 18097 | 227 | 7 |
12816 | 12816 | 2020-03-26 | Marion | Indiana | 18097 | 294 | 7 |
14501 | 14501 | 2020-03-27 | Marion | Indiana | 18097 | 485 | 9 |
16299 | 16299 | 2020-03-28 | Marion | Indiana | 18097 | 585 | 11 |
18203 | 18203 | 2020-03-29 | Marion | Indiana | 18097 | 677 | 11 |
20209 | 20209 | 2020-03-30 | Marion | Indiana | 18097 | 805 | 13 |
22304 | 22304 | 2020-03-31 | Marion | Indiana | 18097 | 965 | 18 |
24475 | 24475 | 2020-04-01 | Marion | Indiana | 18097 | 1119 | 23 |
26714 | 26714 | 2020-04-02 | Marion | Indiana | 18097 | 1306 | 26 |
29024 | 29024 | 2020-04-03 | Marion | Indiana | 18097 | 1431 | 35 |
31390 | 31390 | 2020-04-04 | Marion | Indiana | 18097 | 1572 | 36 |
33801 | 33801 | 2020-04-05 | Marion | Indiana | 18097 | 1764 | 41 |
36254 | 36254 | 2020-04-06 | Marion | Indiana | 18097 | 1960 | 45 |
38752 | 38752 | 2020-04-07 | Marion | Indiana | 18097 | 2147 | 54 |
41298 | 41298 | 2020-04-08 | Marion | Indiana | 18097 | 2299 | 67 |
43874 | 43874 | 2020-04-09 | Marion | Indiana | 18097 | 2426 | 92 |
46478 | 46478 | 2020-04-10 | Marion | Indiana | 18097 | 2613 | 120 |
49112 | 49112 | 2020-04-11 | Marion | Indiana | 18097 | 2755 | 131 |
51775 | 51775 | 2020-04-12 | Marion | Indiana | 18097 | 2901 | 137 |
54456 | 54456 | 2020-04-13 | Marion | Indiana | 18097 | 3028 | 139 |
57149 | 57149 | 2020-04-14 | Marion | Indiana | 18097 | 3081 | 159 |
59857 | 59857 | 2020-04-15 | Marion | Indiana | 18097 | 3224 | 175 |
62578 | 62578 | 2020-04-16 | Marion | Indiana | 18097 | 3340 | 184 |
65312 | 65312 | 2020-04-17 | Marion | Indiana | 18097 | 3538 | 202 |
68061 | 68061 | 2020-04-18 | Marion | Indiana | 18097 | 3645 | 211 |
70823 | 70823 | 2020-04-19 | Marion | Indiana | 18097 | 3911 | 214 |
73594 | 73594 | 2020-04-20 | Marion | Indiana | 18097 | 4076 | 216 |
76371 | 76371 | 2020-04-21 | Marion | Indiana | 18097 | 4201 | 231 |
79155 | 79155 | 2020-04-22 | Marion | Indiana | 18097 | 4289 | 240 |
81948 | 81948 | 2020-04-23 | Marion | Indiana | 18097 | 4437 | 255 |
84748 | 84748 | 2020-04-24 | Marion | Indiana | 18097 | 4571 | 266 |
87558 | 87558 | 2020-04-25 | Marion | Indiana | 18097 | 4763 | 283 |
90374 | 90374 | 2020-04-26 | Marion | Indiana | 18097 | 4832 | 287 |
93193 | 93193 | 2020-04-27 | Marion | Indiana | 18097 | 4967 | 289 |
96025 | 96025 | 2020-04-28 | Marion | Indiana | 18097 | 5121 | 304 |
98869 | 98869 | 2020-04-29 | Marion | Indiana | 18097 | 5340 | 329 |
101720 | 101720 | 2020-04-30 | Marion | Indiana | 18097 | 5576 | 353 |
104576 | 104576 | 2020-05-01 | Marion | Indiana | 18097 | 5801 | 364 |
107441 | 107441 | 2020-05-02 | Marion | Indiana | 18097 | 6032 | 382 |
110311 | 110311 | 2020-05-03 | Marion | Indiana | 18097 | 6225 | 385 |
113186 | 113186 | 2020-05-04 | Marion | Indiana | 18097 | 6375 | 387 |
116069 | 116069 | 2020-05-05 | Marion | Indiana | 18097 | 6469 | 398 |
119029 | 119029 | 2020-05-06 | Marion | Indiana | 18097 | 6784 | 413 |
121999 | 121999 | 2020-05-07 | Marion | Indiana | 18097 | 6978 | 425 |
124979 | 124979 | 2020-05-08 | Marion | Indiana | 18097 | 7142 | 430 |
127966 | 127966 | 2020-05-09 | Marion | Indiana | 18097 | 7314 | 444 |
130957 | 130957 | 2020-05-10 | Marion | Indiana | 18097 | 7405 | 448 |
133947 | 133947 | 2020-05-11 | Marion | Indiana | 18097 | 7580 | 455 |
136936 | 136936 | 2020-05-12 | Marion | Indiana | 18097 | 7703 | 462 |
139928 | 139928 | 2020-05-13 | Marion | Indiana | 18097 | 7779 | 473 |
142924 | 142924 | 2020-05-14 | Marion | Indiana | 18097 | 7869 | 484 |
145924 | 145924 | 2020-05-15 | Marion | Indiana | 18097 | 8082 | 500 |
148928 | 148928 | 2020-05-16 | Marion | Indiana | 18097 | 8240 | 509 |
151937 | 151937 | 2020-05-17 | Marion | Indiana | 18097 | 8392 | 512 |
154949 | 154949 | 2020-05-18 | Marion | Indiana | 18097 | 8495 | 515 |
157965 | 157965 | 2020-05-19 | Marion | Indiana | 18097 | 8632 | 532 |
160991 | 160991 | 2020-05-20 | Marion | Indiana | 18097 | 8753 | 541 |
164019 | 164019 | 2020-05-21 | Marion | Indiana | 18097 | 8912 | 554 |
167052 | 167052 | 2020-05-22 | Marion | Indiana | 18097 | 9024 | 564 |
170089 | 170089 | 2020-05-23 | Marion | Indiana | 18097 | 9138 | 569 |
173130 | 173130 | 2020-05-24 | Marion | Indiana | 18097 | 9230 | 571 |
176174 | 176174 | 2020-05-25 | Marion | Indiana | 18097 | 9287 | 571 |
179218 | 179218 | 2020-05-26 | Marion | Indiana | 18097 | 9367 | 577 |
182262 | 182262 | 2020-05-27 | Marion | Indiana | 18097 | 9471 | 584 |
185316 | 185316 | 2020-05-28 | Marion | Indiana | 18097 | 9626 | 596 |
188374 | 188374 | 2020-05-29 | Marion | Indiana | 18097 | 9720 | 609 |
191439 | 191439 | 2020-05-30 | Marion | Indiana | 18097 | 9866 | 615 |
194506 | 194506 | 2020-05-31 | Marion | Indiana | 18097 | 9958 | 617 |
197576 | 197576 | 2020-06-01 | Marion | Indiana | 18097 | 10005 | 620 |
200649 | 200649 | 2020-06-02 | Marion | Indiana | 18097 | 10089 | 637 |
203725 | 203725 | 2020-06-03 | Marion | Indiana | 18097 | 10148 | 639 |
206805 | 206805 | 2020-06-04 | Marion | Indiana | 18097 | 10207 | 644 |
209886 | 209886 | 2020-06-05 | Marion | Indiana | 18097 | 10301 | 650 |
212971 | 212971 | 2020-06-06 | Marion | Indiana | 18097 | 10390 | 663 |
216058 | 216058 | 2020-06-07 | Marion | Indiana | 18097 | 10440 | 668 |
219150 | 219150 | 2020-06-08 | Marion | Indiana | 18097 | 10471 | 669 |
222245 | 222245 | 2020-06-09 | Marion | Indiana | 18097 | 10559 | 676 |
225340 | 225340 | 2020-06-10 | Marion | Indiana | 18097 | 10581 | 680 |
228442 | 228442 | 2020-06-11 | Marion | Indiana | 18097 | 10609 | 689 |
231545 | 231545 | 2020-06-12 | Marion | Indiana | 18097 | 10694 | 689 |
234651 | 234651 | 2020-06-13 | Marion | Indiana | 18097 | 10736 | 693 |
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);