ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Monroe" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1244415 | 1244415 | 2021-04-21 | Monroe | Tennessee | 47123 | 5724 | 95 |
1241168 | 1241168 | 2021-04-20 | Monroe | Tennessee | 47123 | 5714 | 95 |
1237921 | 1237921 | 2021-04-19 | Monroe | Tennessee | 47123 | 5709 | 95 |
1234674 | 1234674 | 2021-04-18 | Monroe | Tennessee | 47123 | 5702 | 95 |
1231426 | 1231426 | 2021-04-17 | Monroe | Tennessee | 47123 | 5702 | 95 |
1228178 | 1228178 | 2021-04-16 | Monroe | Tennessee | 47123 | 5702 | 95 |
1224930 | 1224930 | 2021-04-15 | Monroe | Tennessee | 47123 | 5682 | 95 |
1221683 | 1221683 | 2021-04-14 | Monroe | Tennessee | 47123 | 5672 | 95 |
1218435 | 1218435 | 2021-04-13 | Monroe | Tennessee | 47123 | 5669 | 95 |
1215187 | 1215187 | 2021-04-12 | Monroe | Tennessee | 47123 | 5656 | 95 |
1211940 | 1211940 | 2021-04-11 | Monroe | Tennessee | 47123 | 5643 | 95 |
1208691 | 1208691 | 2021-04-10 | Monroe | Tennessee | 47123 | 5643 | 95 |
1205443 | 1205443 | 2021-04-09 | Monroe | Tennessee | 47123 | 5643 | 95 |
1202195 | 1202195 | 2021-04-08 | Monroe | Tennessee | 47123 | 5633 | 95 |
1198946 | 1198946 | 2021-04-07 | Monroe | Tennessee | 47123 | 5615 | 95 |
1195697 | 1195697 | 2021-04-06 | Monroe | Tennessee | 47123 | 5609 | 95 |
1192449 | 1192449 | 2021-04-05 | Monroe | Tennessee | 47123 | 5599 | 95 |
1189200 | 1189200 | 2021-04-04 | Monroe | Tennessee | 47123 | 5579 | 95 |
1185953 | 1185953 | 2021-04-03 | Monroe | Tennessee | 47123 | 5579 | 95 |
1182706 | 1182706 | 2021-04-02 | Monroe | Tennessee | 47123 | 5579 | 95 |
1179459 | 1179459 | 2021-04-01 | Monroe | Tennessee | 47123 | 5579 | 95 |
1176212 | 1176212 | 2021-03-31 | Monroe | Tennessee | 47123 | 5559 | 95 |
1172965 | 1172965 | 2021-03-30 | Monroe | Tennessee | 47123 | 5556 | 95 |
1169718 | 1169718 | 2021-03-29 | Monroe | Tennessee | 47123 | 5557 | 95 |
1166470 | 1166470 | 2021-03-28 | Monroe | Tennessee | 47123 | 5534 | 95 |
1163222 | 1163222 | 2021-03-27 | Monroe | Tennessee | 47123 | 5534 | 95 |
1159973 | 1159973 | 2021-03-26 | Monroe | Tennessee | 47123 | 5534 | 95 |
1156726 | 1156726 | 2021-03-25 | Monroe | Tennessee | 47123 | 5528 | 94 |
1153479 | 1153479 | 2021-03-24 | Monroe | Tennessee | 47123 | 5522 | 94 |
1150232 | 1150232 | 2021-03-23 | Monroe | Tennessee | 47123 | 5512 | 93 |
1146985 | 1146985 | 2021-03-22 | Monroe | Tennessee | 47123 | 5507 | 93 |
1143738 | 1143738 | 2021-03-21 | Monroe | Tennessee | 47123 | 5499 | 93 |
1140491 | 1140491 | 2021-03-20 | Monroe | Tennessee | 47123 | 5499 | 93 |
1137245 | 1137245 | 2021-03-19 | Monroe | Tennessee | 47123 | 5499 | 93 |
1133999 | 1133999 | 2021-03-18 | Monroe | Tennessee | 47123 | 5485 | 92 |
1130751 | 1130751 | 2021-03-17 | Monroe | Tennessee | 47123 | 5478 | 92 |
1127504 | 1127504 | 2021-03-16 | Monroe | Tennessee | 47123 | 5466 | 92 |
1124258 | 1124258 | 2021-03-15 | Monroe | Tennessee | 47123 | 5462 | 92 |
1121012 | 1121012 | 2021-03-14 | Monroe | Tennessee | 47123 | 5440 | 92 |
1117765 | 1117765 | 2021-03-13 | Monroe | Tennessee | 47123 | 5440 | 92 |
1114518 | 1114518 | 2021-03-12 | Monroe | Tennessee | 47123 | 5440 | 92 |
1111272 | 1111272 | 2021-03-11 | Monroe | Tennessee | 47123 | 5432 | 92 |
1108026 | 1108026 | 2021-03-10 | Monroe | Tennessee | 47123 | 5426 | 92 |
1104780 | 1104780 | 2021-03-09 | Monroe | Tennessee | 47123 | 5415 | 92 |
1101534 | 1101534 | 2021-03-08 | Monroe | Tennessee | 47123 | 5405 | 92 |
1098288 | 1098288 | 2021-03-07 | Monroe | Tennessee | 47123 | 5406 | 91 |
1095040 | 1095040 | 2021-03-06 | Monroe | Tennessee | 47123 | 5395 | 91 |
1091794 | 1091794 | 2021-03-05 | Monroe | Tennessee | 47123 | 5369 | 90 |
1088548 | 1088548 | 2021-03-04 | Monroe | Tennessee | 47123 | 5365 | 90 |
1085303 | 1085303 | 2021-03-03 | Monroe | Tennessee | 47123 | 5346 | 90 |
1082057 | 1082057 | 2021-03-02 | Monroe | Tennessee | 47123 | 5331 | 90 |
1078811 | 1078811 | 2021-03-01 | Monroe | Tennessee | 47123 | 5325 | 90 |
1075566 | 1075566 | 2021-02-28 | Monroe | Tennessee | 47123 | 5322 | 90 |
1072320 | 1072320 | 2021-02-27 | Monroe | Tennessee | 47123 | 5317 | 90 |
1069074 | 1069074 | 2021-02-26 | Monroe | Tennessee | 47123 | 5298 | 90 |
1065829 | 1065829 | 2021-02-25 | Monroe | Tennessee | 47123 | 5292 | 90 |
1062584 | 1062584 | 2021-02-24 | Monroe | Tennessee | 47123 | 5263 | 89 |
1059339 | 1059339 | 2021-02-23 | Monroe | Tennessee | 47123 | 5249 | 88 |
1056093 | 1056093 | 2021-02-22 | Monroe | Tennessee | 47123 | 5228 | 88 |
1052847 | 1052847 | 2021-02-21 | Monroe | Tennessee | 47123 | 5215 | 88 |
1049600 | 1049600 | 2021-02-20 | Monroe | Tennessee | 47123 | 5216 | 88 |
1046353 | 1046353 | 2021-02-19 | Monroe | Tennessee | 47123 | 5197 | 88 |
1043108 | 1043108 | 2021-02-18 | Monroe | Tennessee | 47123 | 5190 | 88 |
1039863 | 1039863 | 2021-02-17 | Monroe | Tennessee | 47123 | 5168 | 87 |
1036618 | 1036618 | 2021-02-16 | Monroe | Tennessee | 47123 | 5154 | 87 |
1033373 | 1033373 | 2021-02-15 | Monroe | Tennessee | 47123 | 5145 | 87 |
1030127 | 1030127 | 2021-02-14 | Monroe | Tennessee | 47123 | 5131 | 87 |
1026880 | 1026880 | 2021-02-13 | Monroe | Tennessee | 47123 | 5112 | 86 |
1023635 | 1023635 | 2021-02-12 | Monroe | Tennessee | 47123 | 5097 | 85 |
1020390 | 1020390 | 2021-02-11 | Monroe | Tennessee | 47123 | 5084 | 85 |
1017145 | 1017145 | 2021-02-10 | Monroe | Tennessee | 47123 | 5046 | 84 |
1013900 | 1013900 | 2021-02-09 | Monroe | Tennessee | 47123 | 5023 | 82 |
1010655 | 1010655 | 2021-02-08 | Monroe | Tennessee | 47123 | 5004 | 82 |
1007409 | 1007409 | 2021-02-07 | Monroe | Tennessee | 47123 | 4991 | 80 |
1004163 | 1004163 | 2021-02-06 | Monroe | Tennessee | 47123 | 4967 | 80 |
1000917 | 1000917 | 2021-02-05 | Monroe | Tennessee | 47123 | 4953 | 80 |
997671 | 997671 | 2021-02-04 | Monroe | Tennessee | 47123 | 4935 | 75 |
994425 | 994425 | 2021-02-03 | Monroe | Tennessee | 47123 | 4912 | 72 |
991179 | 991179 | 2021-02-02 | Monroe | Tennessee | 47123 | 4898 | 69 |
987933 | 987933 | 2021-02-01 | Monroe | Tennessee | 47123 | 4872 | 68 |
984686 | 984686 | 2021-01-31 | Monroe | Tennessee | 47123 | 4864 | 67 |
981439 | 981439 | 2021-01-30 | Monroe | Tennessee | 47123 | 4850 | 67 |
978193 | 978193 | 2021-01-29 | Monroe | Tennessee | 47123 | 4830 | 67 |
974948 | 974948 | 2021-01-28 | Monroe | Tennessee | 47123 | 4760 | 67 |
971703 | 971703 | 2021-01-27 | Monroe | Tennessee | 47123 | 4746 | 65 |
968458 | 968458 | 2021-01-26 | Monroe | Tennessee | 47123 | 4728 | 65 |
965214 | 965214 | 2021-01-25 | Monroe | Tennessee | 47123 | 4719 | 64 |
961969 | 961969 | 2021-01-24 | Monroe | Tennessee | 47123 | 4716 | 63 |
958724 | 958724 | 2021-01-23 | Monroe | Tennessee | 47123 | 4703 | 63 |
955478 | 955478 | 2021-01-22 | Monroe | Tennessee | 47123 | 4670 | 63 |
952233 | 952233 | 2021-01-21 | Monroe | Tennessee | 47123 | 4640 | 63 |
948988 | 948988 | 2021-01-20 | Monroe | Tennessee | 47123 | 4627 | 63 |
945742 | 945742 | 2021-01-19 | Monroe | Tennessee | 47123 | 4594 | 62 |
942495 | 942495 | 2021-01-18 | Monroe | Tennessee | 47123 | 4571 | 62 |
939250 | 939250 | 2021-01-17 | Monroe | Tennessee | 47123 | 4551 | 62 |
936005 | 936005 | 2021-01-16 | Monroe | Tennessee | 47123 | 4521 | 62 |
932760 | 932760 | 2021-01-15 | Monroe | Tennessee | 47123 | 4473 | 62 |
929515 | 929515 | 2021-01-14 | Monroe | Tennessee | 47123 | 4420 | 62 |
926270 | 926270 | 2021-01-13 | Monroe | Tennessee | 47123 | 4397 | 62 |
923024 | 923024 | 2021-01-12 | Monroe | Tennessee | 47123 | 4358 | 62 |
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);