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