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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386686 | 386686 | 2020-07-31 | Marion | Indiana | 18097 | 14575 | 766 |
383468 | 383468 | 2020-07-30 | Marion | Indiana | 18097 | 14412 | 765 |
380251 | 380251 | 2020-07-29 | Marion | Indiana | 18097 | 14237 | 762 |
377034 | 377034 | 2020-07-28 | Marion | Indiana | 18097 | 14094 | 761 |
373819 | 373819 | 2020-07-27 | Marion | Indiana | 18097 | 13953 | 760 |
370607 | 370607 | 2020-07-26 | Marion | Indiana | 18097 | 13835 | 759 |
367397 | 367397 | 2020-07-25 | Marion | Indiana | 18097 | 13685 | 759 |
364190 | 364190 | 2020-07-24 | Marion | Indiana | 18097 | 13545 | 758 |
360983 | 360983 | 2020-07-23 | Marion | Indiana | 18097 | 13380 | 758 |
357778 | 357778 | 2020-07-22 | Marion | Indiana | 18097 | 13228 | 758 |
354576 | 354576 | 2020-07-21 | Marion | Indiana | 18097 | 13124 | 755 |
351374 | 351374 | 2020-07-20 | Marion | Indiana | 18097 | 12976 | 752 |
348174 | 348174 | 2020-07-19 | Marion | Indiana | 18097 | 12883 | 752 |
344973 | 344973 | 2020-07-18 | Marion | Indiana | 18097 | 12742 | 752 |
341773 | 341773 | 2020-07-17 | Marion | Indiana | 18097 | 12617 | 748 |
338577 | 338577 | 2020-07-16 | Marion | Indiana | 18097 | 12494 | 747 |
335381 | 335381 | 2020-07-15 | Marion | Indiana | 18097 | 12409 | 745 |
332188 | 332188 | 2020-07-14 | Marion | Indiana | 18097 | 12323 | 743 |
329001 | 329001 | 2020-07-13 | Marion | Indiana | 18097 | 12243 | 739 |
325815 | 325815 | 2020-07-12 | Marion | Indiana | 18097 | 12206 | 739 |
322634 | 322634 | 2020-07-11 | Marion | Indiana | 18097 | 12151 | 739 |
319455 | 319455 | 2020-07-10 | Marion | Indiana | 18097 | 12052 | 738 |
316282 | 316282 | 2020-07-09 | Marion | Indiana | 18097 | 11943 | 736 |
313108 | 313108 | 2020-07-08 | Marion | Indiana | 18097 | 11891 | 735 |
309938 | 309938 | 2020-07-07 | Marion | Indiana | 18097 | 11854 | 735 |
306770 | 306770 | 2020-07-06 | Marion | Indiana | 18097 | 11814 | 731 |
303605 | 303605 | 2020-07-05 | Marion | Indiana | 18097 | 11755 | 730 |
300441 | 300441 | 2020-07-04 | Marion | Indiana | 18097 | 11678 | 730 |
297279 | 297279 | 2020-07-03 | Marion | Indiana | 18097 | 11630 | 730 |
294121 | 294121 | 2020-07-02 | Marion | Indiana | 18097 | 11560 | 727 |
290967 | 290967 | 2020-07-01 | Marion | Indiana | 18097 | 11513 | 727 |
287817 | 287817 | 2020-06-30 | Marion | Indiana | 18097 | 11451 | 726 |
284668 | 284668 | 2020-06-29 | Marion | Indiana | 18097 | 11401 | 724 |
281523 | 281523 | 2020-06-28 | Marion | Indiana | 18097 | 11358 | 724 |
278375 | 278375 | 2020-06-27 | Marion | Indiana | 18097 | 11304 | 724 |
275227 | 275227 | 2020-06-26 | Marion | Indiana | 18097 | 11226 | 723 |
272085 | 272085 | 2020-06-25 | Marion | Indiana | 18097 | 11164 | 722 |
268948 | 268948 | 2020-06-24 | Marion | Indiana | 18097 | 11118 | 720 |
265818 | 265818 | 2020-06-23 | Marion | Indiana | 18097 | 11099 | 716 |
262690 | 262690 | 2020-06-22 | Marion | Indiana | 18097 | 11083 | 715 |
259563 | 259563 | 2020-06-21 | Marion | Indiana | 18097 | 11067 | 714 |
256437 | 256437 | 2020-06-20 | Marion | Indiana | 18097 | 11026 | 713 |
253317 | 253317 | 2020-06-19 | Marion | Indiana | 18097 | 11007 | 711 |
250202 | 250202 | 2020-06-18 | Marion | Indiana | 18097 | 10973 | 706 |
247090 | 247090 | 2020-06-17 | Marion | Indiana | 18097 | 10982 | 702 |
243977 | 243977 | 2020-06-16 | Marion | Indiana | 18097 | 10950 | 699 |
240866 | 240866 | 2020-06-15 | Marion | Indiana | 18097 | 10905 | 697 |
237758 | 237758 | 2020-06-14 | Marion | Indiana | 18097 | 10779 | 694 |
234651 | 234651 | 2020-06-13 | Marion | Indiana | 18097 | 10736 | 693 |
231545 | 231545 | 2020-06-12 | Marion | Indiana | 18097 | 10694 | 689 |
228442 | 228442 | 2020-06-11 | Marion | Indiana | 18097 | 10609 | 689 |
225340 | 225340 | 2020-06-10 | Marion | Indiana | 18097 | 10581 | 680 |
222245 | 222245 | 2020-06-09 | Marion | Indiana | 18097 | 10559 | 676 |
219150 | 219150 | 2020-06-08 | Marion | Indiana | 18097 | 10471 | 669 |
216058 | 216058 | 2020-06-07 | Marion | Indiana | 18097 | 10440 | 668 |
212971 | 212971 | 2020-06-06 | Marion | Indiana | 18097 | 10390 | 663 |
209886 | 209886 | 2020-06-05 | Marion | Indiana | 18097 | 10301 | 650 |
206805 | 206805 | 2020-06-04 | Marion | Indiana | 18097 | 10207 | 644 |
203725 | 203725 | 2020-06-03 | Marion | Indiana | 18097 | 10148 | 639 |
200649 | 200649 | 2020-06-02 | Marion | Indiana | 18097 | 10089 | 637 |
197576 | 197576 | 2020-06-01 | Marion | Indiana | 18097 | 10005 | 620 |
194506 | 194506 | 2020-05-31 | Marion | Indiana | 18097 | 9958 | 617 |
191439 | 191439 | 2020-05-30 | Marion | Indiana | 18097 | 9866 | 615 |
188374 | 188374 | 2020-05-29 | Marion | Indiana | 18097 | 9720 | 609 |
185316 | 185316 | 2020-05-28 | Marion | Indiana | 18097 | 9626 | 596 |
182262 | 182262 | 2020-05-27 | Marion | Indiana | 18097 | 9471 | 584 |
179218 | 179218 | 2020-05-26 | Marion | Indiana | 18097 | 9367 | 577 |
176174 | 176174 | 2020-05-25 | Marion | Indiana | 18097 | 9287 | 571 |
173130 | 173130 | 2020-05-24 | Marion | Indiana | 18097 | 9230 | 571 |
170089 | 170089 | 2020-05-23 | Marion | Indiana | 18097 | 9138 | 569 |
167052 | 167052 | 2020-05-22 | Marion | Indiana | 18097 | 9024 | 564 |
164019 | 164019 | 2020-05-21 | Marion | Indiana | 18097 | 8912 | 554 |
160991 | 160991 | 2020-05-20 | Marion | Indiana | 18097 | 8753 | 541 |
157965 | 157965 | 2020-05-19 | Marion | Indiana | 18097 | 8632 | 532 |
154949 | 154949 | 2020-05-18 | Marion | Indiana | 18097 | 8495 | 515 |
151937 | 151937 | 2020-05-17 | Marion | Indiana | 18097 | 8392 | 512 |
148928 | 148928 | 2020-05-16 | Marion | Indiana | 18097 | 8240 | 509 |
145924 | 145924 | 2020-05-15 | Marion | Indiana | 18097 | 8082 | 500 |
142924 | 142924 | 2020-05-14 | Marion | Indiana | 18097 | 7869 | 484 |
139928 | 139928 | 2020-05-13 | Marion | Indiana | 18097 | 7779 | 473 |
136936 | 136936 | 2020-05-12 | Marion | Indiana | 18097 | 7703 | 462 |
133947 | 133947 | 2020-05-11 | Marion | Indiana | 18097 | 7580 | 455 |
130957 | 130957 | 2020-05-10 | Marion | Indiana | 18097 | 7405 | 448 |
127966 | 127966 | 2020-05-09 | Marion | Indiana | 18097 | 7314 | 444 |
124979 | 124979 | 2020-05-08 | Marion | Indiana | 18097 | 7142 | 430 |
121999 | 121999 | 2020-05-07 | Marion | Indiana | 18097 | 6978 | 425 |
119029 | 119029 | 2020-05-06 | Marion | Indiana | 18097 | 6784 | 413 |
116069 | 116069 | 2020-05-05 | Marion | Indiana | 18097 | 6469 | 398 |
113186 | 113186 | 2020-05-04 | Marion | Indiana | 18097 | 6375 | 387 |
110311 | 110311 | 2020-05-03 | Marion | Indiana | 18097 | 6225 | 385 |
107441 | 107441 | 2020-05-02 | Marion | Indiana | 18097 | 6032 | 382 |
104576 | 104576 | 2020-05-01 | Marion | Indiana | 18097 | 5801 | 364 |
101720 | 101720 | 2020-04-30 | Marion | Indiana | 18097 | 5576 | 353 |
98869 | 98869 | 2020-04-29 | Marion | Indiana | 18097 | 5340 | 329 |
96025 | 96025 | 2020-04-28 | Marion | Indiana | 18097 | 5121 | 304 |
93193 | 93193 | 2020-04-27 | Marion | Indiana | 18097 | 4967 | 289 |
90374 | 90374 | 2020-04-26 | Marion | Indiana | 18097 | 4832 | 287 |
87558 | 87558 | 2020-04-25 | Marion | Indiana | 18097 | 4763 | 283 |
84748 | 84748 | 2020-04-24 | Marion | Indiana | 18097 | 4571 | 266 |
81948 | 81948 | 2020-04-23 | Marion | Indiana | 18097 | 4437 | 255 |
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);