ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 6037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599417 | 599417 | 2020-10-05 | Los Angeles | California | 6037 | 274942 | 6654 |
596174 | 596174 | 2020-10-04 | Los Angeles | California | 6037 | 274565 | 6647 |
592932 | 592932 | 2020-10-03 | Los Angeles | California | 6037 | 273638 | 6642 |
589692 | 589692 | 2020-10-02 | Los Angeles | California | 6037 | 272653 | 6626 |
586451 | 586451 | 2020-10-01 | Los Angeles | California | 6037 | 271371 | 6610 |
583211 | 583211 | 2020-09-30 | Los Angeles | California | 6037 | 270299 | 6576 |
579972 | 579972 | 2020-09-29 | Los Angeles | California | 6037 | 269284 | 6551 |
576731 | 576731 | 2020-09-28 | Los Angeles | California | 6037 | 268455 | 6515 |
573488 | 573488 | 2020-09-27 | Los Angeles | California | 6037 | 267801 | 6514 |
570246 | 570246 | 2020-09-26 | Los Angeles | California | 6037 | 266988 | 6504 |
567004 | 567004 | 2020-09-25 | Los Angeles | California | 6037 | 265775 | 6488 |
563764 | 563764 | 2020-09-24 | Los Angeles | California | 6037 | 264414 | 6455 |
560525 | 560525 | 2020-09-23 | Los Angeles | California | 6037 | 263333 | 6423 |
557289 | 557289 | 2020-09-22 | Los Angeles | California | 6037 | 262133 | 6401 |
554052 | 554052 | 2020-09-21 | Los Angeles | California | 6037 | 261446 | 6366 |
550813 | 550813 | 2020-09-20 | Los Angeles | California | 6037 | 260797 | 6353 |
547574 | 547574 | 2020-09-19 | Los Angeles | California | 6037 | 259817 | 6330 |
544336 | 544336 | 2020-09-18 | Los Angeles | California | 6037 | 258516 | 6330 |
541100 | 541100 | 2020-09-17 | Los Angeles | California | 6037 | 257271 | 6324 |
537863 | 537863 | 2020-09-16 | Los Angeles | California | 6037 | 256148 | 6303 |
534627 | 534627 | 2020-09-15 | Los Angeles | California | 6037 | 255049 | 6273 |
531392 | 531392 | 2020-09-14 | Los Angeles | California | 6037 | 254656 | 6231 |
528155 | 528155 | 2020-09-13 | Los Angeles | California | 6037 | 253985 | 6208 |
524919 | 524919 | 2020-09-12 | Los Angeles | California | 6037 | 253176 | 6197 |
521683 | 521683 | 2020-09-11 | Los Angeles | California | 6037 | 252066 | 6171 |
518446 | 518446 | 2020-09-10 | Los Angeles | California | 6037 | 251024 | 6128 |
515211 | 515211 | 2020-09-09 | Los Angeles | California | 6037 | 249859 | 6090 |
511978 | 511978 | 2020-09-08 | Los Angeles | California | 6037 | 249241 | 6036 |
508745 | 508745 | 2020-09-07 | Los Angeles | California | 6037 | 248821 | 6030 |
505513 | 505513 | 2020-09-06 | Los Angeles | California | 6037 | 248334 | 6005 |
502279 | 502279 | 2020-09-05 | Los Angeles | California | 6037 | 247542 | 6000 |
499045 | 499045 | 2020-09-04 | Los Angeles | California | 6037 | 246407 | 5977 |
495812 | 495812 | 2020-09-03 | Los Angeles | California | 6037 | 244999 | 5932 |
492578 | 492578 | 2020-09-02 | Los Angeles | California | 6037 | 243935 | 5878 |
489345 | 489345 | 2020-09-01 | Los Angeles | California | 6037 | 242521 | 5829 |
486112 | 486112 | 2020-08-31 | Los Angeles | California | 6037 | 241768 | 5784 |
482877 | 482877 | 2020-08-30 | Los Angeles | California | 6037 | 240749 | 5769 |
479643 | 479643 | 2020-08-29 | Los Angeles | California | 6037 | 239756 | 5759 |
476410 | 476410 | 2020-08-28 | Los Angeles | California | 6037 | 238458 | 5732 |
473177 | 473177 | 2020-08-27 | Los Angeles | California | 6037 | 236986 | 5701 |
469945 | 469945 | 2020-08-26 | Los Angeles | California | 6037 | 235386 | 5663 |
466716 | 466716 | 2020-08-25 | Los Angeles | California | 6037 | 233777 | 5605 |
463487 | 463487 | 2020-08-24 | Los Angeles | California | 6037 | 232893 | 5558 |
460258 | 460258 | 2020-08-23 | Los Angeles | California | 6037 | 231695 | 5545 |
457031 | 457031 | 2020-08-22 | Los Angeles | California | 6037 | 230662 | 5537 |
453803 | 453803 | 2020-08-21 | Los Angeles | California | 6037 | 229054 | 5491 |
450575 | 450575 | 2020-08-20 | Los Angeles | California | 6037 | 227346 | 5446 |
447347 | 447347 | 2020-08-19 | Los Angeles | California | 6037 | 225827 | 5392 |
444120 | 444120 | 2020-08-18 | Los Angeles | California | 6037 | 224031 | 5335 |
440894 | 440894 | 2020-08-17 | Los Angeles | California | 6037 | 223131 | 5273 |
437668 | 437668 | 2020-08-16 | Los Angeles | California | 6037 | 221950 | 5254 |
434442 | 434442 | 2020-08-15 | Los Angeles | California | 6037 | 220762 | 5245 |
431217 | 431217 | 2020-08-14 | Los Angeles | California | 6037 | 218693 | 5214 |
427989 | 427989 | 2020-08-13 | Los Angeles | California | 6037 | 216139 | 5171 |
424765 | 424765 | 2020-08-12 | Los Angeles | California | 6037 | 214197 | 5109 |
421544 | 421544 | 2020-08-11 | Los Angeles | California | 6037 | 211808 | 5057 |
418323 | 418323 | 2020-08-10 | Los Angeles | California | 6037 | 210424 | 4996 |
415102 | 415102 | 2020-08-09 | Los Angeles | California | 6037 | 208528 | 4977 |
411882 | 411882 | 2020-08-08 | Los Angeles | California | 6037 | 206761 | 4967 |
408663 | 408663 | 2020-08-07 | Los Angeles | California | 6037 | 204167 | 4918 |
405443 | 405443 | 2020-08-06 | Los Angeles | California | 6037 | 201106 | 4869 |
402225 | 402225 | 2020-08-05 | Los Angeles | California | 6037 | 197912 | 4825 |
399009 | 399009 | 2020-08-04 | Los Angeles | California | 6037 | 195614 | 4758 |
395793 | 395793 | 2020-08-03 | Los Angeles | California | 6037 | 193788 | 4701 |
392577 | 392577 | 2020-08-02 | Los Angeles | California | 6037 | 192167 | 4692 |
389360 | 389360 | 2020-08-01 | Los Angeles | California | 6037 | 190693 | 4669 |
386143 | 386143 | 2020-07-31 | Los Angeles | California | 6037 | 188481 | 4621 |
382925 | 382925 | 2020-07-30 | Los Angeles | California | 6037 | 185872 | 4552 |
379708 | 379708 | 2020-07-29 | Los Angeles | California | 6037 | 183383 | 4516 |
376492 | 376492 | 2020-07-28 | Los Angeles | California | 6037 | 178642 | 4426 |
373278 | 373278 | 2020-07-27 | Los Angeles | California | 6037 | 176028 | 4375 |
370066 | 370066 | 2020-07-26 | Los Angeles | California | 6037 | 173995 | 4360 |
366856 | 366856 | 2020-07-25 | Los Angeles | California | 6037 | 172325 | 4351 |
363649 | 363649 | 2020-07-24 | Los Angeles | California | 6037 | 168757 | 4300 |
360442 | 360442 | 2020-07-23 | Los Angeles | California | 6037 | 166848 | 4262 |
357237 | 357237 | 2020-07-22 | Los Angeles | California | 6037 | 164870 | 4213 |
354034 | 354034 | 2020-07-21 | Los Angeles | California | 6037 | 161673 | 4154 |
350832 | 350832 | 2020-07-20 | Los Angeles | California | 6037 | 159045 | 4104 |
347631 | 347631 | 2020-07-19 | Los Angeles | California | 6037 | 155887 | 4095 |
344431 | 344431 | 2020-07-18 | Los Angeles | California | 6037 | 153041 | 4084 |
341232 | 341232 | 2020-07-17 | Los Angeles | California | 6037 | 150319 | 4047 |
338036 | 338036 | 2020-07-16 | Los Angeles | California | 6037 | 147468 | 3988 |
334841 | 334841 | 2020-07-15 | Los Angeles | California | 6037 | 143009 | 3936 |
331648 | 331648 | 2020-07-14 | Los Angeles | California | 6037 | 140307 | 3894 |
328462 | 328462 | 2020-07-13 | Los Angeles | California | 6037 | 136129 | 3822 |
325276 | 325276 | 2020-07-12 | Los Angeles | California | 6037 | 133549 | 3809 |
322095 | 322095 | 2020-07-11 | Los Angeles | California | 6037 | 130242 | 3793 |
318916 | 318916 | 2020-07-10 | Los Angeles | California | 6037 | 127358 | 3738 |
315743 | 315743 | 2020-07-09 | Los Angeles | California | 6037 | 124738 | 3689 |
312568 | 312568 | 2020-07-08 | Los Angeles | California | 6037 | 123004 | 3642 |
309398 | 309398 | 2020-07-07 | Los Angeles | California | 6037 | 120539 | 3579 |
306230 | 306230 | 2020-07-06 | Los Angeles | California | 6037 | 116570 | 3534 |
303066 | 303066 | 2020-07-05 | Los Angeles | California | 6037 | 114993 | 3487 |
299902 | 299902 | 2020-07-04 | Los Angeles | California | 6037 | 113497 | 3454 |
296740 | 296740 | 2020-07-03 | Los Angeles | California | 6037 | 110310 | 3454 |
293584 | 293584 | 2020-07-02 | Los Angeles | California | 6037 | 107667 | 3454 |
290430 | 290430 | 2020-07-01 | Los Angeles | California | 6037 | 105507 | 3402 |
287279 | 287279 | 2020-06-30 | Los Angeles | California | 6037 | 103529 | 3369 |
284133 | 284133 | 2020-06-29 | Los Angeles | California | 6037 | 100772 | 3326 |
280987 | 280987 | 2020-06-28 | Los Angeles | California | 6037 | 97894 | 3305 |
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);