ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Dallas" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280223 | 1280223 | 2021-05-02 | Dallas | Texas | 48113 | 298959 | 3985 |
1276976 | 1276976 | 2021-05-01 | Dallas | Texas | 48113 | 298791 | 3985 |
1273729 | 1273729 | 2021-04-30 | Dallas | Texas | 48113 | 298430 | 3976 |
1270482 | 1270482 | 2021-04-29 | Dallas | Texas | 48113 | 298162 | 3972 |
1267235 | 1267235 | 2021-04-28 | Dallas | Texas | 48113 | 297812 | 3969 |
1263988 | 1263988 | 2021-04-27 | Dallas | Texas | 48113 | 297637 | 3965 |
1260741 | 1260741 | 2021-04-26 | Dallas | Texas | 48113 | 297315 | 3958 |
1257494 | 1257494 | 2021-04-25 | Dallas | Texas | 48113 | 297315 | 3956 |
1254247 | 1254247 | 2021-04-24 | Dallas | Texas | 48113 | 297012 | 3956 |
1251000 | 1251000 | 2021-04-23 | Dallas | Texas | 48113 | 296831 | 3953 |
1247753 | 1247753 | 2021-04-22 | Dallas | Texas | 48113 | 296606 | 3951 |
1244506 | 1244506 | 2021-04-21 | Dallas | Texas | 48113 | 296327 | 3951 |
1241259 | 1241259 | 2021-04-20 | Dallas | Texas | 48113 | 296045 | 3946 |
1238012 | 1238012 | 2021-04-19 | Dallas | Texas | 48113 | 295543 | 3940 |
1234765 | 1234765 | 2021-04-18 | Dallas | Texas | 48113 | 295543 | 3937 |
1231517 | 1231517 | 2021-04-17 | Dallas | Texas | 48113 | 295543 | 3933 |
1228269 | 1228269 | 2021-04-16 | Dallas | Texas | 48113 | 295251 | 3926 |
1225021 | 1225021 | 2021-04-15 | Dallas | Texas | 48113 | 295099 | 3922 |
1221774 | 1221774 | 2021-04-14 | Dallas | Texas | 48113 | 294897 | 3919 |
1218526 | 1218526 | 2021-04-13 | Dallas | Texas | 48113 | 294612 | 3914 |
1215278 | 1215278 | 2021-04-12 | Dallas | Texas | 48113 | 293934 | 3914 |
1212031 | 1212031 | 2021-04-11 | Dallas | Texas | 48113 | 293934 | 3914 |
1208782 | 1208782 | 2021-04-10 | Dallas | Texas | 48113 | 293934 | 3911 |
1205534 | 1205534 | 2021-04-09 | Dallas | Texas | 48113 | 293659 | 3908 |
1202286 | 1202286 | 2021-04-08 | Dallas | Texas | 48113 | 293150 | 3899 |
1199037 | 1199037 | 2021-04-07 | Dallas | Texas | 48113 | 293121 | 3896 |
1195788 | 1195788 | 2021-04-06 | Dallas | Texas | 48113 | 292743 | 3894 |
1192540 | 1192540 | 2021-04-05 | Dallas | Texas | 48113 | 292364 | 3886 |
1189291 | 1189291 | 2021-04-04 | Dallas | Texas | 48113 | 292153 | 3886 |
1186044 | 1186044 | 2021-04-03 | Dallas | Texas | 48113 | 292153 | 3885 |
1182797 | 1182797 | 2021-04-02 | Dallas | Texas | 48113 | 291859 | 3881 |
1179550 | 1179550 | 2021-04-01 | Dallas | Texas | 48113 | 291589 | 3869 |
1176303 | 1176303 | 2021-03-31 | Dallas | Texas | 48113 | 291262 | 3864 |
1173056 | 1173056 | 2021-03-30 | Dallas | Texas | 48113 | 290898 | 3849 |
1169809 | 1169809 | 2021-03-29 | Dallas | Texas | 48113 | 290617 | 3838 |
1166561 | 1166561 | 2021-03-28 | Dallas | Texas | 48113 | 290108 | 3836 |
1163313 | 1163313 | 2021-03-27 | Dallas | Texas | 48113 | 290108 | 3826 |
1160064 | 1160064 | 2021-03-26 | Dallas | Texas | 48113 | 289796 | 3821 |
1156817 | 1156817 | 2021-03-25 | Dallas | Texas | 48113 | 289494 | 3804 |
1153570 | 1153570 | 2021-03-24 | Dallas | Texas | 48113 | 289198 | 3793 |
1150323 | 1150323 | 2021-03-23 | Dallas | Texas | 48113 | 288928 | 3783 |
1147076 | 1147076 | 2021-03-22 | Dallas | Texas | 48113 | 288700 | 3776 |
1143829 | 1143829 | 2021-03-21 | Dallas | Texas | 48113 | 288216 | 3763 |
1140582 | 1140582 | 2021-03-20 | Dallas | Texas | 48113 | 288216 | 3757 |
1137336 | 1137336 | 2021-03-19 | Dallas | Texas | 48113 | 287989 | 3751 |
1134090 | 1134090 | 2021-03-18 | Dallas | Texas | 48113 | 287641 | 3728 |
1130842 | 1130842 | 2021-03-17 | Dallas | Texas | 48113 | 287451 | 3713 |
1127595 | 1127595 | 2021-03-16 | Dallas | Texas | 48113 | 287236 | 3701 |
1124349 | 1124349 | 2021-03-15 | Dallas | Texas | 48113 | 286925 | 3688 |
1121103 | 1121103 | 2021-03-14 | Dallas | Texas | 48113 | 286351 | 3678 |
1117856 | 1117856 | 2021-03-13 | Dallas | Texas | 48113 | 286351 | 3672 |
1114609 | 1114609 | 2021-03-12 | Dallas | Texas | 48113 | 286084 | 3655 |
1111363 | 1111363 | 2021-03-11 | Dallas | Texas | 48113 | 285683 | 3631 |
1108117 | 1108117 | 2021-03-10 | Dallas | Texas | 48113 | 285332 | 3613 |
1104871 | 1104871 | 2021-03-09 | Dallas | Texas | 48113 | 284935 | 3576 |
1101625 | 1101625 | 2021-03-08 | Dallas | Texas | 48113 | 284010 | 3556 |
1098379 | 1098379 | 2021-03-07 | Dallas | Texas | 48113 | 284010 | 3549 |
1095131 | 1095131 | 2021-03-06 | Dallas | Texas | 48113 | 284010 | 3547 |
1091885 | 1091885 | 2021-03-05 | Dallas | Texas | 48113 | 283638 | 3521 |
1088639 | 1088639 | 2021-03-04 | Dallas | Texas | 48113 | 283180 | 3505 |
1085394 | 1085394 | 2021-03-03 | Dallas | Texas | 48113 | 282399 | 3477 |
1082148 | 1082148 | 2021-03-02 | Dallas | Texas | 48113 | 281681 | 3453 |
1078902 | 1078902 | 2021-03-01 | Dallas | Texas | 48113 | 281155 | 3425 |
1075657 | 1075657 | 2021-02-28 | Dallas | Texas | 48113 | 280404 | 3406 |
1072411 | 1072411 | 2021-02-27 | Dallas | Texas | 48113 | 280404 | 3388 |
1069165 | 1069165 | 2021-02-26 | Dallas | Texas | 48113 | 279834 | 3379 |
1065920 | 1065920 | 2021-02-25 | Dallas | Texas | 48113 | 279108 | 3356 |
1062675 | 1062675 | 2021-02-24 | Dallas | Texas | 48113 | 278494 | 3329 |
1059430 | 1059430 | 2021-02-23 | Dallas | Texas | 48113 | 277705 | 3301 |
1056184 | 1056184 | 2021-02-22 | Dallas | Texas | 48113 | 276945 | 3275 |
1052938 | 1052938 | 2021-02-21 | Dallas | Texas | 48113 | 276945 | 3272 |
1049691 | 1049691 | 2021-02-20 | Dallas | Texas | 48113 | 276672 | 3259 |
1046444 | 1046444 | 2021-02-19 | Dallas | Texas | 48113 | 276339 | 3236 |
1043199 | 1043199 | 2021-02-18 | Dallas | Texas | 48113 | 276049 | 3219 |
1039954 | 1039954 | 2021-02-17 | Dallas | Texas | 48113 | 275783 | 3213 |
1036709 | 1036709 | 2021-02-16 | Dallas | Texas | 48113 | 275400 | 3207 |
1033464 | 1033464 | 2021-02-15 | Dallas | Texas | 48113 | 274425 | 3198 |
1030218 | 1030218 | 2021-02-14 | Dallas | Texas | 48113 | 274425 | 3185 |
1026971 | 1026971 | 2021-02-13 | Dallas | Texas | 48113 | 273540 | 3165 |
1023726 | 1023726 | 2021-02-12 | Dallas | Texas | 48113 | 272661 | 3123 |
1020481 | 1020481 | 2021-02-11 | Dallas | Texas | 48113 | 271816 | 3100 |
1017236 | 1017236 | 2021-02-10 | Dallas | Texas | 48113 | 270796 | 3072 |
1013991 | 1013991 | 2021-02-09 | Dallas | Texas | 48113 | 269565 | 3045 |
1010746 | 1010746 | 2021-02-08 | Dallas | Texas | 48113 | 268262 | 3019 |
1007500 | 1007500 | 2021-02-07 | Dallas | Texas | 48113 | 267354 | 3016 |
1004254 | 1004254 | 2021-02-06 | Dallas | Texas | 48113 | 266335 | 3007 |
1001008 | 1001008 | 2021-02-05 | Dallas | Texas | 48113 | 265311 | 2975 |
997762 | 997762 | 2021-02-04 | Dallas | Texas | 48113 | 263887 | 2931 |
994516 | 994516 | 2021-02-03 | Dallas | Texas | 48113 | 262738 | 2885 |
991270 | 991270 | 2021-02-02 | Dallas | Texas | 48113 | 261382 | 2847 |
988024 | 988024 | 2021-02-01 | Dallas | Texas | 48113 | 259944 | 2824 |
984777 | 984777 | 2021-01-31 | Dallas | Texas | 48113 | 258517 | 2819 |
981530 | 981530 | 2021-01-30 | Dallas | Texas | 48113 | 256900 | 2804 |
978284 | 978284 | 2021-01-29 | Dallas | Texas | 48113 | 255493 | 2772 |
975039 | 975039 | 2021-01-28 | Dallas | Texas | 48113 | 253684 | 2748 |
971794 | 971794 | 2021-01-27 | Dallas | Texas | 48113 | 252047 | 2715 |
968549 | 968549 | 2021-01-26 | Dallas | Texas | 48113 | 250376 | 2673 |
965305 | 965305 | 2021-01-25 | Dallas | Texas | 48113 | 248518 | 2637 |
962060 | 962060 | 2021-01-24 | Dallas | Texas | 48113 | 246820 | 2629 |
958815 | 958815 | 2021-01-23 | Dallas | Texas | 48113 | 245646 | 2614 |
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);