ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 6095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534656 | 534656 | 2020-09-15 | Solano | California | 6095 | 5992 | 52 |
531421 | 531421 | 2020-09-14 | Solano | California | 6095 | 5942 | 50 |
528184 | 528184 | 2020-09-13 | Solano | California | 6095 | 5825 | 48 |
524948 | 524948 | 2020-09-12 | Solano | California | 6095 | 5825 | 48 |
521712 | 521712 | 2020-09-11 | Solano | California | 6095 | 5825 | 48 |
518475 | 518475 | 2020-09-10 | Solano | California | 6095 | 5810 | 48 |
515240 | 515240 | 2020-09-09 | Solano | California | 6095 | 5783 | 48 |
512007 | 512007 | 2020-09-08 | Solano | California | 6095 | 5767 | 48 |
508774 | 508774 | 2020-09-07 | Solano | California | 6095 | 5676 | 48 |
505542 | 505542 | 2020-09-06 | Solano | California | 6095 | 5676 | 48 |
502308 | 502308 | 2020-09-05 | Solano | California | 6095 | 5676 | 48 |
499074 | 499074 | 2020-09-04 | Solano | California | 6095 | 5676 | 48 |
495841 | 495841 | 2020-09-03 | Solano | California | 6095 | 5636 | 47 |
492607 | 492607 | 2020-09-02 | Solano | California | 6095 | 5593 | 47 |
489374 | 489374 | 2020-09-01 | Solano | California | 6095 | 5552 | 47 |
486141 | 486141 | 2020-08-31 | Solano | California | 6095 | 5517 | 47 |
482906 | 482906 | 2020-08-30 | Solano | California | 6095 | 5393 | 46 |
479672 | 479672 | 2020-08-29 | Solano | California | 6095 | 5393 | 46 |
476439 | 476439 | 2020-08-28 | Solano | California | 6095 | 5393 | 46 |
473206 | 473206 | 2020-08-27 | Solano | California | 6095 | 5333 | 46 |
469974 | 469974 | 2020-08-26 | Solano | California | 6095 | 5285 | 46 |
466745 | 466745 | 2020-08-25 | Solano | California | 6095 | 5236 | 46 |
463516 | 463516 | 2020-08-24 | Solano | California | 6095 | 5211 | 46 |
460287 | 460287 | 2020-08-23 | Solano | California | 6095 | 5053 | 44 |
457060 | 457060 | 2020-08-22 | Solano | California | 6095 | 5053 | 44 |
453832 | 453832 | 2020-08-21 | Solano | California | 6095 | 5053 | 44 |
450604 | 450604 | 2020-08-20 | Solano | California | 6095 | 5011 | 44 |
447376 | 447376 | 2020-08-19 | Solano | California | 6095 | 4948 | 44 |
444149 | 444149 | 2020-08-18 | Solano | California | 6095 | 4876 | 43 |
440923 | 440923 | 2020-08-17 | Solano | California | 6095 | 4772 | 41 |
437697 | 437697 | 2020-08-16 | Solano | California | 6095 | 4601 | 41 |
434471 | 434471 | 2020-08-15 | Solano | California | 6095 | 4601 | 41 |
431246 | 431246 | 2020-08-14 | Solano | California | 6095 | 4601 | 41 |
428018 | 428018 | 2020-08-13 | Solano | California | 6095 | 4539 | 41 |
424794 | 424794 | 2020-08-12 | Solano | California | 6095 | 4419 | 41 |
421573 | 421573 | 2020-08-11 | Solano | California | 6095 | 4343 | 41 |
418352 | 418352 | 2020-08-10 | Solano | California | 6095 | 4279 | 41 |
415131 | 415131 | 2020-08-09 | Solano | California | 6095 | 4034 | 40 |
411911 | 411911 | 2020-08-08 | Solano | California | 6095 | 4034 | 40 |
408692 | 408692 | 2020-08-07 | Solano | California | 6095 | 4034 | 40 |
405472 | 405472 | 2020-08-06 | Solano | California | 6095 | 3964 | 39 |
402254 | 402254 | 2020-08-05 | Solano | California | 6095 | 3889 | 38 |
399038 | 399038 | 2020-08-04 | Solano | California | 6095 | 3811 | 38 |
395822 | 395822 | 2020-08-03 | Solano | California | 6095 | 3726 | 37 |
392606 | 392606 | 2020-08-02 | Solano | California | 6095 | 3616 | 37 |
389389 | 389389 | 2020-08-01 | Solano | California | 6095 | 3616 | 37 |
386172 | 386172 | 2020-07-31 | Solano | California | 6095 | 3616 | 37 |
382954 | 382954 | 2020-07-30 | Solano | California | 6095 | 3525 | 37 |
379737 | 379737 | 2020-07-29 | Solano | California | 6095 | 3467 | 37 |
376520 | 376520 | 2020-07-28 | Solano | California | 6095 | 3393 | 36 |
373306 | 373306 | 2020-07-27 | Solano | California | 6095 | 3288 | 36 |
370094 | 370094 | 2020-07-26 | Solano | California | 6095 | 3134 | 35 |
366884 | 366884 | 2020-07-25 | Solano | California | 6095 | 3134 | 35 |
363677 | 363677 | 2020-07-24 | Solano | California | 6095 | 3134 | 35 |
360470 | 360470 | 2020-07-23 | Solano | California | 6095 | 3075 | 35 |
357265 | 357265 | 2020-07-22 | Solano | California | 6095 | 2987 | 35 |
354062 | 354062 | 2020-07-21 | Solano | California | 6095 | 2862 | 35 |
350860 | 350860 | 2020-07-20 | Solano | California | 6095 | 2764 | 34 |
347659 | 347659 | 2020-07-19 | Solano | California | 6095 | 2559 | 31 |
344459 | 344459 | 2020-07-18 | Solano | California | 6095 | 2559 | 31 |
341260 | 341260 | 2020-07-17 | Solano | California | 6095 | 2559 | 31 |
338064 | 338064 | 2020-07-16 | Solano | California | 6095 | 2488 | 31 |
334869 | 334869 | 2020-07-15 | Solano | California | 6095 | 2412 | 31 |
331676 | 331676 | 2020-07-14 | Solano | California | 6095 | 2318 | 31 |
328490 | 328490 | 2020-07-13 | Solano | California | 6095 | 2224 | 31 |
325304 | 325304 | 2020-07-12 | Solano | California | 6095 | 2080 | 28 |
322123 | 322123 | 2020-07-11 | Solano | California | 6095 | 2080 | 28 |
318944 | 318944 | 2020-07-10 | Solano | California | 6095 | 2080 | 28 |
315771 | 315771 | 2020-07-09 | Solano | California | 6095 | 1990 | 27 |
312596 | 312596 | 2020-07-08 | Solano | California | 6095 | 1927 | 27 |
309426 | 309426 | 2020-07-07 | Solano | California | 6095 | 1831 | 27 |
306258 | 306258 | 2020-07-06 | Solano | California | 6095 | 1745 | 25 |
303094 | 303094 | 2020-07-05 | Solano | California | 6095 | 1553 | 25 |
299930 | 299930 | 2020-07-04 | Solano | California | 6095 | 1501 | 25 |
296768 | 296768 | 2020-07-03 | Solano | California | 6095 | 1481 | 25 |
293612 | 293612 | 2020-07-02 | Solano | California | 6095 | 1481 | 25 |
290458 | 290458 | 2020-07-01 | Solano | California | 6095 | 1407 | 25 |
287307 | 287307 | 2020-06-30 | Solano | California | 6095 | 1293 | 24 |
284161 | 284161 | 2020-06-29 | Solano | California | 6095 | 1131 | 24 |
281015 | 281015 | 2020-06-28 | Solano | California | 6095 | 1123 | 23 |
277868 | 277868 | 2020-06-27 | Solano | California | 6095 | 1073 | 23 |
274720 | 274720 | 2020-06-26 | Solano | California | 6095 | 1039 | 23 |
271580 | 271580 | 2020-06-25 | Solano | California | 6095 | 984 | 23 |
268445 | 268445 | 2020-06-24 | Solano | California | 6095 | 946 | 23 |
265315 | 265315 | 2020-06-23 | Solano | California | 6095 | 865 | 23 |
262187 | 262187 | 2020-06-22 | Solano | California | 6095 | 865 | 23 |
259060 | 259060 | 2020-06-21 | Solano | California | 6095 | 865 | 23 |
255933 | 255933 | 2020-06-20 | Solano | California | 6095 | 865 | 23 |
252814 | 252814 | 2020-06-19 | Solano | California | 6095 | 865 | 23 |
249699 | 249699 | 2020-06-18 | Solano | California | 6095 | 816 | 23 |
246587 | 246587 | 2020-06-17 | Solano | California | 6095 | 797 | 23 |
243474 | 243474 | 2020-06-16 | Solano | California | 6095 | 692 | 23 |
240363 | 240363 | 2020-06-15 | Solano | California | 6095 | 690 | 23 |
237255 | 237255 | 2020-06-14 | Solano | California | 6095 | 662 | 23 |
234148 | 234148 | 2020-06-13 | Solano | California | 6095 | 662 | 23 |
231042 | 231042 | 2020-06-12 | Solano | California | 6095 | 662 | 23 |
227939 | 227939 | 2020-06-11 | Solano | California | 6095 | 648 | 23 |
224837 | 224837 | 2020-06-10 | Solano | California | 6095 | 622 | 23 |
221742 | 221742 | 2020-06-09 | Solano | California | 6095 | 615 | 23 |
218647 | 218647 | 2020-06-08 | Solano | California | 6095 | 595 | 23 |
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);