ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Jasper" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055051 | 1055051 | 2021-02-22 | Jasper | Missouri | 29097 | 7373 | 114 |
1051804 | 1051804 | 2021-02-21 | Jasper | Missouri | 29097 | 7372 | 114 |
1048557 | 1048557 | 2021-02-20 | Jasper | Missouri | 29097 | 7361 | 114 |
1045311 | 1045311 | 2021-02-19 | Jasper | Missouri | 29097 | 7350 | 114 |
1042066 | 1042066 | 2021-02-18 | Jasper | Missouri | 29097 | 7345 | 112 |
1038821 | 1038821 | 2021-02-17 | Jasper | Missouri | 29097 | 7329 | 112 |
1035576 | 1035576 | 2021-02-16 | Jasper | Missouri | 29097 | 7318 | 111 |
1032331 | 1032331 | 2021-02-15 | Jasper | Missouri | 29097 | 7311 | 111 |
1029084 | 1029084 | 2021-02-14 | Jasper | Missouri | 29097 | 7306 | 111 |
1025838 | 1025838 | 2021-02-13 | Jasper | Missouri | 29097 | 7304 | 111 |
1022593 | 1022593 | 2021-02-12 | Jasper | Missouri | 29097 | 7289 | 111 |
1019348 | 1019348 | 2021-02-11 | Jasper | Missouri | 29097 | 7269 | 109 |
1016103 | 1016103 | 2021-02-10 | Jasper | Missouri | 29097 | 7252 | 109 |
1012858 | 1012858 | 2021-02-09 | Jasper | Missouri | 29097 | 7245 | 109 |
1009613 | 1009613 | 2021-02-08 | Jasper | Missouri | 29097 | 7225 | 109 |
1006366 | 1006366 | 2021-02-07 | Jasper | Missouri | 29097 | 7216 | 109 |
1003120 | 1003120 | 2021-02-06 | Jasper | Missouri | 29097 | 7208 | 109 |
999875 | 999875 | 2021-02-05 | Jasper | Missouri | 29097 | 7187 | 109 |
996629 | 996629 | 2021-02-04 | Jasper | Missouri | 29097 | 7162 | 107 |
993383 | 993383 | 2021-02-03 | Jasper | Missouri | 29097 | 7130 | 107 |
990137 | 990137 | 2021-02-02 | Jasper | Missouri | 29097 | 7096 | 105 |
986890 | 986890 | 2021-02-01 | Jasper | Missouri | 29097 | 7063 | 101 |
983643 | 983643 | 2021-01-31 | Jasper | Missouri | 29097 | 7055 | 101 |
980397 | 980397 | 2021-01-30 | Jasper | Missouri | 29097 | 7034 | 101 |
977151 | 977151 | 2021-01-29 | Jasper | Missouri | 29097 | 7002 | 101 |
973906 | 973906 | 2021-01-28 | Jasper | Missouri | 29097 | 6983 | 101 |
970661 | 970661 | 2021-01-27 | Jasper | Missouri | 29097 | 6949 | 101 |
967416 | 967416 | 2021-01-26 | Jasper | Missouri | 29097 | 6905 | 100 |
964172 | 964172 | 2021-01-25 | Jasper | Missouri | 29097 | 6885 | 100 |
960927 | 960927 | 2021-01-24 | Jasper | Missouri | 29097 | 6870 | 100 |
957681 | 957681 | 2021-01-23 | Jasper | Missouri | 29097 | 6851 | 100 |
954436 | 954436 | 2021-01-22 | Jasper | Missouri | 29097 | 6828 | 100 |
951191 | 951191 | 2021-01-21 | Jasper | Missouri | 29097 | 6796 | 94 |
947945 | 947945 | 2021-01-20 | Jasper | Missouri | 29097 | 6761 | 94 |
944698 | 944698 | 2021-01-19 | Jasper | Missouri | 29097 | 6723 | 94 |
941453 | 941453 | 2021-01-18 | Jasper | Missouri | 29097 | 6707 | 94 |
938208 | 938208 | 2021-01-17 | Jasper | Missouri | 29097 | 6689 | 94 |
934963 | 934963 | 2021-01-16 | Jasper | Missouri | 29097 | 6662 | 94 |
931718 | 931718 | 2021-01-15 | Jasper | Missouri | 29097 | 6633 | 92 |
928473 | 928473 | 2021-01-14 | Jasper | Missouri | 29097 | 6606 | 92 |
925227 | 925227 | 2021-01-13 | Jasper | Missouri | 29097 | 6577 | 92 |
921982 | 921982 | 2021-01-12 | Jasper | Missouri | 29097 | 6506 | 92 |
918737 | 918737 | 2021-01-11 | Jasper | Missouri | 29097 | 6483 | 92 |
915492 | 915492 | 2021-01-10 | Jasper | Missouri | 29097 | 6465 | 92 |
912247 | 912247 | 2021-01-09 | Jasper | Missouri | 29097 | 6429 | 92 |
909002 | 909002 | 2021-01-08 | Jasper | Missouri | 29097 | 6381 | 87 |
905756 | 905756 | 2021-01-07 | Jasper | Missouri | 29097 | 6326 | 87 |
902511 | 902511 | 2021-01-06 | Jasper | Missouri | 29097 | 6267 | 87 |
899266 | 899266 | 2021-01-05 | Jasper | Missouri | 29097 | 6200 | 87 |
896021 | 896021 | 2021-01-04 | Jasper | Missouri | 29097 | 6165 | 86 |
892774 | 892774 | 2021-01-03 | Jasper | Missouri | 29097 | 6165 | 86 |
889528 | 889528 | 2021-01-02 | Jasper | Missouri | 29097 | 6121 | 86 |
886282 | 886282 | 2021-01-01 | Jasper | Missouri | 29097 | 6090 | 86 |
883037 | 883037 | 2020-12-31 | Jasper | Missouri | 29097 | 6020 | 84 |
879792 | 879792 | 2020-12-30 | Jasper | Missouri | 29097 | 5953 | 84 |
876547 | 876547 | 2020-12-29 | Jasper | Missouri | 29097 | 5902 | 84 |
873302 | 873302 | 2020-12-28 | Jasper | Missouri | 29097 | 5873 | 83 |
870057 | 870057 | 2020-12-27 | Jasper | Missouri | 29097 | 5843 | 83 |
866812 | 866812 | 2020-12-26 | Jasper | Missouri | 29097 | 5833 | 83 |
863567 | 863567 | 2020-12-25 | Jasper | Missouri | 29097 | 5819 | 83 |
860322 | 860322 | 2020-12-24 | Jasper | Missouri | 29097 | 5803 | 83 |
857077 | 857077 | 2020-12-23 | Jasper | Missouri | 29097 | 5776 | 83 |
853832 | 853832 | 2020-12-22 | Jasper | Missouri | 29097 | 5731 | 83 |
850587 | 850587 | 2020-12-21 | Jasper | Missouri | 29097 | 5719 | 80 |
847342 | 847342 | 2020-12-20 | Jasper | Missouri | 29097 | 5704 | 80 |
844096 | 844096 | 2020-12-19 | Jasper | Missouri | 29097 | 5667 | 80 |
840851 | 840851 | 2020-12-18 | Jasper | Missouri | 29097 | 5632 | 80 |
837606 | 837606 | 2020-12-17 | Jasper | Missouri | 29097 | 5590 | 80 |
834360 | 834360 | 2020-12-16 | Jasper | Missouri | 29097 | 5551 | 78 |
831113 | 831113 | 2020-12-15 | Jasper | Missouri | 29097 | 5509 | 78 |
827867 | 827867 | 2020-12-14 | Jasper | Missouri | 29097 | 5493 | 78 |
824620 | 824620 | 2020-12-13 | Jasper | Missouri | 29097 | 5471 | 78 |
821374 | 821374 | 2020-12-12 | Jasper | Missouri | 29097 | 5449 | 78 |
818128 | 818128 | 2020-12-11 | Jasper | Missouri | 29097 | 5383 | 74 |
814882 | 814882 | 2020-12-10 | Jasper | Missouri | 29097 | 5383 | 74 |
811637 | 811637 | 2020-12-09 | Jasper | Missouri | 29097 | 5346 | 74 |
808392 | 808392 | 2020-12-08 | Jasper | Missouri | 29097 | 5297 | 71 |
805147 | 805147 | 2020-12-07 | Jasper | Missouri | 29097 | 5252 | 71 |
801902 | 801902 | 2020-12-06 | Jasper | Missouri | 29097 | 5241 | 71 |
798657 | 798657 | 2020-12-05 | Jasper | Missouri | 29097 | 5208 | 71 |
795412 | 795412 | 2020-12-04 | Jasper | Missouri | 29097 | 5162 | 70 |
792167 | 792167 | 2020-12-03 | Jasper | Missouri | 29097 | 5122 | 68 |
788922 | 788922 | 2020-12-02 | Jasper | Missouri | 29097 | 5085 | 66 |
785677 | 785677 | 2020-12-01 | Jasper | Missouri | 29097 | 5009 | 65 |
782433 | 782433 | 2020-11-30 | Jasper | Missouri | 29097 | 4984 | 60 |
779187 | 779187 | 2020-11-29 | Jasper | Missouri | 29097 | 4956 | 60 |
775942 | 775942 | 2020-11-28 | Jasper | Missouri | 29097 | 4926 | 60 |
772697 | 772697 | 2020-11-27 | Jasper | Missouri | 29097 | 4925 | 60 |
769452 | 769452 | 2020-11-26 | Jasper | Missouri | 29097 | 4887 | 60 |
766206 | 766206 | 2020-11-25 | Jasper | Missouri | 29097 | 4843 | 60 |
762961 | 762961 | 2020-11-24 | Jasper | Missouri | 29097 | 4782 | 60 |
759716 | 759716 | 2020-11-23 | Jasper | Missouri | 29097 | 4761 | 59 |
756469 | 756469 | 2020-11-22 | Jasper | Missouri | 29097 | 4731 | 59 |
753223 | 753223 | 2020-11-21 | Jasper | Missouri | 29097 | 4660 | 59 |
749977 | 749977 | 2020-11-20 | Jasper | Missouri | 29097 | 4566 | 58 |
746731 | 746731 | 2020-11-19 | Jasper | Missouri | 29097 | 4503 | 58 |
743484 | 743484 | 2020-11-18 | Jasper | Missouri | 29097 | 4405 | 58 |
740237 | 740237 | 2020-11-17 | Jasper | Missouri | 29097 | 4311 | 55 |
736993 | 736993 | 2020-11-16 | Jasper | Missouri | 29097 | 4279 | 54 |
733747 | 733747 | 2020-11-15 | Jasper | Missouri | 29097 | 4233 | 54 |
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);