ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 4013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277646 | 1277646 | 2021-05-02 | Maricopa | Arizona | 4013 | 538124 | 9882 |
1274399 | 1274399 | 2021-05-01 | Maricopa | Arizona | 4013 | 537899 | 9876 |
1271152 | 1271152 | 2021-04-30 | Maricopa | Arizona | 4013 | 537105 | 9875 |
1267905 | 1267905 | 2021-04-29 | Maricopa | Arizona | 4013 | 536453 | 9860 |
1264658 | 1264658 | 2021-04-28 | Maricopa | Arizona | 4013 | 535862 | 9847 |
1261411 | 1261411 | 2021-04-27 | Maricopa | Arizona | 4013 | 535436 | 9840 |
1258164 | 1258164 | 2021-04-26 | Maricopa | Arizona | 4013 | 534982 | 9836 |
1254917 | 1254917 | 2021-04-25 | Maricopa | Arizona | 4013 | 534430 | 9836 |
1251670 | 1251670 | 2021-04-24 | Maricopa | Arizona | 4013 | 533916 | 9829 |
1248423 | 1248423 | 2021-04-23 | Maricopa | Arizona | 4013 | 533368 | 9813 |
1245176 | 1245176 | 2021-04-22 | Maricopa | Arizona | 4013 | 532809 | 9803 |
1241929 | 1241929 | 2021-04-21 | Maricopa | Arizona | 4013 | 532522 | 9788 |
1238682 | 1238682 | 2021-04-20 | Maricopa | Arizona | 4013 | 532133 | 9787 |
1235435 | 1235435 | 2021-04-19 | Maricopa | Arizona | 4013 | 531673 | 9767 |
1232187 | 1232187 | 2021-04-18 | Maricopa | Arizona | 4013 | 531156 | 9767 |
1228939 | 1228939 | 2021-04-17 | Maricopa | Arizona | 4013 | 530598 | 9766 |
1225691 | 1225691 | 2021-04-16 | Maricopa | Arizona | 4013 | 530405 | 9769 |
1222444 | 1222444 | 2021-04-15 | Maricopa | Arizona | 4013 | 529722 | 9750 |
1219196 | 1219196 | 2021-04-14 | Maricopa | Arizona | 4013 | 529471 | 9741 |
1215948 | 1215948 | 2021-04-13 | Maricopa | Arizona | 4013 | 529271 | 9739 |
1212701 | 1212701 | 2021-04-12 | Maricopa | Arizona | 4013 | 528888 | 9728 |
1209452 | 1209452 | 2021-04-11 | Maricopa | Arizona | 4013 | 528377 | 9728 |
1206204 | 1206204 | 2021-04-10 | Maricopa | Arizona | 4013 | 528065 | 9733 |
1202956 | 1202956 | 2021-04-09 | Maricopa | Arizona | 4013 | 527566 | 9716 |
1199708 | 1199708 | 2021-04-08 | Maricopa | Arizona | 4013 | 527197 | 9711 |
1196459 | 1196459 | 2021-04-07 | Maricopa | Arizona | 4013 | 526890 | 9694 |
1193211 | 1193211 | 2021-04-06 | Maricopa | Arizona | 4013 | 526415 | 9670 |
1189961 | 1189961 | 2021-04-05 | Maricopa | Arizona | 4013 | 526070 | 9668 |
1186714 | 1186714 | 2021-04-04 | Maricopa | Arizona | 4013 | 525666 | 9668 |
1183467 | 1183467 | 2021-04-03 | Maricopa | Arizona | 4013 | 525361 | 9663 |
1180220 | 1180220 | 2021-04-02 | Maricopa | Arizona | 4013 | 525002 | 9670 |
1176973 | 1176973 | 2021-04-01 | Maricopa | Arizona | 4013 | 524547 | 9677 |
1173726 | 1173726 | 2021-03-31 | Maricopa | Arizona | 4013 | 524386 | 9673 |
1170479 | 1170479 | 2021-03-30 | Maricopa | Arizona | 4013 | 524077 | 9657 |
1167231 | 1167231 | 2021-03-29 | Maricopa | Arizona | 4013 | 523808 | 9644 |
1163983 | 1163983 | 2021-03-28 | Maricopa | Arizona | 4013 | 523424 | 9644 |
1160735 | 1160735 | 2021-03-27 | Maricopa | Arizona | 4013 | 523088 | 9640 |
1157487 | 1157487 | 2021-03-26 | Maricopa | Arizona | 4013 | 522624 | 9630 |
1154240 | 1154240 | 2021-03-25 | Maricopa | Arizona | 4013 | 522285 | 9619 |
1150993 | 1150993 | 2021-03-24 | Maricopa | Arizona | 4013 | 522323 | 9601 |
1147746 | 1147746 | 2021-03-23 | Maricopa | Arizona | 4013 | 521908 | 9571 |
1144499 | 1144499 | 2021-03-22 | Maricopa | Arizona | 4013 | 521585 | 9544 |
1141252 | 1141252 | 2021-03-21 | Maricopa | Arizona | 4013 | 521233 | 9544 |
1138006 | 1138006 | 2021-03-20 | Maricopa | Arizona | 4013 | 521072 | 9534 |
1134760 | 1134760 | 2021-03-19 | Maricopa | Arizona | 4013 | 520919 | 9512 |
1131512 | 1131512 | 2021-03-18 | Maricopa | Arizona | 4013 | 520784 | 9488 |
1128265 | 1128265 | 2021-03-17 | Maricopa | Arizona | 4013 | 521251 | 9449 |
1125019 | 1125019 | 2021-03-16 | Maricopa | Arizona | 4013 | 521093 | 9447 |
1121773 | 1121773 | 2021-03-15 | Maricopa | Arizona | 4013 | 520861 | 9437 |
1118526 | 1118526 | 2021-03-14 | Maricopa | Arizona | 4013 | 520487 | 9437 |
1115279 | 1115279 | 2021-03-13 | Maricopa | Arizona | 4013 | 520193 | 9432 |
1112033 | 1112033 | 2021-03-12 | Maricopa | Arizona | 4013 | 520291 | 9428 |
1108787 | 1108787 | 2021-03-11 | Maricopa | Arizona | 4013 | 519285 | 9393 |
1105541 | 1105541 | 2021-03-10 | Maricopa | Arizona | 4013 | 517726 | 9368 |
1102295 | 1102295 | 2021-03-09 | Maricopa | Arizona | 4013 | 517132 | 9312 |
1099049 | 1099049 | 2021-03-08 | Maricopa | Arizona | 4013 | 516720 | 9316 |
1095801 | 1095801 | 2021-03-07 | Maricopa | Arizona | 4013 | 516216 | 9316 |
1092555 | 1092555 | 2021-03-06 | Maricopa | Arizona | 4013 | 515211 | 9314 |
1089309 | 1089309 | 2021-03-05 | Maricopa | Arizona | 4013 | 514132 | 9286 |
1086064 | 1086064 | 2021-03-04 | Maricopa | Arizona | 4013 | 513035 | 9223 |
1082818 | 1082818 | 2021-03-03 | Maricopa | Arizona | 4013 | 512547 | 9172 |
1079572 | 1079572 | 2021-03-02 | Maricopa | Arizona | 4013 | 511806 | 9157 |
1076327 | 1076327 | 2021-03-01 | Maricopa | Arizona | 4013 | 511055 | 9116 |
1073081 | 1073081 | 2021-02-28 | Maricopa | Arizona | 4013 | 510360 | 9117 |
1069835 | 1069835 | 2021-02-27 | Maricopa | Arizona | 4013 | 509830 | 9107 |
1066590 | 1066590 | 2021-02-26 | Maricopa | Arizona | 4013 | 509314 | 9061 |
1063345 | 1063345 | 2021-02-25 | Maricopa | Arizona | 4013 | 508456 | 9005 |
1060100 | 1060100 | 2021-02-24 | Maricopa | Arizona | 4013 | 507719 | 8938 |
1056854 | 1056854 | 2021-02-23 | Maricopa | Arizona | 4013 | 507043 | 8910 |
1053608 | 1053608 | 2021-02-22 | Maricopa | Arizona | 4013 | 506046 | 8833 |
1050361 | 1050361 | 2021-02-21 | Maricopa | Arizona | 4013 | 504992 | 8835 |
1047114 | 1047114 | 2021-02-20 | Maricopa | Arizona | 4013 | 504383 | 8816 |
1043869 | 1043869 | 2021-02-19 | Maricopa | Arizona | 4013 | 503012 | 8783 |
1040624 | 1040624 | 2021-02-18 | Maricopa | Arizona | 4013 | 501792 | 8694 |
1037379 | 1037379 | 2021-02-17 | Maricopa | Arizona | 4013 | 500907 | 8580 |
1034134 | 1034134 | 2021-02-16 | Maricopa | Arizona | 4013 | 499865 | 8505 |
1030888 | 1030888 | 2021-02-15 | Maricopa | Arizona | 4013 | 499105 | 8505 |
1027641 | 1027641 | 2021-02-14 | Maricopa | Arizona | 4013 | 498297 | 8505 |
1024396 | 1024396 | 2021-02-13 | Maricopa | Arizona | 4013 | 497541 | 8487 |
1021151 | 1021151 | 2021-02-12 | Maricopa | Arizona | 4013 | 496426 | 8423 |
1017906 | 1017906 | 2021-02-11 | Maricopa | Arizona | 4013 | 495621 | 8334 |
1014661 | 1014661 | 2021-02-10 | Maricopa | Arizona | 4013 | 493720 | 8254 |
1011416 | 1011416 | 2021-02-09 | Maricopa | Arizona | 4013 | 492492 | 8125 |
1008170 | 1008170 | 2021-02-08 | Maricopa | Arizona | 4013 | 488687 | 7979 |
1004924 | 1004924 | 2021-02-07 | Maricopa | Arizona | 4013 | 487042 | 7971 |
1001678 | 1001678 | 2021-02-06 | Maricopa | Arizona | 4013 | 486922 | 7960 |
998432 | 998432 | 2021-02-05 | Maricopa | Arizona | 4013 | 484880 | 7902 |
995186 | 995186 | 2021-02-04 | Maricopa | Arizona | 4013 | 482845 | 7807 |
991940 | 991940 | 2021-02-03 | Maricopa | Arizona | 4013 | 479978 | 7689 |
988694 | 988694 | 2021-02-02 | Maricopa | Arizona | 4013 | 478097 | 7612 |
985447 | 985447 | 2021-02-01 | Maricopa | Arizona | 4013 | 475261 | 7462 |
982200 | 982200 | 2021-01-31 | Maricopa | Arizona | 4013 | 472760 | 7462 |
978954 | 978954 | 2021-01-30 | Maricopa | Arizona | 4013 | 471686 | 7455 |
975709 | 975709 | 2021-01-29 | Maricopa | Arizona | 4013 | 468090 | 7400 |
972464 | 972464 | 2021-01-28 | Maricopa | Arizona | 4013 | 465009 | 7313 |
969219 | 969219 | 2021-01-27 | Maricopa | Arizona | 4013 | 461280 | 7199 |
965975 | 965975 | 2021-01-26 | Maricopa | Arizona | 4013 | 457555 | 7094 |
962730 | 962730 | 2021-01-25 | Maricopa | Arizona | 4013 | 452925 | 6951 |
959485 | 959485 | 2021-01-24 | Maricopa | Arizona | 4013 | 449162 | 6950 |
956239 | 956239 | 2021-01-23 | Maricopa | Arizona | 4013 | 446652 | 6891 |
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);