ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Charlotte" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060327 | 1060327 | 2021-02-24 | Charlotte | Florida | 12015 | 10596 | 358 |
1057081 | 1057081 | 2021-02-23 | Charlotte | Florida | 12015 | 10567 | 355 |
1053835 | 1053835 | 2021-02-22 | Charlotte | Florida | 12015 | 10537 | 355 |
1050588 | 1050588 | 2021-02-21 | Charlotte | Florida | 12015 | 10523 | 353 |
1047341 | 1047341 | 2021-02-20 | Charlotte | Florida | 12015 | 10497 | 348 |
1044096 | 1044096 | 2021-02-19 | Charlotte | Florida | 12015 | 10450 | 345 |
1040851 | 1040851 | 2021-02-18 | Charlotte | Florida | 12015 | 10415 | 338 |
1037606 | 1037606 | 2021-02-17 | Charlotte | Florida | 12015 | 10393 | 338 |
1034361 | 1034361 | 2021-02-16 | Charlotte | Florida | 12015 | 10346 | 335 |
1031115 | 1031115 | 2021-02-15 | Charlotte | Florida | 12015 | 10322 | 333 |
1027868 | 1027868 | 2021-02-14 | Charlotte | Florida | 12015 | 10280 | 331 |
1024623 | 1024623 | 2021-02-13 | Charlotte | Florida | 12015 | 10236 | 323 |
1021378 | 1021378 | 2021-02-12 | Charlotte | Florida | 12015 | 10194 | 323 |
1018133 | 1018133 | 2021-02-11 | Charlotte | Florida | 12015 | 10150 | 320 |
1014888 | 1014888 | 2021-02-10 | Charlotte | Florida | 12015 | 10099 | 313 |
1011643 | 1011643 | 2021-02-09 | Charlotte | Florida | 12015 | 10064 | 313 |
1008397 | 1008397 | 2021-02-08 | Charlotte | Florida | 12015 | 10031 | 313 |
1005151 | 1005151 | 2021-02-07 | Charlotte | Florida | 12015 | 10005 | 310 |
1001905 | 1001905 | 2021-02-06 | Charlotte | Florida | 12015 | 9976 | 306 |
998659 | 998659 | 2021-02-05 | Charlotte | Florida | 12015 | 9934 | 305 |
995413 | 995413 | 2021-02-04 | Charlotte | Florida | 12015 | 9890 | 304 |
992167 | 992167 | 2021-02-03 | Charlotte | Florida | 12015 | 9848 | 304 |
988921 | 988921 | 2021-02-02 | Charlotte | Florida | 12015 | 9801 | 303 |
985674 | 985674 | 2021-02-01 | Charlotte | Florida | 12015 | 9745 | 303 |
982427 | 982427 | 2021-01-31 | Charlotte | Florida | 12015 | 9719 | 299 |
979181 | 979181 | 2021-01-30 | Charlotte | Florida | 12015 | 9688 | 292 |
975936 | 975936 | 2021-01-29 | Charlotte | Florida | 12015 | 9614 | 291 |
972691 | 972691 | 2021-01-28 | Charlotte | Florida | 12015 | 9550 | 291 |
969446 | 969446 | 2021-01-27 | Charlotte | Florida | 12015 | 9493 | 290 |
966202 | 966202 | 2021-01-26 | Charlotte | Florida | 12015 | 9442 | 290 |
962957 | 962957 | 2021-01-25 | Charlotte | Florida | 12015 | 9410 | 290 |
959712 | 959712 | 2021-01-24 | Charlotte | Florida | 12015 | 9367 | 284 |
956466 | 956466 | 2021-01-23 | Charlotte | Florida | 12015 | 9316 | 272 |
953221 | 953221 | 2021-01-22 | Charlotte | Florida | 12015 | 9257 | 271 |
949976 | 949976 | 2021-01-21 | Charlotte | Florida | 12015 | 9195 | 271 |
946730 | 946730 | 2021-01-20 | Charlotte | Florida | 12015 | 9138 | 271 |
943483 | 943483 | 2021-01-19 | Charlotte | Florida | 12015 | 9059 | 271 |
940238 | 940238 | 2021-01-18 | Charlotte | Florida | 12015 | 9023 | 270 |
936993 | 936993 | 2021-01-17 | Charlotte | Florida | 12015 | 8965 | 263 |
933748 | 933748 | 2021-01-16 | Charlotte | Florida | 12015 | 8921 | 258 |
930503 | 930503 | 2021-01-15 | Charlotte | Florida | 12015 | 8854 | 257 |
927258 | 927258 | 2021-01-14 | Charlotte | Florida | 12015 | 8749 | 257 |
924012 | 924012 | 2021-01-13 | Charlotte | Florida | 12015 | 8681 | 257 |
920767 | 920767 | 2021-01-12 | Charlotte | Florida | 12015 | 8599 | 256 |
917522 | 917522 | 2021-01-11 | Charlotte | Florida | 12015 | 8522 | 254 |
914277 | 914277 | 2021-01-10 | Charlotte | Florida | 12015 | 8456 | 251 |
911032 | 911032 | 2021-01-09 | Charlotte | Florida | 12015 | 8382 | 250 |
907787 | 907787 | 2021-01-08 | Charlotte | Florida | 12015 | 8293 | 249 |
904541 | 904541 | 2021-01-07 | Charlotte | Florida | 12015 | 8147 | 248 |
901296 | 901296 | 2021-01-06 | Charlotte | Florida | 12015 | 8029 | 246 |
898051 | 898051 | 2021-01-05 | Charlotte | Florida | 12015 | 7880 | 241 |
894806 | 894806 | 2021-01-04 | Charlotte | Florida | 12015 | 7807 | 241 |
891559 | 891559 | 2021-01-03 | Charlotte | Florida | 12015 | 7727 | 238 |
888312 | 888312 | 2021-01-02 | Charlotte | Florida | 12015 | 7647 | 236 |
885067 | 885067 | 2021-01-01 | Charlotte | Florida | 12015 | 7410 | 231 |
881822 | 881822 | 2020-12-31 | Charlotte | Florida | 12015 | 7410 | 231 |
878577 | 878577 | 2020-12-30 | Charlotte | Florida | 12015 | 7282 | 231 |
875332 | 875332 | 2020-12-29 | Charlotte | Florida | 12015 | 7192 | 231 |
872087 | 872087 | 2020-12-28 | Charlotte | Florida | 12015 | 7128 | 231 |
868842 | 868842 | 2020-12-27 | Charlotte | Florida | 12015 | 7065 | 230 |
865597 | 865597 | 2020-12-26 | Charlotte | Florida | 12015 | 7000 | 228 |
862352 | 862352 | 2020-12-25 | Charlotte | Florida | 12015 | 6854 | 217 |
859107 | 859107 | 2020-12-24 | Charlotte | Florida | 12015 | 6854 | 217 |
855862 | 855862 | 2020-12-23 | Charlotte | Florida | 12015 | 6742 | 217 |
852617 | 852617 | 2020-12-22 | Charlotte | Florida | 12015 | 6665 | 217 |
849372 | 849372 | 2020-12-21 | Charlotte | Florida | 12015 | 6610 | 217 |
846127 | 846127 | 2020-12-20 | Charlotte | Florida | 12015 | 6531 | 217 |
842881 | 842881 | 2020-12-19 | Charlotte | Florida | 12015 | 6475 | 213 |
839636 | 839636 | 2020-12-18 | Charlotte | Florida | 12015 | 6384 | 212 |
836391 | 836391 | 2020-12-17 | Charlotte | Florida | 12015 | 6313 | 212 |
833145 | 833145 | 2020-12-16 | Charlotte | Florida | 12015 | 6207 | 212 |
829898 | 829898 | 2020-12-15 | Charlotte | Florida | 12015 | 6104 | 212 |
826652 | 826652 | 2020-12-14 | Charlotte | Florida | 12015 | 6111 | 212 |
823405 | 823405 | 2020-12-13 | Charlotte | Florida | 12015 | 6066 | 209 |
820159 | 820159 | 2020-12-12 | Charlotte | Florida | 12015 | 6004 | 209 |
816913 | 816913 | 2020-12-11 | Charlotte | Florida | 12015 | 5923 | 208 |
813667 | 813667 | 2020-12-10 | Charlotte | Florida | 12015 | 5840 | 207 |
810423 | 810423 | 2020-12-09 | Charlotte | Florida | 12015 | 5746 | 207 |
807178 | 807178 | 2020-12-08 | Charlotte | Florida | 12015 | 5652 | 203 |
803933 | 803933 | 2020-12-07 | Charlotte | Florida | 12015 | 5593 | 203 |
800688 | 800688 | 2020-12-06 | Charlotte | Florida | 12015 | 5527 | 200 |
797443 | 797443 | 2020-12-05 | Charlotte | Florida | 12015 | 5437 | 200 |
794198 | 794198 | 2020-12-04 | Charlotte | Florida | 12015 | 5354 | 197 |
790953 | 790953 | 2020-12-03 | Charlotte | Florida | 12015 | 5293 | 197 |
787708 | 787708 | 2020-12-02 | Charlotte | Florida | 12015 | 5220 | 197 |
784464 | 784464 | 2020-12-01 | Charlotte | Florida | 12015 | 5150 | 197 |
781219 | 781219 | 2020-11-30 | Charlotte | Florida | 12015 | 5087 | 197 |
777973 | 777973 | 2020-11-29 | Charlotte | Florida | 12015 | 5052 | 194 |
774728 | 774728 | 2020-11-28 | Charlotte | Florida | 12015 | 5003 | 193 |
771483 | 771483 | 2020-11-27 | Charlotte | Florida | 12015 | 4968 | 192 |
768238 | 768238 | 2020-11-26 | Charlotte | Florida | 12015 | 4831 | 186 |
764992 | 764992 | 2020-11-25 | Charlotte | Florida | 12015 | 4831 | 186 |
761747 | 761747 | 2020-11-24 | Charlotte | Florida | 12015 | 4780 | 183 |
758502 | 758502 | 2020-11-23 | Charlotte | Florida | 12015 | 4720 | 183 |
755255 | 755255 | 2020-11-22 | Charlotte | Florida | 12015 | 4672 | 181 |
752009 | 752009 | 2020-11-21 | Charlotte | Florida | 12015 | 4624 | 179 |
748763 | 748763 | 2020-11-20 | Charlotte | Florida | 12015 | 4576 | 179 |
745517 | 745517 | 2020-11-19 | Charlotte | Florida | 12015 | 4503 | 179 |
742270 | 742270 | 2020-11-18 | Charlotte | Florida | 12015 | 4425 | 176 |
739023 | 739023 | 2020-11-17 | Charlotte | Florida | 12015 | 4383 | 175 |
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);