ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Kern" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635085 | 635085 | 2020-10-16 | Kern | California | 6029 | 33286 | 408 |
631839 | 631839 | 2020-10-15 | Kern | California | 6029 | 33225 | 406 |
628595 | 628595 | 2020-10-14 | Kern | California | 6029 | 33145 | 406 |
625352 | 625352 | 2020-10-13 | Kern | California | 6029 | 33089 | 397 |
622109 | 622109 | 2020-10-12 | Kern | California | 6029 | 33020 | 395 |
618866 | 618866 | 2020-10-11 | Kern | California | 6029 | 32966 | 395 |
615624 | 615624 | 2020-10-10 | Kern | California | 6029 | 32878 | 394 |
612383 | 612383 | 2020-10-09 | Kern | California | 6029 | 32831 | 392 |
609141 | 609141 | 2020-10-08 | Kern | California | 6029 | 32741 | 387 |
605898 | 605898 | 2020-10-07 | Kern | California | 6029 | 32674 | 387 |
602656 | 602656 | 2020-10-06 | Kern | California | 6029 | 32609 | 386 |
599413 | 599413 | 2020-10-05 | Kern | California | 6029 | 32522 | 386 |
596170 | 596170 | 2020-10-04 | Kern | California | 6029 | 32491 | 386 |
592928 | 592928 | 2020-10-03 | Kern | California | 6029 | 32443 | 386 |
589688 | 589688 | 2020-10-02 | Kern | California | 6029 | 32343 | 381 |
586447 | 586447 | 2020-10-01 | Kern | California | 6029 | 32184 | 371 |
583207 | 583207 | 2020-09-30 | Kern | California | 6029 | 32128 | 370 |
579968 | 579968 | 2020-09-29 | Kern | California | 6029 | 32073 | 369 |
576727 | 576727 | 2020-09-28 | Kern | California | 6029 | 32019 | 369 |
573484 | 573484 | 2020-09-27 | Kern | California | 6029 | 31994 | 369 |
570242 | 570242 | 2020-09-26 | Kern | California | 6029 | 31947 | 369 |
567000 | 567000 | 2020-09-25 | Kern | California | 6029 | 31865 | 367 |
563760 | 563760 | 2020-09-24 | Kern | California | 6029 | 31785 | 361 |
560521 | 560521 | 2020-09-23 | Kern | California | 6029 | 31712 | 360 |
557285 | 557285 | 2020-09-22 | Kern | California | 6029 | 31647 | 357 |
554048 | 554048 | 2020-09-21 | Kern | California | 6029 | 31572 | 354 |
550809 | 550809 | 2020-09-20 | Kern | California | 6029 | 31509 | 354 |
547570 | 547570 | 2020-09-19 | Kern | California | 6029 | 31379 | 354 |
544332 | 544332 | 2020-09-18 | Kern | California | 6029 | 31261 | 350 |
541096 | 541096 | 2020-09-17 | Kern | California | 6029 | 31148 | 340 |
537859 | 537859 | 2020-09-16 | Kern | California | 6029 | 31076 | 340 |
534623 | 534623 | 2020-09-15 | Kern | California | 6029 | 30916 | 333 |
531388 | 531388 | 2020-09-14 | Kern | California | 6029 | 30850 | 332 |
528151 | 528151 | 2020-09-13 | Kern | California | 6029 | 30735 | 332 |
524915 | 524915 | 2020-09-12 | Kern | California | 6029 | 30622 | 326 |
521679 | 521679 | 2020-09-11 | Kern | California | 6029 | 30563 | 322 |
518442 | 518442 | 2020-09-10 | Kern | California | 6029 | 30440 | 307 |
515207 | 515207 | 2020-09-09 | Kern | California | 6029 | 30371 | 297 |
511974 | 511974 | 2020-09-08 | Kern | California | 6029 | 30202 | 296 |
508741 | 508741 | 2020-09-07 | Kern | California | 6029 | 30179 | 296 |
505509 | 505509 | 2020-09-06 | Kern | California | 6029 | 30080 | 296 |
502275 | 502275 | 2020-09-05 | Kern | California | 6029 | 30040 | 296 |
499041 | 499041 | 2020-09-04 | Kern | California | 6029 | 29858 | 296 |
495808 | 495808 | 2020-09-03 | Kern | California | 6029 | 29763 | 296 |
492574 | 492574 | 2020-09-02 | Kern | California | 6029 | 29602 | 292 |
489341 | 489341 | 2020-09-01 | Kern | California | 6029 | 29459 | 292 |
486108 | 486108 | 2020-08-31 | Kern | California | 6029 | 29324 | 286 |
482873 | 482873 | 2020-08-30 | Kern | California | 6029 | 29230 | 286 |
479639 | 479639 | 2020-08-29 | Kern | California | 6029 | 29105 | 286 |
476406 | 476406 | 2020-08-28 | Kern | California | 6029 | 28961 | 273 |
473173 | 473173 | 2020-08-27 | Kern | California | 6029 | 28854 | 256 |
469941 | 469941 | 2020-08-26 | Kern | California | 6029 | 28631 | 251 |
466712 | 466712 | 2020-08-25 | Kern | California | 6029 | 28520 | 251 |
463483 | 463483 | 2020-08-24 | Kern | California | 6029 | 28234 | 240 |
460254 | 460254 | 2020-08-23 | Kern | California | 6029 | 28140 | 240 |
457027 | 457027 | 2020-08-22 | Kern | California | 6029 | 27915 | 240 |
453799 | 453799 | 2020-08-21 | Kern | California | 6029 | 27658 | 238 |
450571 | 450571 | 2020-08-20 | Kern | California | 6029 | 27378 | 229 |
447343 | 447343 | 2020-08-19 | Kern | California | 6029 | 27184 | 228 |
444116 | 444116 | 2020-08-18 | Kern | California | 6029 | 26968 | 216 |
440890 | 440890 | 2020-08-17 | Kern | California | 6029 | 26788 | 204 |
437664 | 437664 | 2020-08-16 | Kern | California | 6029 | 26570 | 204 |
434438 | 434438 | 2020-08-15 | Kern | California | 6029 | 26266 | 204 |
431213 | 431213 | 2020-08-14 | Kern | California | 6029 | 25888 | 204 |
427985 | 427985 | 2020-08-13 | Kern | California | 6029 | 25499 | 187 |
424761 | 424761 | 2020-08-12 | Kern | California | 6029 | 25179 | 183 |
421540 | 421540 | 2020-08-11 | Kern | California | 6029 | 24995 | 183 |
418319 | 418319 | 2020-08-10 | Kern | California | 6029 | 24440 | 171 |
415098 | 415098 | 2020-08-09 | Kern | California | 6029 | 23583 | 171 |
411878 | 411878 | 2020-08-08 | Kern | California | 6029 | 22626 | 171 |
408659 | 408659 | 2020-08-07 | Kern | California | 6029 | 22009 | 160 |
405439 | 405439 | 2020-08-06 | Kern | California | 6029 | 21724 | 152 |
402221 | 402221 | 2020-08-05 | Kern | California | 6029 | 21433 | 152 |
399005 | 399005 | 2020-08-04 | Kern | California | 6029 | 21285 | 151 |
395789 | 395789 | 2020-08-03 | Kern | California | 6029 | 21162 | 144 |
392573 | 392573 | 2020-08-02 | Kern | California | 6029 | 20796 | 144 |
389356 | 389356 | 2020-08-01 | Kern | California | 6029 | 20061 | 144 |
386139 | 386139 | 2020-07-31 | Kern | California | 6029 | 19552 | 140 |
382921 | 382921 | 2020-07-30 | Kern | California | 6029 | 19073 | 139 |
379704 | 379704 | 2020-07-29 | Kern | California | 6029 | 18834 | 136 |
376488 | 376488 | 2020-07-28 | Kern | California | 6029 | 17994 | 136 |
373274 | 373274 | 2020-07-27 | Kern | California | 6029 | 17394 | 123 |
370062 | 370062 | 2020-07-26 | Kern | California | 6029 | 16910 | 123 |
366852 | 366852 | 2020-07-25 | Kern | California | 6029 | 16124 | 123 |
363645 | 363645 | 2020-07-24 | Kern | California | 6029 | 14491 | 123 |
360438 | 360438 | 2020-07-23 | Kern | California | 6029 | 13513 | 115 |
357233 | 357233 | 2020-07-22 | Kern | California | 6029 | 11998 | 115 |
354030 | 354030 | 2020-07-21 | Kern | California | 6029 | 10908 | 105 |
350828 | 350828 | 2020-07-20 | Kern | California | 6029 | 10094 | 105 |
347627 | 347627 | 2020-07-19 | Kern | California | 6029 | 9250 | 105 |
344427 | 344427 | 2020-07-18 | Kern | California | 6029 | 8291 | 105 |
341228 | 341228 | 2020-07-17 | Kern | California | 6029 | 7435 | 105 |
338032 | 338032 | 2020-07-16 | Kern | California | 6029 | 7155 | 105 |
334837 | 334837 | 2020-07-15 | Kern | California | 6029 | 6979 | 98 |
331644 | 331644 | 2020-07-14 | Kern | California | 6029 | 6808 | 98 |
328458 | 328458 | 2020-07-13 | Kern | California | 6029 | 6662 | 98 |
325272 | 325272 | 2020-07-12 | Kern | California | 6029 | 6512 | 97 |
322091 | 322091 | 2020-07-11 | Kern | California | 6029 | 6349 | 97 |
318912 | 318912 | 2020-07-10 | Kern | California | 6029 | 6205 | 97 |
315739 | 315739 | 2020-07-09 | Kern | California | 6029 | 5989 | 89 |
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);