ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Stanislaus" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635120 | 635120 | 2020-10-16 | Stanislaus | California | 6099 | 17840 | 391 |
631874 | 631874 | 2020-10-15 | Stanislaus | California | 6099 | 17160 | 389 |
628630 | 628630 | 2020-10-14 | Stanislaus | California | 6099 | 17130 | 388 |
625387 | 625387 | 2020-10-13 | Stanislaus | California | 6099 | 17087 | 387 |
622144 | 622144 | 2020-10-12 | Stanislaus | California | 6099 | 17076 | 386 |
618901 | 618901 | 2020-10-11 | Stanislaus | California | 6099 | 17038 | 385 |
615659 | 615659 | 2020-10-10 | Stanislaus | California | 6099 | 17002 | 384 |
612418 | 612418 | 2020-10-09 | Stanislaus | California | 6099 | 16950 | 383 |
609176 | 609176 | 2020-10-08 | Stanislaus | California | 6099 | 16886 | 381 |
605933 | 605933 | 2020-10-07 | Stanislaus | California | 6099 | 16804 | 379 |
602691 | 602691 | 2020-10-06 | Stanislaus | California | 6099 | 16767 | 377 |
599448 | 599448 | 2020-10-05 | Stanislaus | California | 6099 | 16759 | 374 |
596205 | 596205 | 2020-10-04 | Stanislaus | California | 6099 | 16737 | 372 |
592963 | 592963 | 2020-10-03 | Stanislaus | California | 6099 | 16703 | 370 |
589723 | 589723 | 2020-10-02 | Stanislaus | California | 6099 | 16628 | 368 |
586482 | 586482 | 2020-10-01 | Stanislaus | California | 6099 | 16573 | 365 |
583242 | 583242 | 2020-09-30 | Stanislaus | California | 6099 | 16512 | 362 |
580003 | 580003 | 2020-09-29 | Stanislaus | California | 6099 | 16496 | 359 |
576762 | 576762 | 2020-09-28 | Stanislaus | California | 6099 | 16471 | 356 |
573519 | 573519 | 2020-09-27 | Stanislaus | California | 6099 | 16452 | 354 |
570277 | 570277 | 2020-09-26 | Stanislaus | California | 6099 | 16442 | 351 |
567035 | 567035 | 2020-09-25 | Stanislaus | California | 6099 | 16452 | 348 |
563795 | 563795 | 2020-09-24 | Stanislaus | California | 6099 | 16436 | 345 |
560556 | 560556 | 2020-09-23 | Stanislaus | California | 6099 | 16425 | 342 |
557320 | 557320 | 2020-09-22 | Stanislaus | California | 6099 | 16398 | 339 |
554083 | 554083 | 2020-09-21 | Stanislaus | California | 6099 | 16351 | 337 |
550844 | 550844 | 2020-09-20 | Stanislaus | California | 6099 | 16319 | 335 |
547605 | 547605 | 2020-09-19 | Stanislaus | California | 6099 | 16289 | 332 |
544367 | 544367 | 2020-09-18 | Stanislaus | California | 6099 | 16229 | 329 |
541131 | 541131 | 2020-09-17 | Stanislaus | California | 6099 | 16150 | 325 |
537894 | 537894 | 2020-09-16 | Stanislaus | California | 6099 | 16052 | 317 |
534658 | 534658 | 2020-09-15 | Stanislaus | California | 6099 | 16052 | 317 |
531423 | 531423 | 2020-09-14 | Stanislaus | California | 6099 | 15976 | 310 |
528186 | 528186 | 2020-09-13 | Stanislaus | California | 6099 | 15976 | 310 |
524950 | 524950 | 2020-09-12 | Stanislaus | California | 6099 | 15926 | 310 |
521714 | 521714 | 2020-09-11 | Stanislaus | California | 6099 | 15838 | 310 |
518477 | 518477 | 2020-09-10 | Stanislaus | California | 6099 | 15749 | 303 |
515242 | 515242 | 2020-09-09 | Stanislaus | California | 6099 | 15685 | 299 |
512009 | 512009 | 2020-09-08 | Stanislaus | California | 6099 | 15635 | 295 |
508776 | 508776 | 2020-09-07 | Stanislaus | California | 6099 | 15441 | 290 |
505544 | 505544 | 2020-09-06 | Stanislaus | California | 6099 | 15382 | 289 |
502310 | 502310 | 2020-09-05 | Stanislaus | California | 6099 | 15277 | 282 |
499076 | 499076 | 2020-09-04 | Stanislaus | California | 6099 | 15162 | 282 |
495843 | 495843 | 2020-09-03 | Stanislaus | California | 6099 | 15021 | 273 |
492609 | 492609 | 2020-09-02 | Stanislaus | California | 6099 | 14902 | 267 |
489376 | 489376 | 2020-09-01 | Stanislaus | California | 6099 | 14786 | 262 |
486143 | 486143 | 2020-08-31 | Stanislaus | California | 6099 | 14710 | 258 |
482908 | 482908 | 2020-08-30 | Stanislaus | California | 6099 | 14544 | 255 |
479674 | 479674 | 2020-08-29 | Stanislaus | California | 6099 | 14482 | 255 |
476441 | 476441 | 2020-08-28 | Stanislaus | California | 6099 | 14257 | 253 |
473208 | 473208 | 2020-08-27 | Stanislaus | California | 6099 | 14101 | 245 |
469976 | 469976 | 2020-08-26 | Stanislaus | California | 6099 | 13886 | 240 |
466747 | 466747 | 2020-08-25 | Stanislaus | California | 6099 | 13521 | 237 |
463518 | 463518 | 2020-08-24 | Stanislaus | California | 6099 | 13483 | 232 |
460289 | 460289 | 2020-08-23 | Stanislaus | California | 6099 | 13380 | 229 |
457062 | 457062 | 2020-08-22 | Stanislaus | California | 6099 | 13282 | 228 |
453834 | 453834 | 2020-08-21 | Stanislaus | California | 6099 | 13120 | 226 |
450606 | 450606 | 2020-08-20 | Stanislaus | California | 6099 | 13084 | 223 |
447378 | 447378 | 2020-08-19 | Stanislaus | California | 6099 | 12935 | 212 |
444151 | 444151 | 2020-08-18 | Stanislaus | California | 6099 | 12745 | 203 |
440925 | 440925 | 2020-08-17 | Stanislaus | California | 6099 | 12668 | 198 |
437699 | 437699 | 2020-08-16 | Stanislaus | California | 6099 | 12541 | 198 |
434473 | 434473 | 2020-08-15 | Stanislaus | California | 6099 | 12379 | 198 |
431248 | 431248 | 2020-08-14 | Stanislaus | California | 6099 | 11953 | 195 |
428020 | 428020 | 2020-08-13 | Stanislaus | California | 6099 | 11682 | 187 |
424796 | 424796 | 2020-08-12 | Stanislaus | California | 6099 | 11592 | 182 |
421575 | 421575 | 2020-08-11 | Stanislaus | California | 6099 | 10855 | 177 |
418354 | 418354 | 2020-08-10 | Stanislaus | California | 6099 | 10264 | 169 |
415133 | 415133 | 2020-08-09 | Stanislaus | California | 6099 | 9963 | 163 |
411913 | 411913 | 2020-08-08 | Stanislaus | California | 6099 | 9665 | 162 |
408694 | 408694 | 2020-08-07 | Stanislaus | California | 6099 | 9566 | 161 |
405474 | 405474 | 2020-08-06 | Stanislaus | California | 6099 | 9408 | 151 |
402256 | 402256 | 2020-08-05 | Stanislaus | California | 6099 | 9359 | 145 |
399040 | 399040 | 2020-08-04 | Stanislaus | California | 6099 | 9308 | 135 |
395824 | 395824 | 2020-08-03 | Stanislaus | California | 6099 | 9277 | 126 |
392608 | 392608 | 2020-08-02 | Stanislaus | California | 6099 | 9221 | 112 |
389391 | 389391 | 2020-08-01 | Stanislaus | California | 6099 | 9061 | 110 |
386174 | 386174 | 2020-07-31 | Stanislaus | California | 6099 | 8890 | 104 |
382956 | 382956 | 2020-07-30 | Stanislaus | California | 6099 | 8745 | 104 |
379739 | 379739 | 2020-07-29 | Stanislaus | California | 6099 | 8492 | 103 |
376522 | 376522 | 2020-07-28 | Stanislaus | California | 6099 | 8288 | 98 |
373308 | 373308 | 2020-07-27 | Stanislaus | California | 6099 | 8228 | 95 |
370096 | 370096 | 2020-07-26 | Stanislaus | California | 6099 | 7994 | 90 |
366886 | 366886 | 2020-07-25 | Stanislaus | California | 6099 | 7861 | 87 |
363679 | 363679 | 2020-07-24 | Stanislaus | California | 6099 | 7603 | 86 |
360472 | 360472 | 2020-07-23 | Stanislaus | California | 6099 | 7401 | 79 |
357267 | 357267 | 2020-07-22 | Stanislaus | California | 6099 | 6984 | 77 |
354064 | 354064 | 2020-07-21 | Stanislaus | California | 6099 | 6835 | 73 |
350862 | 350862 | 2020-07-20 | Stanislaus | California | 6099 | 6508 | 71 |
347661 | 347661 | 2020-07-19 | Stanislaus | California | 6099 | 6344 | 63 |
344461 | 344461 | 2020-07-18 | Stanislaus | California | 6099 | 6220 | 63 |
341262 | 341262 | 2020-07-17 | Stanislaus | California | 6099 | 6077 | 63 |
338066 | 338066 | 2020-07-16 | Stanislaus | California | 6099 | 5777 | 61 |
334871 | 334871 | 2020-07-15 | Stanislaus | California | 6099 | 5631 | 61 |
331678 | 331678 | 2020-07-14 | Stanislaus | California | 6099 | 5356 | 57 |
328492 | 328492 | 2020-07-13 | Stanislaus | California | 6099 | 5178 | 51 |
325306 | 325306 | 2020-07-12 | Stanislaus | California | 6099 | 4973 | 51 |
322125 | 322125 | 2020-07-11 | Stanislaus | California | 6099 | 4781 | 51 |
318946 | 318946 | 2020-07-10 | Stanislaus | California | 6099 | 4633 | 51 |
315773 | 315773 | 2020-07-09 | Stanislaus | California | 6099 | 4344 | 50 |
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);