ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Montgomery" and fips = 29139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081038 | 1081038 | 2021-03-02 | Montgomery | Missouri | 29139 | 568 | 10 |
1077792 | 1077792 | 2021-03-01 | Montgomery | Missouri | 29139 | 568 | 10 |
1074546 | 1074546 | 2021-02-28 | Montgomery | Missouri | 29139 | 568 | 10 |
1071300 | 1071300 | 2021-02-27 | Montgomery | Missouri | 29139 | 567 | 10 |
1068055 | 1068055 | 2021-02-26 | Montgomery | Missouri | 29139 | 567 | 10 |
1064810 | 1064810 | 2021-02-25 | Montgomery | Missouri | 29139 | 567 | 10 |
1061566 | 1061566 | 2021-02-24 | Montgomery | Missouri | 29139 | 567 | 10 |
1058320 | 1058320 | 2021-02-23 | Montgomery | Missouri | 29139 | 567 | 10 |
1055074 | 1055074 | 2021-02-22 | Montgomery | Missouri | 29139 | 567 | 10 |
1051827 | 1051827 | 2021-02-21 | Montgomery | Missouri | 29139 | 567 | 10 |
1048580 | 1048580 | 2021-02-20 | Montgomery | Missouri | 29139 | 567 | 10 |
1045334 | 1045334 | 2021-02-19 | Montgomery | Missouri | 29139 | 565 | 10 |
1042089 | 1042089 | 2021-02-18 | Montgomery | Missouri | 29139 | 565 | 10 |
1038844 | 1038844 | 2021-02-17 | Montgomery | Missouri | 29139 | 564 | 10 |
1035599 | 1035599 | 2021-02-16 | Montgomery | Missouri | 29139 | 563 | 10 |
1032354 | 1032354 | 2021-02-15 | Montgomery | Missouri | 29139 | 562 | 10 |
1029107 | 1029107 | 2021-02-14 | Montgomery | Missouri | 29139 | 562 | 10 |
1025861 | 1025861 | 2021-02-13 | Montgomery | Missouri | 29139 | 562 | 10 |
1022616 | 1022616 | 2021-02-12 | Montgomery | Missouri | 29139 | 560 | 10 |
1019371 | 1019371 | 2021-02-11 | Montgomery | Missouri | 29139 | 559 | 10 |
1016126 | 1016126 | 2021-02-10 | Montgomery | Missouri | 29139 | 558 | 10 |
1012881 | 1012881 | 2021-02-09 | Montgomery | Missouri | 29139 | 558 | 10 |
1009636 | 1009636 | 2021-02-08 | Montgomery | Missouri | 29139 | 556 | 10 |
1006389 | 1006389 | 2021-02-07 | Montgomery | Missouri | 29139 | 555 | 10 |
1003143 | 1003143 | 2021-02-06 | Montgomery | Missouri | 29139 | 550 | 10 |
999898 | 999898 | 2021-02-05 | Montgomery | Missouri | 29139 | 550 | 10 |
996652 | 996652 | 2021-02-04 | Montgomery | Missouri | 29139 | 550 | 10 |
993406 | 993406 | 2021-02-03 | Montgomery | Missouri | 29139 | 551 | 10 |
990160 | 990160 | 2021-02-02 | Montgomery | Missouri | 29139 | 550 | 10 |
986913 | 986913 | 2021-02-01 | Montgomery | Missouri | 29139 | 550 | 10 |
983666 | 983666 | 2021-01-31 | Montgomery | Missouri | 29139 | 550 | 10 |
980420 | 980420 | 2021-01-30 | Montgomery | Missouri | 29139 | 549 | 10 |
977174 | 977174 | 2021-01-29 | Montgomery | Missouri | 29139 | 550 | 10 |
973929 | 973929 | 2021-01-28 | Montgomery | Missouri | 29139 | 549 | 10 |
970684 | 970684 | 2021-01-27 | Montgomery | Missouri | 29139 | 549 | 10 |
967439 | 967439 | 2021-01-26 | Montgomery | Missouri | 29139 | 548 | 10 |
964195 | 964195 | 2021-01-25 | Montgomery | Missouri | 29139 | 548 | 10 |
960950 | 960950 | 2021-01-24 | Montgomery | Missouri | 29139 | 548 | 10 |
957704 | 957704 | 2021-01-23 | Montgomery | Missouri | 29139 | 548 | 10 |
954459 | 954459 | 2021-01-22 | Montgomery | Missouri | 29139 | 548 | 10 |
951214 | 951214 | 2021-01-21 | Montgomery | Missouri | 29139 | 548 | 10 |
947968 | 947968 | 2021-01-20 | Montgomery | Missouri | 29139 | 547 | 10 |
944721 | 944721 | 2021-01-19 | Montgomery | Missouri | 29139 | 545 | 9 |
941476 | 941476 | 2021-01-18 | Montgomery | Missouri | 29139 | 545 | 9 |
938231 | 938231 | 2021-01-17 | Montgomery | Missouri | 29139 | 545 | 9 |
934986 | 934986 | 2021-01-16 | Montgomery | Missouri | 29139 | 544 | 9 |
931741 | 931741 | 2021-01-15 | Montgomery | Missouri | 29139 | 543 | 9 |
928496 | 928496 | 2021-01-14 | Montgomery | Missouri | 29139 | 540 | 9 |
925250 | 925250 | 2021-01-13 | Montgomery | Missouri | 29139 | 537 | 9 |
922005 | 922005 | 2021-01-12 | Montgomery | Missouri | 29139 | 535 | 9 |
918760 | 918760 | 2021-01-11 | Montgomery | Missouri | 29139 | 536 | 9 |
915515 | 915515 | 2021-01-10 | Montgomery | Missouri | 29139 | 532 | 9 |
912270 | 912270 | 2021-01-09 | Montgomery | Missouri | 29139 | 529 | 9 |
909025 | 909025 | 2021-01-08 | Montgomery | Missouri | 29139 | 527 | 9 |
905779 | 905779 | 2021-01-07 | Montgomery | Missouri | 29139 | 524 | 9 |
902534 | 902534 | 2021-01-06 | Montgomery | Missouri | 29139 | 521 | 9 |
899289 | 899289 | 2021-01-05 | Montgomery | Missouri | 29139 | 519 | 9 |
896044 | 896044 | 2021-01-04 | Montgomery | Missouri | 29139 | 513 | 9 |
892797 | 892797 | 2021-01-03 | Montgomery | Missouri | 29139 | 513 | 9 |
889551 | 889551 | 2021-01-02 | Montgomery | Missouri | 29139 | 506 | 9 |
886305 | 886305 | 2021-01-01 | Montgomery | Missouri | 29139 | 504 | 9 |
883060 | 883060 | 2020-12-31 | Montgomery | Missouri | 29139 | 498 | 9 |
879815 | 879815 | 2020-12-30 | Montgomery | Missouri | 29139 | 491 | 9 |
876570 | 876570 | 2020-12-29 | Montgomery | Missouri | 29139 | 486 | 9 |
873325 | 873325 | 2020-12-28 | Montgomery | Missouri | 29139 | 480 | 9 |
870080 | 870080 | 2020-12-27 | Montgomery | Missouri | 29139 | 478 | 8 |
866835 | 866835 | 2020-12-26 | Montgomery | Missouri | 29139 | 475 | 8 |
863590 | 863590 | 2020-12-25 | Montgomery | Missouri | 29139 | 472 | 8 |
860345 | 860345 | 2020-12-24 | Montgomery | Missouri | 29139 | 468 | 8 |
857100 | 857100 | 2020-12-23 | Montgomery | Missouri | 29139 | 462 | 8 |
853855 | 853855 | 2020-12-22 | Montgomery | Missouri | 29139 | 457 | 8 |
850610 | 850610 | 2020-12-21 | Montgomery | Missouri | 29139 | 455 | 6 |
847365 | 847365 | 2020-12-20 | Montgomery | Missouri | 29139 | 452 | 6 |
844119 | 844119 | 2020-12-19 | Montgomery | Missouri | 29139 | 443 | 6 |
840874 | 840874 | 2020-12-18 | Montgomery | Missouri | 29139 | 436 | 6 |
837629 | 837629 | 2020-12-17 | Montgomery | Missouri | 29139 | 432 | 6 |
834383 | 834383 | 2020-12-16 | Montgomery | Missouri | 29139 | 429 | 6 |
831136 | 831136 | 2020-12-15 | Montgomery | Missouri | 29139 | 421 | 6 |
827890 | 827890 | 2020-12-14 | Montgomery | Missouri | 29139 | 416 | 6 |
824643 | 824643 | 2020-12-13 | Montgomery | Missouri | 29139 | 408 | 6 |
821397 | 821397 | 2020-12-12 | Montgomery | Missouri | 29139 | 401 | 6 |
818151 | 818151 | 2020-12-11 | Montgomery | Missouri | 29139 | 391 | 6 |
814905 | 814905 | 2020-12-10 | Montgomery | Missouri | 29139 | 391 | 6 |
811660 | 811660 | 2020-12-09 | Montgomery | Missouri | 29139 | 384 | 6 |
808415 | 808415 | 2020-12-08 | Montgomery | Missouri | 29139 | 381 | 6 |
805170 | 805170 | 2020-12-07 | Montgomery | Missouri | 29139 | 376 | 6 |
801925 | 801925 | 2020-12-06 | Montgomery | Missouri | 29139 | 369 | 6 |
798680 | 798680 | 2020-12-05 | Montgomery | Missouri | 29139 | 366 | 6 |
795435 | 795435 | 2020-12-04 | Montgomery | Missouri | 29139 | 360 | 6 |
792190 | 792190 | 2020-12-03 | Montgomery | Missouri | 29139 | 358 | 6 |
788945 | 788945 | 2020-12-02 | Montgomery | Missouri | 29139 | 354 | 6 |
785700 | 785700 | 2020-12-01 | Montgomery | Missouri | 29139 | 352 | 6 |
782456 | 782456 | 2020-11-30 | Montgomery | Missouri | 29139 | 349 | 5 |
779210 | 779210 | 2020-11-29 | Montgomery | Missouri | 29139 | 346 | 5 |
775965 | 775965 | 2020-11-28 | Montgomery | Missouri | 29139 | 343 | 5 |
772720 | 772720 | 2020-11-27 | Montgomery | Missouri | 29139 | 341 | 5 |
769475 | 769475 | 2020-11-26 | Montgomery | Missouri | 29139 | 332 | 5 |
766229 | 766229 | 2020-11-25 | Montgomery | Missouri | 29139 | 329 | 5 |
762984 | 762984 | 2020-11-24 | Montgomery | Missouri | 29139 | 309 | 5 |
759739 | 759739 | 2020-11-23 | Montgomery | Missouri | 29139 | 304 | 5 |
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);