ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Allen" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535125 | 535125 | 2020-09-15 | Allen | Indiana | 18003 | 5731 | 206 |
531890 | 531890 | 2020-09-14 | Allen | Indiana | 18003 | 5680 | 203 |
528653 | 528653 | 2020-09-13 | Allen | Indiana | 18003 | 5655 | 203 |
525417 | 525417 | 2020-09-12 | Allen | Indiana | 18003 | 5620 | 203 |
522181 | 522181 | 2020-09-11 | Allen | Indiana | 18003 | 5547 | 199 |
518944 | 518944 | 2020-09-10 | Allen | Indiana | 18003 | 5491 | 197 |
515709 | 515709 | 2020-09-09 | Allen | Indiana | 18003 | 5438 | 197 |
512476 | 512476 | 2020-09-08 | Allen | Indiana | 18003 | 5400 | 195 |
509243 | 509243 | 2020-09-07 | Allen | Indiana | 18003 | 5360 | 192 |
506011 | 506011 | 2020-09-06 | Allen | Indiana | 18003 | 5321 | 192 |
502777 | 502777 | 2020-09-05 | Allen | Indiana | 18003 | 5277 | 192 |
499543 | 499543 | 2020-09-04 | Allen | Indiana | 18003 | 5212 | 192 |
496310 | 496310 | 2020-09-03 | Allen | Indiana | 18003 | 5154 | 189 |
493076 | 493076 | 2020-09-02 | Allen | Indiana | 18003 | 5088 | 189 |
489843 | 489843 | 2020-09-01 | Allen | Indiana | 18003 | 5035 | 188 |
486610 | 486610 | 2020-08-31 | Allen | Indiana | 18003 | 5005 | 188 |
483375 | 483375 | 2020-08-30 | Allen | Indiana | 18003 | 4979 | 187 |
480141 | 480141 | 2020-08-29 | Allen | Indiana | 18003 | 4932 | 187 |
476908 | 476908 | 2020-08-28 | Allen | Indiana | 18003 | 4875 | 187 |
473675 | 473675 | 2020-08-27 | Allen | Indiana | 18003 | 4852 | 187 |
470443 | 470443 | 2020-08-26 | Allen | Indiana | 18003 | 4782 | 186 |
467214 | 467214 | 2020-08-25 | Allen | Indiana | 18003 | 4740 | 183 |
463985 | 463985 | 2020-08-24 | Allen | Indiana | 18003 | 4676 | 182 |
460756 | 460756 | 2020-08-23 | Allen | Indiana | 18003 | 4578 | 182 |
457529 | 457529 | 2020-08-22 | Allen | Indiana | 18003 | 4552 | 182 |
454301 | 454301 | 2020-08-21 | Allen | Indiana | 18003 | 4488 | 182 |
451073 | 451073 | 2020-08-20 | Allen | Indiana | 18003 | 4447 | 181 |
447845 | 447845 | 2020-08-19 | Allen | Indiana | 18003 | 4396 | 181 |
444618 | 444618 | 2020-08-18 | Allen | Indiana | 18003 | 4376 | 179 |
441392 | 441392 | 2020-08-17 | Allen | Indiana | 18003 | 4340 | 176 |
438166 | 438166 | 2020-08-16 | Allen | Indiana | 18003 | 4303 | 176 |
434940 | 434940 | 2020-08-15 | Allen | Indiana | 18003 | 4251 | 176 |
431715 | 431715 | 2020-08-14 | Allen | Indiana | 18003 | 4187 | 174 |
428487 | 428487 | 2020-08-13 | Allen | Indiana | 18003 | 4129 | 174 |
425263 | 425263 | 2020-08-12 | Allen | Indiana | 18003 | 4066 | 173 |
422042 | 422042 | 2020-08-11 | Allen | Indiana | 18003 | 4028 | 173 |
418819 | 418819 | 2020-08-10 | Allen | Indiana | 18003 | 3963 | 173 |
415598 | 415598 | 2020-08-09 | Allen | Indiana | 18003 | 3928 | 173 |
412378 | 412378 | 2020-08-08 | Allen | Indiana | 18003 | 3861 | 173 |
409159 | 409159 | 2020-08-07 | Allen | Indiana | 18003 | 3815 | 171 |
405939 | 405939 | 2020-08-06 | Allen | Indiana | 18003 | 3751 | 170 |
402721 | 402721 | 2020-08-05 | Allen | Indiana | 18003 | 3721 | 170 |
399505 | 399505 | 2020-08-04 | Allen | Indiana | 18003 | 3688 | 168 |
396289 | 396289 | 2020-08-03 | Allen | Indiana | 18003 | 3661 | 168 |
393073 | 393073 | 2020-08-02 | Allen | Indiana | 18003 | 3637 | 167 |
389856 | 389856 | 2020-08-01 | Allen | Indiana | 18003 | 3583 | 167 |
386639 | 386639 | 2020-07-31 | Allen | Indiana | 18003 | 3535 | 167 |
383421 | 383421 | 2020-07-30 | Allen | Indiana | 18003 | 3506 | 165 |
380204 | 380204 | 2020-07-29 | Allen | Indiana | 18003 | 3467 | 165 |
376987 | 376987 | 2020-07-28 | Allen | Indiana | 18003 | 3442 | 165 |
373772 | 373772 | 2020-07-27 | Allen | Indiana | 18003 | 3401 | 162 |
370560 | 370560 | 2020-07-26 | Allen | Indiana | 18003 | 3371 | 162 |
367350 | 367350 | 2020-07-25 | Allen | Indiana | 18003 | 3333 | 161 |
364143 | 364143 | 2020-07-24 | Allen | Indiana | 18003 | 3304 | 161 |
360936 | 360936 | 2020-07-23 | Allen | Indiana | 18003 | 3270 | 159 |
357731 | 357731 | 2020-07-22 | Allen | Indiana | 18003 | 3238 | 158 |
354529 | 354529 | 2020-07-21 | Allen | Indiana | 18003 | 3224 | 154 |
351327 | 351327 | 2020-07-20 | Allen | Indiana | 18003 | 3189 | 153 |
348127 | 348127 | 2020-07-19 | Allen | Indiana | 18003 | 3156 | 151 |
344926 | 344926 | 2020-07-18 | Allen | Indiana | 18003 | 3123 | 151 |
341726 | 341726 | 2020-07-17 | Allen | Indiana | 18003 | 3081 | 148 |
338530 | 338530 | 2020-07-16 | Allen | Indiana | 18003 | 3055 | 148 |
335334 | 335334 | 2020-07-15 | Allen | Indiana | 18003 | 3032 | 146 |
332141 | 332141 | 2020-07-14 | Allen | Indiana | 18003 | 3007 | 145 |
328954 | 328954 | 2020-07-13 | Allen | Indiana | 18003 | 2990 | 144 |
325768 | 325768 | 2020-07-12 | Allen | Indiana | 18003 | 2971 | 144 |
322587 | 322587 | 2020-07-11 | Allen | Indiana | 18003 | 2958 | 144 |
319408 | 319408 | 2020-07-10 | Allen | Indiana | 18003 | 2921 | 143 |
316235 | 316235 | 2020-07-09 | Allen | Indiana | 18003 | 2886 | 143 |
313061 | 313061 | 2020-07-08 | Allen | Indiana | 18003 | 2854 | 143 |
309891 | 309891 | 2020-07-07 | Allen | Indiana | 18003 | 2834 | 142 |
306723 | 306723 | 2020-07-06 | Allen | Indiana | 18003 | 2817 | 142 |
303558 | 303558 | 2020-07-05 | Allen | Indiana | 18003 | 2781 | 139 |
300394 | 300394 | 2020-07-04 | Allen | Indiana | 18003 | 2756 | 139 |
297232 | 297232 | 2020-07-03 | Allen | Indiana | 18003 | 2736 | 138 |
294074 | 294074 | 2020-07-02 | Allen | Indiana | 18003 | 2714 | 127 |
290920 | 290920 | 2020-07-01 | Allen | Indiana | 18003 | 2696 | 124 |
287770 | 287770 | 2020-06-30 | Allen | Indiana | 18003 | 2668 | 120 |
284621 | 284621 | 2020-06-29 | Allen | Indiana | 18003 | 2640 | 116 |
281476 | 281476 | 2020-06-28 | Allen | Indiana | 18003 | 2617 | 114 |
278328 | 278328 | 2020-06-27 | Allen | Indiana | 18003 | 2594 | 114 |
275180 | 275180 | 2020-06-26 | Allen | Indiana | 18003 | 2566 | 110 |
272038 | 272038 | 2020-06-25 | Allen | Indiana | 18003 | 2526 | 107 |
268901 | 268901 | 2020-06-24 | Allen | Indiana | 18003 | 2485 | 107 |
265771 | 265771 | 2020-06-23 | Allen | Indiana | 18003 | 2451 | 107 |
262643 | 262643 | 2020-06-22 | Allen | Indiana | 18003 | 2442 | 105 |
259516 | 259516 | 2020-06-21 | Allen | Indiana | 18003 | 2428 | 101 |
256390 | 256390 | 2020-06-20 | Allen | Indiana | 18003 | 2382 | 101 |
253270 | 253270 | 2020-06-19 | Allen | Indiana | 18003 | 2341 | 101 |
250155 | 250155 | 2020-06-18 | Allen | Indiana | 18003 | 2334 | 101 |
247043 | 247043 | 2020-06-17 | Allen | Indiana | 18003 | 2287 | 100 |
243930 | 243930 | 2020-06-16 | Allen | Indiana | 18003 | 2271 | 97 |
240819 | 240819 | 2020-06-15 | Allen | Indiana | 18003 | 2233 | 94 |
237711 | 237711 | 2020-06-14 | Allen | Indiana | 18003 | 2204 | 89 |
234604 | 234604 | 2020-06-13 | Allen | Indiana | 18003 | 2177 | 89 |
231498 | 231498 | 2020-06-12 | Allen | Indiana | 18003 | 2136 | 88 |
228395 | 228395 | 2020-06-11 | Allen | Indiana | 18003 | 2098 | 87 |
225293 | 225293 | 2020-06-10 | Allen | Indiana | 18003 | 2023 | 86 |
222198 | 222198 | 2020-06-09 | Allen | Indiana | 18003 | 1965 | 86 |
219103 | 219103 | 2020-06-08 | Allen | Indiana | 18003 | 1905 | 86 |
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);