ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 15009 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
265632 | 265632 | 2020-06-23 | Maui | Hawaii | 15009 | 122 | 6 |
268762 | 268762 | 2020-06-24 | Maui | Hawaii | 15009 | 122 | 6 |
271898 | 271898 | 2020-06-25 | Maui | Hawaii | 15009 | 122 | 6 |
275038 | 275038 | 2020-06-26 | Maui | Hawaii | 15009 | 122 | 6 |
278186 | 278186 | 2020-06-27 | Maui | Hawaii | 15009 | 122 | 6 |
281333 | 281333 | 2020-06-28 | Maui | Hawaii | 15009 | 123 | 6 |
284479 | 284479 | 2020-06-29 | Maui | Hawaii | 15009 | 122 | 6 |
287625 | 287625 | 2020-06-30 | Maui | Hawaii | 15009 | 123 | 6 |
290776 | 290776 | 2020-07-01 | Maui | Hawaii | 15009 | 125 | 6 |
293930 | 293930 | 2020-07-02 | Maui | Hawaii | 15009 | 125 | 6 |
297086 | 297086 | 2020-07-03 | Maui | Hawaii | 15009 | 127 | 6 |
300248 | 300248 | 2020-07-04 | Maui | Hawaii | 15009 | 128 | 6 |
303412 | 303412 | 2020-07-05 | Maui | Hawaii | 15009 | 128 | 6 |
306576 | 306576 | 2020-07-06 | Maui | Hawaii | 15009 | 128 | 6 |
309744 | 309744 | 2020-07-07 | Maui | Hawaii | 15009 | 128 | 6 |
312914 | 312914 | 2020-07-08 | Maui | Hawaii | 15009 | 130 | 6 |
316089 | 316089 | 2020-07-09 | Maui | Hawaii | 15009 | 130 | 6 |
319262 | 319262 | 2020-07-10 | Maui | Hawaii | 15009 | 131 | 6 |
322441 | 322441 | 2020-07-11 | Maui | Hawaii | 15009 | 133 | 6 |
325622 | 325622 | 2020-07-12 | Maui | Hawaii | 15009 | 134 | 6 |
328808 | 328808 | 2020-07-13 | Maui | Hawaii | 15009 | 135 | 6 |
331995 | 331995 | 2020-07-14 | Maui | Hawaii | 15009 | 135 | 6 |
335188 | 335188 | 2020-07-15 | Maui | Hawaii | 15009 | 135 | 6 |
338383 | 338383 | 2020-07-16 | Maui | Hawaii | 15009 | 135 | 6 |
341580 | 341580 | 2020-07-17 | Maui | Hawaii | 15009 | 135 | 6 |
344779 | 344779 | 2020-07-18 | Maui | Hawaii | 15009 | 135 | 6 |
347979 | 347979 | 2020-07-19 | Maui | Hawaii | 15009 | 135 | 6 |
351180 | 351180 | 2020-07-20 | Maui | Hawaii | 15009 | 135 | 6 |
354382 | 354382 | 2020-07-21 | Maui | Hawaii | 15009 | 139 | 6 |
357585 | 357585 | 2020-07-22 | Maui | Hawaii | 15009 | 139 | 6 |
360790 | 360790 | 2020-07-23 | Maui | Hawaii | 15009 | 141 | 6 |
363997 | 363997 | 2020-07-24 | Maui | Hawaii | 15009 | 141 | 6 |
367204 | 367204 | 2020-07-25 | Maui | Hawaii | 15009 | 146 | 6 |
370414 | 370414 | 2020-07-26 | Maui | Hawaii | 15009 | 153 | 6 |
373626 | 373626 | 2020-07-27 | Maui | Hawaii | 15009 | 153 | 6 |
376840 | 376840 | 2020-07-28 | Maui | Hawaii | 15009 | 154 | 6 |
380057 | 380057 | 2020-07-29 | Maui | Hawaii | 15009 | 163 | 6 |
383274 | 383274 | 2020-07-30 | Maui | Hawaii | 15009 | 167 | 6 |
386492 | 386492 | 2020-07-31 | Maui | Hawaii | 15009 | 171 | 6 |
389709 | 389709 | 2020-08-01 | Maui | Hawaii | 15009 | 170 | 6 |
392926 | 392926 | 2020-08-02 | Maui | Hawaii | 15009 | 171 | 6 |
396142 | 396142 | 2020-08-03 | Maui | Hawaii | 15009 | 178 | 6 |
399358 | 399358 | 2020-08-04 | Maui | Hawaii | 15009 | 178 | 6 |
402574 | 402574 | 2020-08-05 | Maui | Hawaii | 15009 | 177 | 6 |
405792 | 405792 | 2020-08-06 | Maui | Hawaii | 15009 | 180 | 6 |
409012 | 409012 | 2020-08-07 | Maui | Hawaii | 15009 | 181 | 6 |
412231 | 412231 | 2020-08-08 | Maui | Hawaii | 15009 | 184 | 6 |
415451 | 415451 | 2020-08-09 | Maui | Hawaii | 15009 | 185 | 6 |
418672 | 418672 | 2020-08-10 | Maui | Hawaii | 15009 | 186 | 6 |
421893 | 421893 | 2020-08-11 | Maui | Hawaii | 15009 | 190 | 6 |
425114 | 425114 | 2020-08-12 | Maui | Hawaii | 15009 | 191 | 6 |
428338 | 428338 | 2020-08-13 | Maui | Hawaii | 15009 | 198 | 6 |
431566 | 431566 | 2020-08-14 | Maui | Hawaii | 15009 | 206 | 6 |
434791 | 434791 | 2020-08-15 | Maui | Hawaii | 15009 | 213 | 6 |
438017 | 438017 | 2020-08-16 | Maui | Hawaii | 15009 | 226 | 6 |
441243 | 441243 | 2020-08-17 | Maui | Hawaii | 15009 | 235 | 6 |
444469 | 444469 | 2020-08-18 | Maui | Hawaii | 15009 | 242 | 6 |
447696 | 447696 | 2020-08-19 | Maui | Hawaii | 15009 | 262 | 6 |
450924 | 450924 | 2020-08-20 | Maui | Hawaii | 15009 | 263 | 7 |
454152 | 454152 | 2020-08-21 | Maui | Hawaii | 15009 | 269 | 7 |
457380 | 457380 | 2020-08-22 | Maui | Hawaii | 15009 | 279 | 7 |
460607 | 460607 | 2020-08-23 | Maui | Hawaii | 15009 | 290 | 7 |
463836 | 463836 | 2020-08-24 | Maui | Hawaii | 15009 | 300 | 7 |
467065 | 467065 | 2020-08-25 | Maui | Hawaii | 15009 | 303 | 7 |
470294 | 470294 | 2020-08-26 | Maui | Hawaii | 15009 | 311 | 7 |
473526 | 473526 | 2020-08-27 | Maui | Hawaii | 15009 | 318 | 7 |
476759 | 476759 | 2020-08-28 | Maui | Hawaii | 15009 | 324 | 8 |
479992 | 479992 | 2020-08-29 | Maui | Hawaii | 15009 | 330 | 8 |
483226 | 483226 | 2020-08-30 | Maui | Hawaii | 15009 | 334 | 8 |
486461 | 486461 | 2020-08-31 | Maui | Hawaii | 15009 | 335 | 8 |
489694 | 489694 | 2020-09-01 | Maui | Hawaii | 15009 | 340 | 8 |
492927 | 492927 | 2020-09-02 | Maui | Hawaii | 15009 | 342 | 8 |
496161 | 496161 | 2020-09-03 | Maui | Hawaii | 15009 | 346 | 8 |
499394 | 499394 | 2020-09-04 | Maui | Hawaii | 15009 | 347 | 8 |
502628 | 502628 | 2020-09-05 | Maui | Hawaii | 15009 | 352 | 8 |
505862 | 505862 | 2020-09-06 | Maui | Hawaii | 15009 | 354 | 8 |
509094 | 509094 | 2020-09-07 | Maui | Hawaii | 15009 | 358 | 8 |
512327 | 512327 | 2020-09-08 | Maui | Hawaii | 15009 | 428 | 9 |
515560 | 515560 | 2020-09-09 | Maui | Hawaii | 15009 | 428 | 9 |
518795 | 518795 | 2020-09-10 | Maui | Hawaii | 15009 | 431 | 9 |
522032 | 522032 | 2020-09-11 | Maui | Hawaii | 15009 | 437 | 9 |
525268 | 525268 | 2020-09-12 | Maui | Hawaii | 15009 | 443 | 9 |
528504 | 528504 | 2020-09-13 | Maui | Hawaii | 15009 | 445 | 9 |
531741 | 531741 | 2020-09-14 | Maui | Hawaii | 15009 | 448 | 9 |
534976 | 534976 | 2020-09-15 | Maui | Hawaii | 15009 | 448 | 9 |
538212 | 538212 | 2020-09-16 | Maui | Hawaii | 15009 | 448 | 9 |
541449 | 541449 | 2020-09-17 | Maui | Hawaii | 15009 | 451 | 9 |
544685 | 544685 | 2020-09-18 | Maui | Hawaii | 15009 | 474 | 9 |
547923 | 547923 | 2020-09-19 | Maui | Hawaii | 15009 | 477 | 9 |
551162 | 551162 | 2020-09-20 | Maui | Hawaii | 15009 | 478 | 9 |
554401 | 554401 | 2020-09-21 | Maui | Hawaii | 15009 | 478 | 9 |
557638 | 557638 | 2020-09-22 | Maui | Hawaii | 15009 | 478 | 9 |
560874 | 560874 | 2020-09-23 | Maui | Hawaii | 15009 | 479 | 9 |
564114 | 564114 | 2020-09-24 | Maui | Hawaii | 15009 | 481 | 9 |
567354 | 567354 | 2020-09-25 | Maui | Hawaii | 15009 | 490 | 9 |
570596 | 570596 | 2020-09-26 | Maui | Hawaii | 15009 | 490 | 9 |
573838 | 573838 | 2020-09-27 | Maui | Hawaii | 15009 | 490 | 9 |
577081 | 577081 | 2020-09-28 | Maui | Hawaii | 15009 | 490 | 9 |
580322 | 580322 | 2020-09-29 | Maui | Hawaii | 15009 | 492 | 9 |
583561 | 583561 | 2020-09-30 | Maui | Hawaii | 15009 | 493 | 9 |
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);