ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jasper" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535160 | 535160 | 2020-09-15 | Jasper | Indiana | 18073 | 374 | 3 |
531925 | 531925 | 2020-09-14 | Jasper | Indiana | 18073 | 373 | 2 |
528688 | 528688 | 2020-09-13 | Jasper | Indiana | 18073 | 371 | 2 |
525452 | 525452 | 2020-09-12 | Jasper | Indiana | 18073 | 367 | 2 |
522216 | 522216 | 2020-09-11 | Jasper | Indiana | 18073 | 363 | 2 |
518979 | 518979 | 2020-09-10 | Jasper | Indiana | 18073 | 356 | 2 |
515744 | 515744 | 2020-09-09 | Jasper | Indiana | 18073 | 352 | 2 |
512511 | 512511 | 2020-09-08 | Jasper | Indiana | 18073 | 350 | 2 |
509278 | 509278 | 2020-09-07 | Jasper | Indiana | 18073 | 348 | 2 |
506046 | 506046 | 2020-09-06 | Jasper | Indiana | 18073 | 342 | 2 |
502812 | 502812 | 2020-09-05 | Jasper | Indiana | 18073 | 340 | 2 |
499578 | 499578 | 2020-09-04 | Jasper | Indiana | 18073 | 337 | 2 |
496345 | 496345 | 2020-09-03 | Jasper | Indiana | 18073 | 333 | 2 |
493111 | 493111 | 2020-09-02 | Jasper | Indiana | 18073 | 329 | 2 |
489878 | 489878 | 2020-09-01 | Jasper | Indiana | 18073 | 325 | 2 |
486645 | 486645 | 2020-08-31 | Jasper | Indiana | 18073 | 324 | 2 |
483410 | 483410 | 2020-08-30 | Jasper | Indiana | 18073 | 321 | 2 |
480176 | 480176 | 2020-08-29 | Jasper | Indiana | 18073 | 319 | 2 |
476943 | 476943 | 2020-08-28 | Jasper | Indiana | 18073 | 311 | 2 |
473710 | 473710 | 2020-08-27 | Jasper | Indiana | 18073 | 310 | 2 |
470478 | 470478 | 2020-08-26 | Jasper | Indiana | 18073 | 307 | 2 |
467249 | 467249 | 2020-08-25 | Jasper | Indiana | 18073 | 303 | 2 |
464020 | 464020 | 2020-08-24 | Jasper | Indiana | 18073 | 302 | 2 |
460791 | 460791 | 2020-08-23 | Jasper | Indiana | 18073 | 299 | 2 |
457564 | 457564 | 2020-08-22 | Jasper | Indiana | 18073 | 296 | 2 |
454336 | 454336 | 2020-08-21 | Jasper | Indiana | 18073 | 287 | 2 |
451108 | 451108 | 2020-08-20 | Jasper | Indiana | 18073 | 284 | 2 |
447880 | 447880 | 2020-08-19 | Jasper | Indiana | 18073 | 277 | 2 |
444653 | 444653 | 2020-08-18 | Jasper | Indiana | 18073 | 277 | 2 |
441427 | 441427 | 2020-08-17 | Jasper | Indiana | 18073 | 273 | 2 |
438201 | 438201 | 2020-08-16 | Jasper | Indiana | 18073 | 272 | 2 |
434975 | 434975 | 2020-08-15 | Jasper | Indiana | 18073 | 271 | 2 |
431750 | 431750 | 2020-08-14 | Jasper | Indiana | 18073 | 267 | 2 |
428522 | 428522 | 2020-08-13 | Jasper | Indiana | 18073 | 260 | 2 |
425298 | 425298 | 2020-08-12 | Jasper | Indiana | 18073 | 258 | 2 |
422077 | 422077 | 2020-08-11 | Jasper | Indiana | 18073 | 256 | 2 |
418854 | 418854 | 2020-08-10 | Jasper | Indiana | 18073 | 246 | 2 |
415633 | 415633 | 2020-08-09 | Jasper | Indiana | 18073 | 244 | 2 |
412413 | 412413 | 2020-08-08 | Jasper | Indiana | 18073 | 235 | 2 |
409194 | 409194 | 2020-08-07 | Jasper | Indiana | 18073 | 228 | 2 |
405974 | 405974 | 2020-08-06 | Jasper | Indiana | 18073 | 220 | 2 |
402756 | 402756 | 2020-08-05 | Jasper | Indiana | 18073 | 217 | 2 |
399540 | 399540 | 2020-08-04 | Jasper | Indiana | 18073 | 211 | 2 |
396324 | 396324 | 2020-08-03 | Jasper | Indiana | 18073 | 209 | 2 |
393108 | 393108 | 2020-08-02 | Jasper | Indiana | 18073 | 204 | 2 |
389891 | 389891 | 2020-08-01 | Jasper | Indiana | 18073 | 200 | 2 |
386674 | 386674 | 2020-07-31 | Jasper | Indiana | 18073 | 198 | 2 |
383456 | 383456 | 2020-07-30 | Jasper | Indiana | 18073 | 195 | 2 |
380239 | 380239 | 2020-07-29 | Jasper | Indiana | 18073 | 190 | 2 |
377022 | 377022 | 2020-07-28 | Jasper | Indiana | 18073 | 190 | 2 |
373807 | 373807 | 2020-07-27 | Jasper | Indiana | 18073 | 189 | 2 |
370595 | 370595 | 2020-07-26 | Jasper | Indiana | 18073 | 188 | 2 |
367385 | 367385 | 2020-07-25 | Jasper | Indiana | 18073 | 181 | 2 |
364178 | 364178 | 2020-07-24 | Jasper | Indiana | 18073 | 169 | 2 |
360971 | 360971 | 2020-07-23 | Jasper | Indiana | 18073 | 166 | 2 |
357766 | 357766 | 2020-07-22 | Jasper | Indiana | 18073 | 165 | 2 |
354564 | 354564 | 2020-07-21 | Jasper | Indiana | 18073 | 163 | 2 |
351362 | 351362 | 2020-07-20 | Jasper | Indiana | 18073 | 160 | 2 |
348162 | 348162 | 2020-07-19 | Jasper | Indiana | 18073 | 158 | 2 |
344961 | 344961 | 2020-07-18 | Jasper | Indiana | 18073 | 159 | 2 |
341761 | 341761 | 2020-07-17 | Jasper | Indiana | 18073 | 151 | 2 |
338565 | 338565 | 2020-07-16 | Jasper | Indiana | 18073 | 145 | 2 |
335369 | 335369 | 2020-07-15 | Jasper | Indiana | 18073 | 143 | 2 |
332176 | 332176 | 2020-07-14 | Jasper | Indiana | 18073 | 143 | 2 |
328989 | 328989 | 2020-07-13 | Jasper | Indiana | 18073 | 137 | 2 |
325803 | 325803 | 2020-07-12 | Jasper | Indiana | 18073 | 137 | 2 |
322622 | 322622 | 2020-07-11 | Jasper | Indiana | 18073 | 136 | 2 |
319443 | 319443 | 2020-07-10 | Jasper | Indiana | 18073 | 134 | 2 |
316270 | 316270 | 2020-07-09 | Jasper | Indiana | 18073 | 126 | 2 |
313096 | 313096 | 2020-07-08 | Jasper | Indiana | 18073 | 124 | 2 |
309926 | 309926 | 2020-07-07 | Jasper | Indiana | 18073 | 122 | 2 |
306758 | 306758 | 2020-07-06 | Jasper | Indiana | 18073 | 122 | 2 |
303593 | 303593 | 2020-07-05 | Jasper | Indiana | 18073 | 122 | 2 |
300429 | 300429 | 2020-07-04 | Jasper | Indiana | 18073 | 115 | 2 |
297267 | 297267 | 2020-07-03 | Jasper | Indiana | 18073 | 115 | 2 |
294109 | 294109 | 2020-07-02 | Jasper | Indiana | 18073 | 114 | 2 |
290955 | 290955 | 2020-07-01 | Jasper | Indiana | 18073 | 110 | 2 |
287805 | 287805 | 2020-06-30 | Jasper | Indiana | 18073 | 108 | 2 |
284656 | 284656 | 2020-06-29 | Jasper | Indiana | 18073 | 108 | 2 |
281511 | 281511 | 2020-06-28 | Jasper | Indiana | 18073 | 107 | 2 |
278363 | 278363 | 2020-06-27 | Jasper | Indiana | 18073 | 103 | 2 |
275215 | 275215 | 2020-06-26 | Jasper | Indiana | 18073 | 102 | 2 |
272073 | 272073 | 2020-06-25 | Jasper | Indiana | 18073 | 101 | 2 |
268936 | 268936 | 2020-06-24 | Jasper | Indiana | 18073 | 97 | 2 |
265806 | 265806 | 2020-06-23 | Jasper | Indiana | 18073 | 94 | 2 |
262678 | 262678 | 2020-06-22 | Jasper | Indiana | 18073 | 93 | 2 |
259551 | 259551 | 2020-06-21 | Jasper | Indiana | 18073 | 92 | 1 |
256425 | 256425 | 2020-06-20 | Jasper | Indiana | 18073 | 91 | 1 |
253305 | 253305 | 2020-06-19 | Jasper | Indiana | 18073 | 90 | 1 |
250190 | 250190 | 2020-06-18 | Jasper | Indiana | 18073 | 88 | 1 |
247078 | 247078 | 2020-06-17 | Jasper | Indiana | 18073 | 87 | 1 |
243965 | 243965 | 2020-06-16 | Jasper | Indiana | 18073 | 86 | 1 |
240854 | 240854 | 2020-06-15 | Jasper | Indiana | 18073 | 85 | 1 |
237746 | 237746 | 2020-06-14 | Jasper | Indiana | 18073 | 84 | 1 |
234639 | 234639 | 2020-06-13 | Jasper | Indiana | 18073 | 83 | 1 |
231533 | 231533 | 2020-06-12 | Jasper | Indiana | 18073 | 82 | 1 |
228430 | 228430 | 2020-06-11 | Jasper | Indiana | 18073 | 82 | 1 |
225328 | 225328 | 2020-06-10 | Jasper | Indiana | 18073 | 83 | 1 |
222233 | 222233 | 2020-06-09 | Jasper | Indiana | 18073 | 81 | 1 |
219138 | 219138 | 2020-06-08 | Jasper | Indiana | 18073 | 77 | 1 |
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);