ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 9009 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
262262 | 262262 | 2020-06-22 | New Haven | Connecticut | 9009 | 12196 | 1063 |
265390 | 265390 | 2020-06-23 | New Haven | Connecticut | 9009 | 12225 | 1065 |
268520 | 268520 | 2020-06-24 | New Haven | Connecticut | 9009 | 12227 | 1066 |
271656 | 271656 | 2020-06-25 | New Haven | Connecticut | 9009 | 12245 | 1068 |
274796 | 274796 | 2020-06-26 | New Haven | Connecticut | 9009 | 12254 | 1069 |
277944 | 277944 | 2020-06-27 | New Haven | Connecticut | 9009 | 12275 | 1069 |
281091 | 281091 | 2020-06-28 | New Haven | Connecticut | 9009 | 12299 | 1073 |
284237 | 284237 | 2020-06-29 | New Haven | Connecticut | 9009 | 12318 | 1075 |
287383 | 287383 | 2020-06-30 | New Haven | Connecticut | 9009 | 12359 | 1075 |
290534 | 290534 | 2020-07-01 | New Haven | Connecticut | 9009 | 12368 | 1073 |
293688 | 293688 | 2020-07-02 | New Haven | Connecticut | 9009 | 12383 | 1074 |
296844 | 296844 | 2020-07-03 | New Haven | Connecticut | 9009 | 12409 | 1077 |
300006 | 300006 | 2020-07-04 | New Haven | Connecticut | 9009 | 12409 | 1077 |
303170 | 303170 | 2020-07-05 | New Haven | Connecticut | 9009 | 12409 | 1077 |
306334 | 306334 | 2020-07-06 | New Haven | Connecticut | 9009 | 12462 | 1078 |
309502 | 309502 | 2020-07-07 | New Haven | Connecticut | 9009 | 12473 | 1078 |
312672 | 312672 | 2020-07-08 | New Haven | Connecticut | 9009 | 12486 | 1079 |
315847 | 315847 | 2020-07-09 | New Haven | Connecticut | 9009 | 12509 | 1079 |
319020 | 319020 | 2020-07-10 | New Haven | Connecticut | 9009 | 12532 | 1079 |
322199 | 322199 | 2020-07-11 | New Haven | Connecticut | 9009 | 12532 | 1079 |
325380 | 325380 | 2020-07-12 | New Haven | Connecticut | 9009 | 12532 | 1079 |
328566 | 328566 | 2020-07-13 | New Haven | Connecticut | 9009 | 12612 | 1087 |
331753 | 331753 | 2020-07-14 | New Haven | Connecticut | 9009 | 12617 | 1087 |
334946 | 334946 | 2020-07-15 | New Haven | Connecticut | 9009 | 12643 | 1088 |
338141 | 338141 | 2020-07-16 | New Haven | Connecticut | 9009 | 12686 | 1088 |
341338 | 341338 | 2020-07-17 | New Haven | Connecticut | 9009 | 12733 | 1090 |
344537 | 344537 | 2020-07-18 | New Haven | Connecticut | 9009 | 12733 | 1090 |
347737 | 347737 | 2020-07-19 | New Haven | Connecticut | 9009 | 12733 | 1090 |
350938 | 350938 | 2020-07-20 | New Haven | Connecticut | 9009 | 12788 | 1092 |
354140 | 354140 | 2020-07-21 | New Haven | Connecticut | 9009 | 12794 | 1092 |
357343 | 357343 | 2020-07-22 | New Haven | Connecticut | 9009 | 12825 | 1092 |
360548 | 360548 | 2020-07-23 | New Haven | Connecticut | 9009 | 12835 | 1093 |
363755 | 363755 | 2020-07-24 | New Haven | Connecticut | 9009 | 12884 | 1095 |
366962 | 366962 | 2020-07-25 | New Haven | Connecticut | 9009 | 12884 | 1095 |
370172 | 370172 | 2020-07-26 | New Haven | Connecticut | 9009 | 12884 | 1095 |
373384 | 373384 | 2020-07-27 | New Haven | Connecticut | 9009 | 12941 | 1097 |
376598 | 376598 | 2020-07-28 | New Haven | Connecticut | 9009 | 12965 | 1099 |
379815 | 379815 | 2020-07-29 | New Haven | Connecticut | 9009 | 12983 | 1100 |
383032 | 383032 | 2020-07-30 | New Haven | Connecticut | 9009 | 13013 | 1101 |
386250 | 386250 | 2020-07-31 | New Haven | Connecticut | 9009 | 13041 | 1101 |
389467 | 389467 | 2020-08-01 | New Haven | Connecticut | 9009 | 13041 | 1101 |
392684 | 392684 | 2020-08-02 | New Haven | Connecticut | 9009 | 13041 | 1101 |
395900 | 395900 | 2020-08-03 | New Haven | Connecticut | 9009 | 13086 | 1104 |
399116 | 399116 | 2020-08-04 | New Haven | Connecticut | 9009 | 13100 | 1104 |
402332 | 402332 | 2020-08-05 | New Haven | Connecticut | 9009 | 13118 | 1104 |
405550 | 405550 | 2020-08-06 | New Haven | Connecticut | 9009 | 13128 | 1104 |
408770 | 408770 | 2020-08-07 | New Haven | Connecticut | 9009 | 13145 | 1104 |
411989 | 411989 | 2020-08-08 | New Haven | Connecticut | 9009 | 13145 | 1104 |
415209 | 415209 | 2020-08-09 | New Haven | Connecticut | 9009 | 13145 | 1104 |
418430 | 418430 | 2020-08-10 | New Haven | Connecticut | 9009 | 13224 | 1106 |
421651 | 421651 | 2020-08-11 | New Haven | Connecticut | 9009 | 13240 | 1106 |
424872 | 424872 | 2020-08-12 | New Haven | Connecticut | 9009 | 13254 | 1109 |
428096 | 428096 | 2020-08-13 | New Haven | Connecticut | 9009 | 13272 | 1109 |
431324 | 431324 | 2020-08-14 | New Haven | Connecticut | 9009 | 13316 | 1109 |
434549 | 434549 | 2020-08-15 | New Haven | Connecticut | 9009 | 13316 | 1109 |
437775 | 437775 | 2020-08-16 | New Haven | Connecticut | 9009 | 13316 | 1109 |
441001 | 441001 | 2020-08-17 | New Haven | Connecticut | 9009 | 13378 | 1109 |
444227 | 444227 | 2020-08-18 | New Haven | Connecticut | 9009 | 13376 | 1109 |
447454 | 447454 | 2020-08-19 | New Haven | Connecticut | 9009 | 13388 | 1111 |
450682 | 450682 | 2020-08-20 | New Haven | Connecticut | 9009 | 13422 | 1111 |
453910 | 453910 | 2020-08-21 | New Haven | Connecticut | 9009 | 13442 | 1111 |
457138 | 457138 | 2020-08-22 | New Haven | Connecticut | 9009 | 13442 | 1111 |
460365 | 460365 | 2020-08-23 | New Haven | Connecticut | 9009 | 13442 | 1111 |
463594 | 463594 | 2020-08-24 | New Haven | Connecticut | 9009 | 13518 | 1111 |
466823 | 466823 | 2020-08-25 | New Haven | Connecticut | 9009 | 13524 | 1110 |
470052 | 470052 | 2020-08-26 | New Haven | Connecticut | 9009 | 13556 | 1109 |
473284 | 473284 | 2020-08-27 | New Haven | Connecticut | 9009 | 13584 | 1109 |
476517 | 476517 | 2020-08-28 | New Haven | Connecticut | 9009 | 13622 | 1109 |
479750 | 479750 | 2020-08-29 | New Haven | Connecticut | 9009 | 13622 | 1109 |
482984 | 482984 | 2020-08-30 | New Haven | Connecticut | 9009 | 13622 | 1109 |
486219 | 486219 | 2020-08-31 | New Haven | Connecticut | 9009 | 13675 | 1109 |
489452 | 489452 | 2020-09-01 | New Haven | Connecticut | 9009 | 13711 | 1109 |
492685 | 492685 | 2020-09-02 | New Haven | Connecticut | 9009 | 13736 | 1109 |
495919 | 495919 | 2020-09-03 | New Haven | Connecticut | 9009 | 13763 | 1109 |
499152 | 499152 | 2020-09-04 | New Haven | Connecticut | 9009 | 13793 | 1109 |
502386 | 502386 | 2020-09-05 | New Haven | Connecticut | 9009 | 13793 | 1109 |
505620 | 505620 | 2020-09-06 | New Haven | Connecticut | 9009 | 13793 | 1109 |
508852 | 508852 | 2020-09-07 | New Haven | Connecticut | 9009 | 13793 | 1109 |
512085 | 512085 | 2020-09-08 | New Haven | Connecticut | 9009 | 13858 | 1109 |
515318 | 515318 | 2020-09-09 | New Haven | Connecticut | 9009 | 13877 | 1109 |
518553 | 518553 | 2020-09-10 | New Haven | Connecticut | 9009 | 13917 | 1110 |
521790 | 521790 | 2020-09-11 | New Haven | Connecticut | 9009 | 13961 | 1110 |
525026 | 525026 | 2020-09-12 | New Haven | Connecticut | 9009 | 13961 | 1110 |
528262 | 528262 | 2020-09-13 | New Haven | Connecticut | 9009 | 13961 | 1110 |
531499 | 531499 | 2020-09-14 | New Haven | Connecticut | 9009 | 14059 | 1111 |
534734 | 534734 | 2020-09-15 | New Haven | Connecticut | 9009 | 14082 | 1111 |
537970 | 537970 | 2020-09-16 | New Haven | Connecticut | 9009 | 14102 | 1111 |
541207 | 541207 | 2020-09-17 | New Haven | Connecticut | 9009 | 14145 | 1111 |
544443 | 544443 | 2020-09-18 | New Haven | Connecticut | 9009 | 14164 | 1111 |
547681 | 547681 | 2020-09-19 | New Haven | Connecticut | 9009 | 14164 | 1111 |
550920 | 550920 | 2020-09-20 | New Haven | Connecticut | 9009 | 14164 | 1111 |
554159 | 554159 | 2020-09-21 | New Haven | Connecticut | 9009 | 14261 | 1112 |
557396 | 557396 | 2020-09-22 | New Haven | Connecticut | 9009 | 14278 | 1113 |
560632 | 560632 | 2020-09-23 | New Haven | Connecticut | 9009 | 14294 | 1114 |
563872 | 563872 | 2020-09-24 | New Haven | Connecticut | 9009 | 14319 | 1115 |
567112 | 567112 | 2020-09-25 | New Haven | Connecticut | 9009 | 14340 | 1115 |
570354 | 570354 | 2020-09-26 | New Haven | Connecticut | 9009 | 14340 | 1115 |
573596 | 573596 | 2020-09-27 | New Haven | Connecticut | 9009 | 14340 | 1115 |
576839 | 576839 | 2020-09-28 | New Haven | Connecticut | 9009 | 14434 | 1115 |
580080 | 580080 | 2020-09-29 | New Haven | Connecticut | 9009 | 14451 | 1115 |
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);