ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 6107 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635124 | 635124 | 2020-10-16 | Tulare | California | 6107 | 17120 | 275 |
631878 | 631878 | 2020-10-15 | Tulare | California | 6107 | 17072 | 274 |
628634 | 628634 | 2020-10-14 | Tulare | California | 6107 | 17015 | 273 |
625391 | 625391 | 2020-10-13 | Tulare | California | 6107 | 16976 | 269 |
622148 | 622148 | 2020-10-12 | Tulare | California | 6107 | 16890 | 269 |
618905 | 618905 | 2020-10-11 | Tulare | California | 6107 | 16794 | 269 |
615663 | 615663 | 2020-10-10 | Tulare | California | 6107 | 16794 | 269 |
612422 | 612422 | 2020-10-09 | Tulare | California | 6107 | 16794 | 269 |
609180 | 609180 | 2020-10-08 | Tulare | California | 6107 | 16718 | 269 |
605937 | 605937 | 2020-10-07 | Tulare | California | 6107 | 16634 | 267 |
602695 | 602695 | 2020-10-06 | Tulare | California | 6107 | 16607 | 265 |
599452 | 599452 | 2020-10-05 | Tulare | California | 6107 | 16490 | 265 |
596209 | 596209 | 2020-10-04 | Tulare | California | 6107 | 16399 | 265 |
592967 | 592967 | 2020-10-03 | Tulare | California | 6107 | 16399 | 265 |
589727 | 589727 | 2020-10-02 | Tulare | California | 6107 | 16399 | 265 |
586486 | 586486 | 2020-10-01 | Tulare | California | 6107 | 16322 | 263 |
583246 | 583246 | 2020-09-30 | Tulare | California | 6107 | 16267 | 263 |
580007 | 580007 | 2020-09-29 | Tulare | California | 6107 | 16204 | 263 |
576766 | 576766 | 2020-09-28 | Tulare | California | 6107 | 16071 | 263 |
573523 | 573523 | 2020-09-27 | Tulare | California | 6107 | 15970 | 263 |
570281 | 570281 | 2020-09-26 | Tulare | California | 6107 | 15970 | 263 |
567039 | 567039 | 2020-09-25 | Tulare | California | 6107 | 15897 | 259 |
563799 | 563799 | 2020-09-24 | Tulare | California | 6107 | 15897 | 259 |
560560 | 560560 | 2020-09-23 | Tulare | California | 6107 | 15829 | 259 |
557324 | 557324 | 2020-09-22 | Tulare | California | 6107 | 15782 | 257 |
554087 | 554087 | 2020-09-21 | Tulare | California | 6107 | 15687 | 256 |
550848 | 550848 | 2020-09-20 | Tulare | California | 6107 | 15599 | 256 |
547609 | 547609 | 2020-09-19 | Tulare | California | 6107 | 15599 | 256 |
544371 | 544371 | 2020-09-18 | Tulare | California | 6107 | 15599 | 256 |
541135 | 541135 | 2020-09-17 | Tulare | California | 6107 | 15517 | 256 |
537898 | 537898 | 2020-09-16 | Tulare | California | 6107 | 15486 | 255 |
534662 | 534662 | 2020-09-15 | Tulare | California | 6107 | 15361 | 253 |
531427 | 531427 | 2020-09-14 | Tulare | California | 6107 | 15270 | 251 |
528190 | 528190 | 2020-09-13 | Tulare | California | 6107 | 15114 | 247 |
524954 | 524954 | 2020-09-12 | Tulare | California | 6107 | 15114 | 247 |
521718 | 521718 | 2020-09-11 | Tulare | California | 6107 | 15114 | 247 |
518481 | 518481 | 2020-09-10 | Tulare | California | 6107 | 15043 | 246 |
515246 | 515246 | 2020-09-09 | Tulare | California | 6107 | 14967 | 246 |
512013 | 512013 | 2020-09-08 | Tulare | California | 6107 | 14816 | 246 |
508780 | 508780 | 2020-09-07 | Tulare | California | 6107 | 14677 | 243 |
505548 | 505548 | 2020-09-06 | Tulare | California | 6107 | 14677 | 243 |
502314 | 502314 | 2020-09-05 | Tulare | California | 6107 | 14677 | 243 |
499080 | 499080 | 2020-09-04 | Tulare | California | 6107 | 14677 | 243 |
495847 | 495847 | 2020-09-03 | Tulare | California | 6107 | 14552 | 243 |
492613 | 492613 | 2020-09-02 | Tulare | California | 6107 | 14442 | 240 |
489380 | 489380 | 2020-09-01 | Tulare | California | 6107 | 14305 | 234 |
486147 | 486147 | 2020-08-31 | Tulare | California | 6107 | 14079 | 233 |
482912 | 482912 | 2020-08-30 | Tulare | California | 6107 | 13890 | 232 |
479678 | 479678 | 2020-08-29 | Tulare | California | 6107 | 13884 | 232 |
476445 | 476445 | 2020-08-28 | Tulare | California | 6107 | 13884 | 232 |
473212 | 473212 | 2020-08-27 | Tulare | California | 6107 | 13775 | 229 |
469980 | 469980 | 2020-08-26 | Tulare | California | 6107 | 13673 | 224 |
466751 | 466751 | 2020-08-25 | Tulare | California | 6107 | 13609 | 216 |
463522 | 463522 | 2020-08-24 | Tulare | California | 6107 | 13431 | 216 |
460293 | 460293 | 2020-08-23 | Tulare | California | 6107 | 13196 | 210 |
457066 | 457066 | 2020-08-22 | Tulare | California | 6107 | 13117 | 210 |
453838 | 453838 | 2020-08-21 | Tulare | California | 6107 | 13117 | 210 |
450610 | 450610 | 2020-08-20 | Tulare | California | 6107 | 13022 | 208 |
447382 | 447382 | 2020-08-19 | Tulare | California | 6107 | 12836 | 208 |
444155 | 444155 | 2020-08-18 | Tulare | California | 6107 | 12718 | 206 |
440929 | 440929 | 2020-08-17 | Tulare | California | 6107 | 12451 | 206 |
437703 | 437703 | 2020-08-16 | Tulare | California | 6107 | 12262 | 205 |
434477 | 434477 | 2020-08-15 | Tulare | California | 6107 | 12105 | 205 |
431252 | 431252 | 2020-08-14 | Tulare | California | 6107 | 12105 | 205 |
428024 | 428024 | 2020-08-13 | Tulare | California | 6107 | 11847 | 205 |
424800 | 424800 | 2020-08-12 | Tulare | California | 6107 | 11643 | 205 |
421579 | 421579 | 2020-08-11 | Tulare | California | 6107 | 11549 | 198 |
418358 | 418358 | 2020-08-10 | Tulare | California | 6107 | 10862 | 196 |
415137 | 415137 | 2020-08-09 | Tulare | California | 6107 | 10505 | 196 |
411917 | 411917 | 2020-08-08 | Tulare | California | 6107 | 10475 | 196 |
408698 | 408698 | 2020-08-07 | Tulare | California | 6107 | 10475 | 196 |
405478 | 405478 | 2020-08-06 | Tulare | California | 6107 | 10334 | 196 |
402260 | 402260 | 2020-08-05 | Tulare | California | 6107 | 10078 | 193 |
399044 | 399044 | 2020-08-04 | Tulare | California | 6107 | 9990 | 193 |
395828 | 395828 | 2020-08-03 | Tulare | California | 6107 | 9745 | 189 |
392612 | 392612 | 2020-08-02 | Tulare | California | 6107 | 9520 | 178 |
389395 | 389395 | 2020-08-01 | Tulare | California | 6107 | 9454 | 178 |
386178 | 386178 | 2020-07-31 | Tulare | California | 6107 | 9454 | 178 |
382960 | 382960 | 2020-07-30 | Tulare | California | 6107 | 9241 | 173 |
379743 | 379743 | 2020-07-29 | Tulare | California | 6107 | 9076 | 173 |
376526 | 376526 | 2020-07-28 | Tulare | California | 6107 | 8862 | 173 |
373312 | 373312 | 2020-07-27 | Tulare | California | 6107 | 8534 | 172 |
370100 | 370100 | 2020-07-26 | Tulare | California | 6107 | 8310 | 168 |
366890 | 366890 | 2020-07-25 | Tulare | California | 6107 | 8210 | 168 |
363683 | 363683 | 2020-07-24 | Tulare | California | 6107 | 8210 | 168 |
360476 | 360476 | 2020-07-23 | Tulare | California | 6107 | 7876 | 168 |
357271 | 357271 | 2020-07-22 | Tulare | California | 6107 | 7603 | 168 |
354068 | 354068 | 2020-07-21 | Tulare | California | 6107 | 7120 | 168 |
350866 | 350866 | 2020-07-20 | Tulare | California | 6107 | 6896 | 167 |
347665 | 347665 | 2020-07-19 | Tulare | California | 6107 | 6810 | 165 |
344465 | 344465 | 2020-07-18 | Tulare | California | 6107 | 6683 | 165 |
341266 | 341266 | 2020-07-17 | Tulare | California | 6107 | 6683 | 165 |
338070 | 338070 | 2020-07-16 | Tulare | California | 6107 | 6480 | 161 |
334875 | 334875 | 2020-07-15 | Tulare | California | 6107 | 6332 | 153 |
331682 | 331682 | 2020-07-14 | Tulare | California | 6107 | 6209 | 153 |
328496 | 328496 | 2020-07-13 | Tulare | California | 6107 | 5942 | 152 |
325310 | 325310 | 2020-07-12 | Tulare | California | 6107 | 5780 | 152 |
322129 | 322129 | 2020-07-11 | Tulare | California | 6107 | 5678 | 152 |
318950 | 318950 | 2020-07-10 | Tulare | California | 6107 | 5678 | 152 |
315777 | 315777 | 2020-07-09 | Tulare | California | 6107 | 5509 | 148 |
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);