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 |
---|---|---|---|---|---|---|---|
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 |
919779 | 919779 | 2021-01-11 | Monroe | Tennessee | 47123 | 4343 | 62 |
916534 | 916534 | 2021-01-10 | Monroe | Tennessee | 47123 | 4328 | 62 |
913289 | 913289 | 2021-01-09 | Monroe | Tennessee | 47123 | 4281 | 60 |
910044 | 910044 | 2021-01-08 | Monroe | Tennessee | 47123 | 4221 | 60 |
906799 | 906799 | 2021-01-07 | Monroe | Tennessee | 47123 | 4188 | 59 |
903553 | 903553 | 2021-01-06 | Monroe | Tennessee | 47123 | 4128 | 58 |
900308 | 900308 | 2021-01-05 | Monroe | Tennessee | 47123 | 4055 | 57 |
897063 | 897063 | 2021-01-04 | Monroe | Tennessee | 47123 | 4005 | 57 |
893817 | 893817 | 2021-01-03 | Monroe | Tennessee | 47123 | 3977 | 56 |
890571 | 890571 | 2021-01-02 | Monroe | Tennessee | 47123 | 3952 | 56 |
887324 | 887324 | 2021-01-01 | Monroe | Tennessee | 47123 | 3880 | 56 |
884079 | 884079 | 2020-12-31 | Monroe | Tennessee | 47123 | 3880 | 56 |
880834 | 880834 | 2020-12-30 | Monroe | Tennessee | 47123 | 3820 | 54 |
877589 | 877589 | 2020-12-29 | Monroe | Tennessee | 47123 | 3758 | 54 |
874344 | 874344 | 2020-12-28 | Monroe | Tennessee | 47123 | 3723 | 53 |
871099 | 871099 | 2020-12-27 | Monroe | Tennessee | 47123 | 3703 | 53 |
867854 | 867854 | 2020-12-26 | Monroe | Tennessee | 47123 | 3678 | 52 |
864609 | 864609 | 2020-12-25 | Monroe | Tennessee | 47123 | 3652 | 52 |
861364 | 861364 | 2020-12-24 | Monroe | Tennessee | 47123 | 3544 | 52 |
858119 | 858119 | 2020-12-23 | Monroe | Tennessee | 47123 | 3499 | 52 |
854874 | 854874 | 2020-12-22 | Monroe | Tennessee | 47123 | 3464 | 52 |
851629 | 851629 | 2020-12-21 | Monroe | Tennessee | 47123 | 3402 | 51 |
848384 | 848384 | 2020-12-20 | Monroe | Tennessee | 47123 | 3328 | 51 |
845139 | 845139 | 2020-12-19 | Monroe | Tennessee | 47123 | 3241 | 50 |
841893 | 841893 | 2020-12-18 | Monroe | Tennessee | 47123 | 3212 | 50 |
838648 | 838648 | 2020-12-17 | Monroe | Tennessee | 47123 | 3126 | 50 |
835402 | 835402 | 2020-12-16 | Monroe | Tennessee | 47123 | 3039 | 49 |
832156 | 832156 | 2020-12-15 | Monroe | Tennessee | 47123 | 2955 | 48 |
828909 | 828909 | 2020-12-14 | Monroe | Tennessee | 47123 | 2904 | 48 |
825663 | 825663 | 2020-12-13 | Monroe | Tennessee | 47123 | 2821 | 48 |
822416 | 822416 | 2020-12-12 | Monroe | Tennessee | 47123 | 2731 | 48 |
819170 | 819170 | 2020-12-11 | Monroe | Tennessee | 47123 | 2707 | 47 |
815924 | 815924 | 2020-12-10 | Monroe | Tennessee | 47123 | 2648 | 47 |
812678 | 812678 | 2020-12-09 | Monroe | Tennessee | 47123 | 2594 | 47 |
809434 | 809434 | 2020-12-08 | Monroe | Tennessee | 47123 | 2554 | 47 |
806189 | 806189 | 2020-12-07 | Monroe | Tennessee | 47123 | 2484 | 46 |
802944 | 802944 | 2020-12-06 | Monroe | Tennessee | 47123 | 2429 | 46 |
799699 | 799699 | 2020-12-05 | Monroe | Tennessee | 47123 | 2401 | 46 |
796454 | 796454 | 2020-12-04 | Monroe | Tennessee | 47123 | 2350 | 46 |
793209 | 793209 | 2020-12-03 | Monroe | Tennessee | 47123 | 2341 | 46 |
789964 | 789964 | 2020-12-02 | Monroe | Tennessee | 47123 | 2312 | 45 |
786719 | 786719 | 2020-12-01 | Monroe | Tennessee | 47123 | 2295 | 44 |
783475 | 783475 | 2020-11-30 | Monroe | Tennessee | 47123 | 2232 | 44 |
780230 | 780230 | 2020-11-29 | Monroe | Tennessee | 47123 | 2178 | 44 |
776984 | 776984 | 2020-11-28 | Monroe | Tennessee | 47123 | 2127 | 44 |
773739 | 773739 | 2020-11-27 | Monroe | Tennessee | 47123 | 2074 | 44 |
770494 | 770494 | 2020-11-26 | Monroe | Tennessee | 47123 | 2056 | 44 |
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);