ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Baldwin" and state = "Alabama" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
261961 | 261961 | 2020-06-22 | Baldwin | Alabama | 1003 | 437 | 9 |
265090 | 265090 | 2020-06-23 | Baldwin | Alabama | 1003 | 450 | 9 |
268219 | 268219 | 2020-06-24 | Baldwin | Alabama | 1003 | 464 | 9 |
271353 | 271353 | 2020-06-25 | Baldwin | Alabama | 1003 | 477 | 9 |
274493 | 274493 | 2020-06-26 | Baldwin | Alabama | 1003 | 515 | 9 |
277641 | 277641 | 2020-06-27 | Baldwin | Alabama | 1003 | 555 | 10 |
280789 | 280789 | 2020-06-28 | Baldwin | Alabama | 1003 | 575 | 10 |
283935 | 283935 | 2020-06-29 | Baldwin | Alabama | 1003 | 643 | 10 |
287081 | 287081 | 2020-06-30 | Baldwin | Alabama | 1003 | 680 | 10 |
290231 | 290231 | 2020-07-01 | Baldwin | Alabama | 1003 | 703 | 10 |
293384 | 293384 | 2020-07-02 | Baldwin | Alabama | 1003 | 751 | 10 |
296539 | 296539 | 2020-07-03 | Baldwin | Alabama | 1003 | 845 | 10 |
299701 | 299701 | 2020-07-04 | Baldwin | Alabama | 1003 | 863 | 10 |
302865 | 302865 | 2020-07-05 | Baldwin | Alabama | 1003 | 881 | 10 |
306029 | 306029 | 2020-07-06 | Baldwin | Alabama | 1003 | 911 | 10 |
309198 | 309198 | 2020-07-07 | Baldwin | Alabama | 1003 | 997 | 10 |
312367 | 312367 | 2020-07-08 | Baldwin | Alabama | 1003 | 1056 | 10 |
315542 | 315542 | 2020-07-09 | Baldwin | Alabama | 1003 | 1131 | 11 |
318715 | 318715 | 2020-07-10 | Baldwin | Alabama | 1003 | 1187 | 12 |
321894 | 321894 | 2020-07-11 | Baldwin | Alabama | 1003 | 1224 | 12 |
325075 | 325075 | 2020-07-12 | Baldwin | Alabama | 1003 | 1294 | 12 |
328261 | 328261 | 2020-07-13 | Baldwin | Alabama | 1003 | 1359 | 12 |
331447 | 331447 | 2020-07-14 | Baldwin | Alabama | 1003 | 1414 | 12 |
334640 | 334640 | 2020-07-15 | Baldwin | Alabama | 1003 | 1518 | 13 |
337835 | 337835 | 2020-07-16 | Baldwin | Alabama | 1003 | 1599 | 14 |
341031 | 341031 | 2020-07-17 | Baldwin | Alabama | 1003 | 1689 | 14 |
344230 | 344230 | 2020-07-18 | Baldwin | Alabama | 1003 | 1819 | 15 |
347430 | 347430 | 2020-07-19 | Baldwin | Alabama | 1003 | 1937 | 15 |
350631 | 350631 | 2020-07-20 | Baldwin | Alabama | 1003 | 2013 | 15 |
353833 | 353833 | 2020-07-21 | Baldwin | Alabama | 1003 | 2102 | 16 |
357036 | 357036 | 2020-07-22 | Baldwin | Alabama | 1003 | 2196 | 16 |
360241 | 360241 | 2020-07-23 | Baldwin | Alabama | 1003 | 2461 | 17 |
363447 | 363447 | 2020-07-24 | Baldwin | Alabama | 1003 | 2513 | 18 |
366654 | 366654 | 2020-07-25 | Baldwin | Alabama | 1003 | 2662 | 18 |
369864 | 369864 | 2020-07-26 | Baldwin | Alabama | 1003 | 2708 | 18 |
373076 | 373076 | 2020-07-27 | Baldwin | Alabama | 1003 | 2770 | 18 |
376290 | 376290 | 2020-07-28 | Baldwin | Alabama | 1003 | 2835 | 18 |
379506 | 379506 | 2020-07-29 | Baldwin | Alabama | 1003 | 2908 | 21 |
382723 | 382723 | 2020-07-30 | Baldwin | Alabama | 1003 | 3028 | 21 |
385941 | 385941 | 2020-07-31 | Baldwin | Alabama | 1003 | 3101 | 22 |
389158 | 389158 | 2020-08-01 | Baldwin | Alabama | 1003 | 3142 | 22 |
392375 | 392375 | 2020-08-02 | Baldwin | Alabama | 1003 | 3223 | 23 |
395591 | 395591 | 2020-08-03 | Baldwin | Alabama | 1003 | 3265 | 24 |
398807 | 398807 | 2020-08-04 | Baldwin | Alabama | 1003 | 3320 | 24 |
402023 | 402023 | 2020-08-05 | Baldwin | Alabama | 1003 | 3380 | 24 |
405241 | 405241 | 2020-08-06 | Baldwin | Alabama | 1003 | 3438 | 25 |
408461 | 408461 | 2020-08-07 | Baldwin | Alabama | 1003 | 3504 | 25 |
411680 | 411680 | 2020-08-08 | Baldwin | Alabama | 1003 | 3564 | 26 |
414900 | 414900 | 2020-08-09 | Baldwin | Alabama | 1003 | 3606 | 27 |
418121 | 418121 | 2020-08-10 | Baldwin | Alabama | 1003 | 3714 | 28 |
421342 | 421342 | 2020-08-11 | Baldwin | Alabama | 1003 | 3736 | 32 |
424563 | 424563 | 2020-08-12 | Baldwin | Alabama | 1003 | 3776 | 32 |
427787 | 427787 | 2020-08-13 | Baldwin | Alabama | 1003 | 3813 | 32 |
431015 | 431015 | 2020-08-14 | Baldwin | Alabama | 1003 | 3860 | 32 |
434240 | 434240 | 2020-08-15 | Baldwin | Alabama | 1003 | 3909 | 32 |
437466 | 437466 | 2020-08-16 | Baldwin | Alabama | 1003 | 3948 | 32 |
440692 | 440692 | 2020-08-17 | Baldwin | Alabama | 1003 | 3960 | 32 |
443918 | 443918 | 2020-08-18 | Baldwin | Alabama | 1003 | 3977 | 33 |
447145 | 447145 | 2020-08-19 | Baldwin | Alabama | 1003 | 4002 | 33 |
450373 | 450373 | 2020-08-20 | Baldwin | Alabama | 1003 | 4035 | 34 |
453601 | 453601 | 2020-08-21 | Baldwin | Alabama | 1003 | 4075 | 35 |
456829 | 456829 | 2020-08-22 | Baldwin | Alabama | 1003 | 4115 | 35 |
460056 | 460056 | 2020-08-23 | Baldwin | Alabama | 1003 | 4147 | 35 |
463285 | 463285 | 2020-08-24 | Baldwin | Alabama | 1003 | 4167 | 35 |
466514 | 466514 | 2020-08-25 | Baldwin | Alabama | 1003 | 4190 | 35 |
469743 | 469743 | 2020-08-26 | Baldwin | Alabama | 1003 | 4265 | 36 |
472975 | 472975 | 2020-08-27 | Baldwin | Alabama | 1003 | 4311 | 37 |
476208 | 476208 | 2020-08-28 | Baldwin | Alabama | 1003 | 4347 | 39 |
479441 | 479441 | 2020-08-29 | Baldwin | Alabama | 1003 | 4424 | 40 |
482675 | 482675 | 2020-08-30 | Baldwin | Alabama | 1003 | 4525 | 40 |
485910 | 485910 | 2020-08-31 | Baldwin | Alabama | 1003 | 4545 | 42 |
489143 | 489143 | 2020-09-01 | Baldwin | Alabama | 1003 | 4568 | 42 |
492376 | 492376 | 2020-09-02 | Baldwin | Alabama | 1003 | 4583 | 42 |
495610 | 495610 | 2020-09-03 | Baldwin | Alabama | 1003 | 4628 | 44 |
498843 | 498843 | 2020-09-04 | Baldwin | Alabama | 1003 | 4654 | 46 |
502077 | 502077 | 2020-09-05 | Baldwin | Alabama | 1003 | 4686 | 46 |
505311 | 505311 | 2020-09-06 | Baldwin | Alabama | 1003 | 4713 | 46 |
508543 | 508543 | 2020-09-07 | Baldwin | Alabama | 1003 | 4730 | 46 |
511776 | 511776 | 2020-09-08 | Baldwin | Alabama | 1003 | 4757 | 46 |
515009 | 515009 | 2020-09-09 | Baldwin | Alabama | 1003 | 4787 | 46 |
518244 | 518244 | 2020-09-10 | Baldwin | Alabama | 1003 | 4833 | 46 |
521481 | 521481 | 2020-09-11 | Baldwin | Alabama | 1003 | 4886 | 47 |
524717 | 524717 | 2020-09-12 | Baldwin | Alabama | 1003 | 4922 | 47 |
527953 | 527953 | 2020-09-13 | Baldwin | Alabama | 1003 | 4959 | 47 |
531190 | 531190 | 2020-09-14 | Baldwin | Alabama | 1003 | 4978 | 47 |
534425 | 534425 | 2020-09-15 | Baldwin | Alabama | 1003 | 4992 | 47 |
537661 | 537661 | 2020-09-16 | Baldwin | Alabama | 1003 | 5003 | 47 |
540898 | 540898 | 2020-09-17 | Baldwin | Alabama | 1003 | 5021 | 48 |
544134 | 544134 | 2020-09-18 | Baldwin | Alabama | 1003 | 5033 | 48 |
547371 | 547371 | 2020-09-19 | Baldwin | Alabama | 1003 | 5047 | 49 |
550610 | 550610 | 2020-09-20 | Baldwin | Alabama | 1003 | 5061 | 49 |
553849 | 553849 | 2020-09-21 | Baldwin | Alabama | 1003 | 5087 | 49 |
557086 | 557086 | 2020-09-22 | Baldwin | Alabama | 1003 | 5124 | 49 |
560322 | 560322 | 2020-09-23 | Baldwin | Alabama | 1003 | 5141 | 49 |
563561 | 563561 | 2020-09-24 | Baldwin | Alabama | 1003 | 5165 | 50 |
566802 | 566802 | 2020-09-25 | Baldwin | Alabama | 1003 | 5456 | 50 |
570043 | 570043 | 2020-09-26 | Baldwin | Alabama | 1003 | 5477 | 50 |
573285 | 573285 | 2020-09-27 | Baldwin | Alabama | 1003 | 5526 | 50 |
576529 | 576529 | 2020-09-28 | Baldwin | Alabama | 1003 | 5588 | 50 |
579770 | 579770 | 2020-09-29 | Baldwin | Alabama | 1003 | 5606 | 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);