ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 12009 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277870 | 1277870 | 2021-05-02 | Brevard | Florida | 12009 | 41119 | 862 |
1274623 | 1274623 | 2021-05-01 | Brevard | Florida | 12009 | 41041 | 861 |
1271376 | 1271376 | 2021-04-30 | Brevard | Florida | 12009 | 40904 | 861 |
1268129 | 1268129 | 2021-04-29 | Brevard | Florida | 12009 | 40780 | 859 |
1264882 | 1264882 | 2021-04-28 | Brevard | Florida | 12009 | 40660 | 858 |
1261635 | 1261635 | 2021-04-27 | Brevard | Florida | 12009 | 40538 | 854 |
1258388 | 1258388 | 2021-04-26 | Brevard | Florida | 12009 | 40432 | 853 |
1255141 | 1255141 | 2021-04-25 | Brevard | Florida | 12009 | 40323 | 852 |
1251894 | 1251894 | 2021-04-24 | Brevard | Florida | 12009 | 40186 | 852 |
1248647 | 1248647 | 2021-04-23 | Brevard | Florida | 12009 | 40013 | 849 |
1245400 | 1245400 | 2021-04-22 | Brevard | Florida | 12009 | 39883 | 847 |
1242153 | 1242153 | 2021-04-21 | Brevard | Florida | 12009 | 39745 | 847 |
1238906 | 1238906 | 2021-04-20 | Brevard | Florida | 12009 | 39626 | 846 |
1235659 | 1235659 | 2021-04-19 | Brevard | Florida | 12009 | 39464 | 843 |
1232412 | 1232412 | 2021-04-18 | Brevard | Florida | 12009 | 39385 | 843 |
1229163 | 1229163 | 2021-04-17 | Brevard | Florida | 12009 | 39271 | 841 |
1225915 | 1225915 | 2021-04-16 | Brevard | Florida | 12009 | 39153 | 840 |
1222668 | 1222668 | 2021-04-15 | Brevard | Florida | 12009 | 39002 | 837 |
1219420 | 1219420 | 2021-04-14 | Brevard | Florida | 12009 | 38872 | 836 |
1216172 | 1216172 | 2021-04-13 | Brevard | Florida | 12009 | 38712 | 836 |
1212925 | 1212925 | 2021-04-12 | Brevard | Florida | 12009 | 38547 | 831 |
1209677 | 1209677 | 2021-04-11 | Brevard | Florida | 12009 | 38508 | 828 |
1206428 | 1206428 | 2021-04-10 | Brevard | Florida | 12009 | 38389 | 828 |
1203180 | 1203180 | 2021-04-09 | Brevard | Florida | 12009 | 38267 | 825 |
1199932 | 1199932 | 2021-04-08 | Brevard | Florida | 12009 | 38123 | 825 |
1196683 | 1196683 | 2021-04-07 | Brevard | Florida | 12009 | 37984 | 825 |
1193435 | 1193435 | 2021-04-06 | Brevard | Florida | 12009 | 37852 | 818 |
1190185 | 1190185 | 2021-04-05 | Brevard | Florida | 12009 | 37716 | 814 |
1186938 | 1186938 | 2021-04-04 | Brevard | Florida | 12009 | 37660 | 814 |
1183691 | 1183691 | 2021-04-03 | Brevard | Florida | 12009 | 37563 | 814 |
1180444 | 1180444 | 2021-04-02 | Brevard | Florida | 12009 | 37451 | 813 |
1177197 | 1177197 | 2021-04-01 | Brevard | Florida | 12009 | 37326 | 809 |
1173950 | 1173950 | 2021-03-31 | Brevard | Florida | 12009 | 37190 | 808 |
1170703 | 1170703 | 2021-03-30 | Brevard | Florida | 12009 | 37116 | 807 |
1167455 | 1167455 | 2021-03-29 | Brevard | Florida | 12009 | 37012 | 806 |
1164207 | 1164207 | 2021-03-28 | Brevard | Florida | 12009 | 36951 | 804 |
1160959 | 1160959 | 2021-03-27 | Brevard | Florida | 12009 | 36859 | 803 |
1157711 | 1157711 | 2021-03-26 | Brevard | Florida | 12009 | 36746 | 802 |
1154464 | 1154464 | 2021-03-25 | Brevard | Florida | 12009 | 36652 | 793 |
1151217 | 1151217 | 2021-03-24 | Brevard | Florida | 12009 | 36548 | 792 |
1147970 | 1147970 | 2021-03-23 | Brevard | Florida | 12009 | 36438 | 790 |
1144723 | 1144723 | 2021-03-22 | Brevard | Florida | 12009 | 36306 | 789 |
1141476 | 1141476 | 2021-03-21 | Brevard | Florida | 12009 | 36225 | 789 |
1138230 | 1138230 | 2021-03-20 | Brevard | Florida | 12009 | 36142 | 789 |
1134984 | 1134984 | 2021-03-19 | Brevard | Florida | 12009 | 36051 | 789 |
1131737 | 1131737 | 2021-03-18 | Brevard | Florida | 12009 | 35925 | 787 |
1128489 | 1128489 | 2021-03-17 | Brevard | Florida | 12009 | 35820 | 784 |
1125243 | 1125243 | 2021-03-16 | Brevard | Florida | 12009 | 35840 | 782 |
1121997 | 1121997 | 2021-03-15 | Brevard | Florida | 12009 | 35618 | 783 |
1118750 | 1118750 | 2021-03-14 | Brevard | Florida | 12009 | 35573 | 781 |
1115503 | 1115503 | 2021-03-13 | Brevard | Florida | 12009 | 35464 | 781 |
1112257 | 1112257 | 2021-03-12 | Brevard | Florida | 12009 | 35342 | 773 |
1109011 | 1109011 | 2021-03-11 | Brevard | Florida | 12009 | 35185 | 772 |
1105765 | 1105765 | 2021-03-10 | Brevard | Florida | 12009 | 35081 | 768 |
1102519 | 1102519 | 2021-03-09 | Brevard | Florida | 12009 | 34944 | 769 |
1099273 | 1099273 | 2021-03-08 | Brevard | Florida | 12009 | 34833 | 764 |
1096025 | 1096025 | 2021-03-07 | Brevard | Florida | 12009 | 34767 | 764 |
1092779 | 1092779 | 2021-03-06 | Brevard | Florida | 12009 | 34648 | 764 |
1089533 | 1089533 | 2021-03-05 | Brevard | Florida | 12009 | 34549 | 761 |
1086288 | 1086288 | 2021-03-04 | Brevard | Florida | 12009 | 34434 | 751 |
1083042 | 1083042 | 2021-03-03 | Brevard | Florida | 12009 | 34303 | 751 |
1079796 | 1079796 | 2021-03-02 | Brevard | Florida | 12009 | 34212 | 751 |
1076551 | 1076551 | 2021-03-01 | Brevard | Florida | 12009 | 34070 | 746 |
1073305 | 1073305 | 2021-02-28 | Brevard | Florida | 12009 | 33990 | 746 |
1070059 | 1070059 | 2021-02-27 | Brevard | Florida | 12009 | 33885 | 741 |
1066814 | 1066814 | 2021-02-26 | Brevard | Florida | 12009 | 33739 | 738 |
1063569 | 1063569 | 2021-02-25 | Brevard | Florida | 12009 | 33578 | 736 |
1060324 | 1060324 | 2021-02-24 | Brevard | Florida | 12009 | 33429 | 736 |
1057078 | 1057078 | 2021-02-23 | Brevard | Florida | 12009 | 33238 | 731 |
1053832 | 1053832 | 2021-02-22 | Brevard | Florida | 12009 | 33106 | 728 |
1050585 | 1050585 | 2021-02-21 | Brevard | Florida | 12009 | 33007 | 728 |
1047338 | 1047338 | 2021-02-20 | Brevard | Florida | 12009 | 32855 | 722 |
1044093 | 1044093 | 2021-02-19 | Brevard | Florida | 12009 | 32675 | 721 |
1040848 | 1040848 | 2021-02-18 | Brevard | Florida | 12009 | 32555 | 714 |
1037603 | 1037603 | 2021-02-17 | Brevard | Florida | 12009 | 32445 | 710 |
1034358 | 1034358 | 2021-02-16 | Brevard | Florida | 12009 | 32277 | 706 |
1031112 | 1031112 | 2021-02-15 | Brevard | Florida | 12009 | 32083 | 704 |
1027865 | 1027865 | 2021-02-14 | Brevard | Florida | 12009 | 32013 | 703 |
1024620 | 1024620 | 2021-02-13 | Brevard | Florida | 12009 | 31906 | 702 |
1021375 | 1021375 | 2021-02-12 | Brevard | Florida | 12009 | 31741 | 697 |
1018130 | 1018130 | 2021-02-11 | Brevard | Florida | 12009 | 31581 | 690 |
1014885 | 1014885 | 2021-02-10 | Brevard | Florida | 12009 | 31414 | 690 |
1011640 | 1011640 | 2021-02-09 | Brevard | Florida | 12009 | 31238 | 681 |
1008394 | 1008394 | 2021-02-08 | Brevard | Florida | 12009 | 31006 | 681 |
1005148 | 1005148 | 2021-02-07 | Brevard | Florida | 12009 | 30858 | 680 |
1001902 | 1001902 | 2021-02-06 | Brevard | Florida | 12009 | 30624 | 675 |
998656 | 998656 | 2021-02-05 | Brevard | Florida | 12009 | 30459 | 666 |
995410 | 995410 | 2021-02-04 | Brevard | Florida | 12009 | 30153 | 663 |
992164 | 992164 | 2021-02-03 | Brevard | Florida | 12009 | 30026 | 663 |
988918 | 988918 | 2021-02-02 | Brevard | Florida | 12009 | 29829 | 655 |
985671 | 985671 | 2021-02-01 | Brevard | Florida | 12009 | 29518 | 655 |
982424 | 982424 | 2021-01-31 | Brevard | Florida | 12009 | 29345 | 654 |
979178 | 979178 | 2021-01-30 | Brevard | Florida | 12009 | 29177 | 650 |
975933 | 975933 | 2021-01-29 | Brevard | Florida | 12009 | 28792 | 639 |
972688 | 972688 | 2021-01-28 | Brevard | Florida | 12009 | 28604 | 627 |
969443 | 969443 | 2021-01-27 | Brevard | Florida | 12009 | 28384 | 622 |
966199 | 966199 | 2021-01-26 | Brevard | Florida | 12009 | 28147 | 620 |
962954 | 962954 | 2021-01-25 | Brevard | Florida | 12009 | 27971 | 615 |
959709 | 959709 | 2021-01-24 | Brevard | Florida | 12009 | 27737 | 613 |
956463 | 956463 | 2021-01-23 | Brevard | Florida | 12009 | 27542 | 609 |
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);