ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Clark" and fips = 29045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055025 | 1055025 | 2021-02-22 | Clark | Missouri | 29045 | 470 | 6 |
1051778 | 1051778 | 2021-02-21 | Clark | Missouri | 29045 | 470 | 6 |
1048531 | 1048531 | 2021-02-20 | Clark | Missouri | 29045 | 469 | 6 |
1045285 | 1045285 | 2021-02-19 | Clark | Missouri | 29045 | 469 | 6 |
1042040 | 1042040 | 2021-02-18 | Clark | Missouri | 29045 | 467 | 6 |
1038795 | 1038795 | 2021-02-17 | Clark | Missouri | 29045 | 463 | 6 |
1035550 | 1035550 | 2021-02-16 | Clark | Missouri | 29045 | 463 | 6 |
1032305 | 1032305 | 2021-02-15 | Clark | Missouri | 29045 | 463 | 6 |
1029058 | 1029058 | 2021-02-14 | Clark | Missouri | 29045 | 461 | 6 |
1025812 | 1025812 | 2021-02-13 | Clark | Missouri | 29045 | 459 | 6 |
1022567 | 1022567 | 2021-02-12 | Clark | Missouri | 29045 | 458 | 6 |
1019322 | 1019322 | 2021-02-11 | Clark | Missouri | 29045 | 458 | 6 |
1016077 | 1016077 | 2021-02-10 | Clark | Missouri | 29045 | 458 | 6 |
1012832 | 1012832 | 2021-02-09 | Clark | Missouri | 29045 | 454 | 6 |
1009587 | 1009587 | 2021-02-08 | Clark | Missouri | 29045 | 454 | 6 |
1006340 | 1006340 | 2021-02-07 | Clark | Missouri | 29045 | 454 | 6 |
1003094 | 1003094 | 2021-02-06 | Clark | Missouri | 29045 | 453 | 6 |
999849 | 999849 | 2021-02-05 | Clark | Missouri | 29045 | 453 | 6 |
996603 | 996603 | 2021-02-04 | Clark | Missouri | 29045 | 451 | 6 |
993357 | 993357 | 2021-02-03 | Clark | Missouri | 29045 | 448 | 6 |
990111 | 990111 | 2021-02-02 | Clark | Missouri | 29045 | 443 | 6 |
986864 | 986864 | 2021-02-01 | Clark | Missouri | 29045 | 443 | 6 |
983617 | 983617 | 2021-01-31 | Clark | Missouri | 29045 | 442 | 6 |
980371 | 980371 | 2021-01-30 | Clark | Missouri | 29045 | 438 | 6 |
977125 | 977125 | 2021-01-29 | Clark | Missouri | 29045 | 438 | 6 |
973880 | 973880 | 2021-01-28 | Clark | Missouri | 29045 | 437 | 6 |
970635 | 970635 | 2021-01-27 | Clark | Missouri | 29045 | 438 | 6 |
967390 | 967390 | 2021-01-26 | Clark | Missouri | 29045 | 433 | 6 |
964146 | 964146 | 2021-01-25 | Clark | Missouri | 29045 | 432 | 6 |
960901 | 960901 | 2021-01-24 | Clark | Missouri | 29045 | 432 | 5 |
957655 | 957655 | 2021-01-23 | Clark | Missouri | 29045 | 428 | 5 |
954410 | 954410 | 2021-01-22 | Clark | Missouri | 29045 | 426 | 5 |
951165 | 951165 | 2021-01-21 | Clark | Missouri | 29045 | 426 | 5 |
947919 | 947919 | 2021-01-20 | Clark | Missouri | 29045 | 425 | 5 |
944672 | 944672 | 2021-01-19 | Clark | Missouri | 29045 | 420 | 5 |
941427 | 941427 | 2021-01-18 | Clark | Missouri | 29045 | 418 | 5 |
938182 | 938182 | 2021-01-17 | Clark | Missouri | 29045 | 418 | 5 |
934937 | 934937 | 2021-01-16 | Clark | Missouri | 29045 | 410 | 5 |
931692 | 931692 | 2021-01-15 | Clark | Missouri | 29045 | 403 | 5 |
928447 | 928447 | 2021-01-14 | Clark | Missouri | 29045 | 400 | 5 |
925201 | 925201 | 2021-01-13 | Clark | Missouri | 29045 | 391 | 5 |
921956 | 921956 | 2021-01-12 | Clark | Missouri | 29045 | 391 | 5 |
918711 | 918711 | 2021-01-11 | Clark | Missouri | 29045 | 389 | 5 |
915466 | 915466 | 2021-01-10 | Clark | Missouri | 29045 | 389 | 5 |
912221 | 912221 | 2021-01-09 | Clark | Missouri | 29045 | 386 | 5 |
908976 | 908976 | 2021-01-08 | Clark | Missouri | 29045 | 384 | 5 |
905730 | 905730 | 2021-01-07 | Clark | Missouri | 29045 | 383 | 5 |
902485 | 902485 | 2021-01-06 | Clark | Missouri | 29045 | 380 | 5 |
899240 | 899240 | 2021-01-05 | Clark | Missouri | 29045 | 378 | 5 |
895995 | 895995 | 2021-01-04 | Clark | Missouri | 29045 | 377 | 5 |
892748 | 892748 | 2021-01-03 | Clark | Missouri | 29045 | 377 | 5 |
889502 | 889502 | 2021-01-02 | Clark | Missouri | 29045 | 377 | 5 |
886256 | 886256 | 2021-01-01 | Clark | Missouri | 29045 | 376 | 5 |
883011 | 883011 | 2020-12-31 | Clark | Missouri | 29045 | 371 | 4 |
879766 | 879766 | 2020-12-30 | Clark | Missouri | 29045 | 369 | 4 |
876521 | 876521 | 2020-12-29 | Clark | Missouri | 29045 | 366 | 4 |
873276 | 873276 | 2020-12-28 | Clark | Missouri | 29045 | 365 | 4 |
870031 | 870031 | 2020-12-27 | Clark | Missouri | 29045 | 365 | 4 |
866786 | 866786 | 2020-12-26 | Clark | Missouri | 29045 | 364 | 4 |
863541 | 863541 | 2020-12-25 | Clark | Missouri | 29045 | 364 | 4 |
860296 | 860296 | 2020-12-24 | Clark | Missouri | 29045 | 360 | 4 |
857051 | 857051 | 2020-12-23 | Clark | Missouri | 29045 | 348 | 4 |
853806 | 853806 | 2020-12-22 | Clark | Missouri | 29045 | 344 | 4 |
850561 | 850561 | 2020-12-21 | Clark | Missouri | 29045 | 344 | 4 |
847316 | 847316 | 2020-12-20 | Clark | Missouri | 29045 | 344 | 4 |
844070 | 844070 | 2020-12-19 | Clark | Missouri | 29045 | 344 | 4 |
840825 | 840825 | 2020-12-18 | Clark | Missouri | 29045 | 342 | 4 |
837580 | 837580 | 2020-12-17 | Clark | Missouri | 29045 | 341 | 4 |
834334 | 834334 | 2020-12-16 | Clark | Missouri | 29045 | 337 | 4 |
831087 | 831087 | 2020-12-15 | Clark | Missouri | 29045 | 337 | 4 |
827841 | 827841 | 2020-12-14 | Clark | Missouri | 29045 | 337 | 4 |
824594 | 824594 | 2020-12-13 | Clark | Missouri | 29045 | 336 | 4 |
821348 | 821348 | 2020-12-12 | Clark | Missouri | 29045 | 336 | 4 |
818102 | 818102 | 2020-12-11 | Clark | Missouri | 29045 | 335 | 4 |
814856 | 814856 | 2020-12-10 | Clark | Missouri | 29045 | 335 | 4 |
811611 | 811611 | 2020-12-09 | Clark | Missouri | 29045 | 328 | 4 |
808366 | 808366 | 2020-12-08 | Clark | Missouri | 29045 | 327 | 4 |
805121 | 805121 | 2020-12-07 | Clark | Missouri | 29045 | 325 | 4 |
801876 | 801876 | 2020-12-06 | Clark | Missouri | 29045 | 324 | 4 |
798631 | 798631 | 2020-12-05 | Clark | Missouri | 29045 | 320 | 4 |
795386 | 795386 | 2020-12-04 | Clark | Missouri | 29045 | 312 | 4 |
792141 | 792141 | 2020-12-03 | Clark | Missouri | 29045 | 309 | 4 |
788896 | 788896 | 2020-12-02 | Clark | Missouri | 29045 | 303 | 4 |
785651 | 785651 | 2020-12-01 | Clark | Missouri | 29045 | 303 | 4 |
782407 | 782407 | 2020-11-30 | Clark | Missouri | 29045 | 301 | 4 |
779161 | 779161 | 2020-11-29 | Clark | Missouri | 29045 | 298 | 3 |
775916 | 775916 | 2020-11-28 | Clark | Missouri | 29045 | 297 | 3 |
772671 | 772671 | 2020-11-27 | Clark | Missouri | 29045 | 296 | 3 |
769426 | 769426 | 2020-11-26 | Clark | Missouri | 29045 | 294 | 3 |
766180 | 766180 | 2020-11-25 | Clark | Missouri | 29045 | 287 | 3 |
762935 | 762935 | 2020-11-24 | Clark | Missouri | 29045 | 287 | 3 |
759690 | 759690 | 2020-11-23 | Clark | Missouri | 29045 | 282 | 2 |
756443 | 756443 | 2020-11-22 | Clark | Missouri | 29045 | 270 | 2 |
753197 | 753197 | 2020-11-21 | Clark | Missouri | 29045 | 269 | 2 |
749951 | 749951 | 2020-11-20 | Clark | Missouri | 29045 | 260 | 2 |
746705 | 746705 | 2020-11-19 | Clark | Missouri | 29045 | 248 | 2 |
743458 | 743458 | 2020-11-18 | Clark | Missouri | 29045 | 238 | 2 |
740211 | 740211 | 2020-11-17 | Clark | Missouri | 29045 | 234 | 2 |
736967 | 736967 | 2020-11-16 | Clark | Missouri | 29045 | 226 | 2 |
733721 | 733721 | 2020-11-15 | Clark | Missouri | 29045 | 224 | 2 |
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);