ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 12097 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277914 | 1277914 | 2021-05-02 | Osceola | Florida | 12097 | 44302 | 500 |
1274667 | 1274667 | 2021-05-01 | Osceola | Florida | 12097 | 44174 | 500 |
1271420 | 1271420 | 2021-04-30 | Osceola | Florida | 12097 | 44050 | 500 |
1268173 | 1268173 | 2021-04-29 | Osceola | Florida | 12097 | 43924 | 499 |
1264926 | 1264926 | 2021-04-28 | Osceola | Florida | 12097 | 43772 | 498 |
1261679 | 1261679 | 2021-04-27 | Osceola | Florida | 12097 | 43628 | 498 |
1258432 | 1258432 | 2021-04-26 | Osceola | Florida | 12097 | 43483 | 499 |
1255185 | 1255185 | 2021-04-25 | Osceola | Florida | 12097 | 43380 | 496 |
1251938 | 1251938 | 2021-04-24 | Osceola | Florida | 12097 | 43243 | 496 |
1248691 | 1248691 | 2021-04-23 | Osceola | Florida | 12097 | 43053 | 496 |
1245444 | 1245444 | 2021-04-22 | Osceola | Florida | 12097 | 42927 | 496 |
1242197 | 1242197 | 2021-04-21 | Osceola | Florida | 12097 | 42717 | 496 |
1238950 | 1238950 | 2021-04-20 | Osceola | Florida | 12097 | 42584 | 492 |
1235703 | 1235703 | 2021-04-19 | Osceola | Florida | 12097 | 42430 | 492 |
1232456 | 1232456 | 2021-04-18 | Osceola | Florida | 12097 | 42317 | 492 |
1229207 | 1229207 | 2021-04-17 | Osceola | Florida | 12097 | 42145 | 492 |
1225959 | 1225959 | 2021-04-16 | Osceola | Florida | 12097 | 41984 | 490 |
1222712 | 1222712 | 2021-04-15 | Osceola | Florida | 12097 | 41829 | 490 |
1219464 | 1219464 | 2021-04-14 | Osceola | Florida | 12097 | 41633 | 490 |
1216216 | 1216216 | 2021-04-13 | Osceola | Florida | 12097 | 41438 | 489 |
1212969 | 1212969 | 2021-04-12 | Osceola | Florida | 12097 | 41191 | 489 |
1209721 | 1209721 | 2021-04-11 | Osceola | Florida | 12097 | 41144 | 489 |
1206472 | 1206472 | 2021-04-10 | Osceola | Florida | 12097 | 41004 | 489 |
1203224 | 1203224 | 2021-04-09 | Osceola | Florida | 12097 | 40844 | 488 |
1199976 | 1199976 | 2021-04-08 | Osceola | Florida | 12097 | 40666 | 488 |
1196727 | 1196727 | 2021-04-07 | Osceola | Florida | 12097 | 40496 | 487 |
1193479 | 1193479 | 2021-04-06 | Osceola | Florida | 12097 | 40362 | 487 |
1190229 | 1190229 | 2021-04-05 | Osceola | Florida | 12097 | 40214 | 487 |
1186982 | 1186982 | 2021-04-04 | Osceola | Florida | 12097 | 40121 | 487 |
1183735 | 1183735 | 2021-04-03 | Osceola | Florida | 12097 | 40024 | 487 |
1180488 | 1180488 | 2021-04-02 | Osceola | Florida | 12097 | 39905 | 487 |
1177241 | 1177241 | 2021-04-01 | Osceola | Florida | 12097 | 39766 | 487 |
1173994 | 1173994 | 2021-03-31 | Osceola | Florida | 12097 | 39604 | 485 |
1170747 | 1170747 | 2021-03-30 | Osceola | Florida | 12097 | 39521 | 484 |
1167499 | 1167499 | 2021-03-29 | Osceola | Florida | 12097 | 39411 | 482 |
1164251 | 1164251 | 2021-03-28 | Osceola | Florida | 12097 | 39356 | 481 |
1161003 | 1161003 | 2021-03-27 | Osceola | Florida | 12097 | 39271 | 481 |
1157755 | 1157755 | 2021-03-26 | Osceola | Florida | 12097 | 39174 | 481 |
1154508 | 1154508 | 2021-03-25 | Osceola | Florida | 12097 | 39075 | 479 |
1151261 | 1151261 | 2021-03-24 | Osceola | Florida | 12097 | 38968 | 473 |
1148014 | 1148014 | 2021-03-23 | Osceola | Florida | 12097 | 38843 | 473 |
1144767 | 1144767 | 2021-03-22 | Osceola | Florida | 12097 | 38723 | 473 |
1141520 | 1141520 | 2021-03-21 | Osceola | Florida | 12097 | 38661 | 473 |
1138274 | 1138274 | 2021-03-20 | Osceola | Florida | 12097 | 38577 | 473 |
1135028 | 1135028 | 2021-03-19 | Osceola | Florida | 12097 | 38476 | 473 |
1131781 | 1131781 | 2021-03-18 | Osceola | Florida | 12097 | 38381 | 471 |
1128533 | 1128533 | 2021-03-17 | Osceola | Florida | 12097 | 38283 | 471 |
1125287 | 1125287 | 2021-03-16 | Osceola | Florida | 12097 | 38205 | 470 |
1122041 | 1122041 | 2021-03-15 | Osceola | Florida | 12097 | 38116 | 470 |
1118794 | 1118794 | 2021-03-14 | Osceola | Florida | 12097 | 38078 | 467 |
1115547 | 1115547 | 2021-03-13 | Osceola | Florida | 12097 | 38007 | 467 |
1112301 | 1112301 | 2021-03-12 | Osceola | Florida | 12097 | 37892 | 465 |
1109055 | 1109055 | 2021-03-11 | Osceola | Florida | 12097 | 37814 | 462 |
1105809 | 1105809 | 2021-03-10 | Osceola | Florida | 12097 | 37724 | 460 |
1102563 | 1102563 | 2021-03-09 | Osceola | Florida | 12097 | 37634 | 461 |
1099317 | 1099317 | 2021-03-08 | Osceola | Florida | 12097 | 37566 | 461 |
1096069 | 1096069 | 2021-03-07 | Osceola | Florida | 12097 | 37497 | 459 |
1092823 | 1092823 | 2021-03-06 | Osceola | Florida | 12097 | 37413 | 453 |
1089577 | 1089577 | 2021-03-05 | Osceola | Florida | 12097 | 37291 | 453 |
1086332 | 1086332 | 2021-03-04 | Osceola | Florida | 12097 | 37188 | 449 |
1083086 | 1083086 | 2021-03-03 | Osceola | Florida | 12097 | 37045 | 447 |
1079840 | 1079840 | 2021-03-02 | Osceola | Florida | 12097 | 36981 | 448 |
1076595 | 1076595 | 2021-03-01 | Osceola | Florida | 12097 | 36839 | 448 |
1073349 | 1073349 | 2021-02-28 | Osceola | Florida | 12097 | 36802 | 444 |
1070103 | 1070103 | 2021-02-27 | Osceola | Florida | 12097 | 36713 | 441 |
1066858 | 1066858 | 2021-02-26 | Osceola | Florida | 12097 | 36607 | 441 |
1063613 | 1063613 | 2021-02-25 | Osceola | Florida | 12097 | 36521 | 435 |
1060368 | 1060368 | 2021-02-24 | Osceola | Florida | 12097 | 36387 | 433 |
1057122 | 1057122 | 2021-02-23 | Osceola | Florida | 12097 | 36271 | 431 |
1053876 | 1053876 | 2021-02-22 | Osceola | Florida | 12097 | 36168 | 432 |
1050629 | 1050629 | 2021-02-21 | Osceola | Florida | 12097 | 36097 | 425 |
1047382 | 1047382 | 2021-02-20 | Osceola | Florida | 12097 | 35997 | 425 |
1044137 | 1044137 | 2021-02-19 | Osceola | Florida | 12097 | 35849 | 417 |
1040892 | 1040892 | 2021-02-18 | Osceola | Florida | 12097 | 35753 | 416 |
1037647 | 1037647 | 2021-02-17 | Osceola | Florida | 12097 | 35689 | 414 |
1034402 | 1034402 | 2021-02-16 | Osceola | Florida | 12097 | 35576 | 412 |
1031156 | 1031156 | 2021-02-15 | Osceola | Florida | 12097 | 35429 | 402 |
1027909 | 1027909 | 2021-02-14 | Osceola | Florida | 12097 | 35394 | 400 |
1024664 | 1024664 | 2021-02-13 | Osceola | Florida | 12097 | 35276 | 400 |
1021419 | 1021419 | 2021-02-12 | Osceola | Florida | 12097 | 35150 | 400 |
1018174 | 1018174 | 2021-02-11 | Osceola | Florida | 12097 | 35033 | 399 |
1014929 | 1014929 | 2021-02-10 | Osceola | Florida | 12097 | 34927 | 396 |
1011684 | 1011684 | 2021-02-09 | Osceola | Florida | 12097 | 34796 | 396 |
1008438 | 1008438 | 2021-02-08 | Osceola | Florida | 12097 | 34686 | 384 |
1005192 | 1005192 | 2021-02-07 | Osceola | Florida | 12097 | 34543 | 384 |
1001946 | 1001946 | 2021-02-06 | Osceola | Florida | 12097 | 34413 | 384 |
998700 | 998700 | 2021-02-05 | Osceola | Florida | 12097 | 34315 | 384 |
995454 | 995454 | 2021-02-04 | Osceola | Florida | 12097 | 34099 | 385 |
992208 | 992208 | 2021-02-03 | Osceola | Florida | 12097 | 33993 | 379 |
988962 | 988962 | 2021-02-02 | Osceola | Florida | 12097 | 33890 | 380 |
985715 | 985715 | 2021-02-01 | Osceola | Florida | 12097 | 33722 | 381 |
982468 | 982468 | 2021-01-31 | Osceola | Florida | 12097 | 33608 | 374 |
979222 | 979222 | 2021-01-30 | Osceola | Florida | 12097 | 33447 | 374 |
975977 | 975977 | 2021-01-29 | Osceola | Florida | 12097 | 33174 | 370 |
972732 | 972732 | 2021-01-28 | Osceola | Florida | 12097 | 32977 | 358 |
969487 | 969487 | 2021-01-27 | Osceola | Florida | 12097 | 32760 | 357 |
966243 | 966243 | 2021-01-26 | Osceola | Florida | 12097 | 32599 | 356 |
962998 | 962998 | 2021-01-25 | Osceola | Florida | 12097 | 32427 | 343 |
959753 | 959753 | 2021-01-24 | Osceola | Florida | 12097 | 32273 | 334 |
956507 | 956507 | 2021-01-23 | Osceola | Florida | 12097 | 32033 | 334 |
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);