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 |
---|---|---|---|---|---|---|---|
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 |
955569 | 955569 | 2021-01-22 | Dallas | Texas | 48113 | 243726 | 2581 |
952324 | 952324 | 2021-01-21 | Dallas | Texas | 48113 | 241661 | 2544 |
949079 | 949079 | 2021-01-20 | Dallas | Texas | 48113 | 239683 | 2501 |
945833 | 945833 | 2021-01-19 | Dallas | Texas | 48113 | 236214 | 2453 |
942586 | 942586 | 2021-01-18 | Dallas | Texas | 48113 | 234625 | 2431 |
939341 | 939341 | 2021-01-17 | Dallas | Texas | 48113 | 234625 | 2425 |
936096 | 936096 | 2021-01-16 | Dallas | Texas | 48113 | 233248 | 2397 |
932851 | 932851 | 2021-01-15 | Dallas | Texas | 48113 | 230439 | 2362 |
929606 | 929606 | 2021-01-14 | Dallas | Texas | 48113 | 227622 | 2333 |
926361 | 926361 | 2021-01-13 | Dallas | Texas | 48113 | 225629 | 2301 |
923115 | 923115 | 2021-01-12 | Dallas | Texas | 48113 | 222635 | 2268 |
919870 | 919870 | 2021-01-11 | Dallas | Texas | 48113 | 219086 | 2242 |
916625 | 916625 | 2021-01-10 | Dallas | Texas | 48113 | 217219 | 2239 |
913380 | 913380 | 2021-01-09 | Dallas | Texas | 48113 | 214973 | 2220 |
910135 | 910135 | 2021-01-08 | Dallas | Texas | 48113 | 211779 | 2188 |
906890 | 906890 | 2021-01-07 | Dallas | Texas | 48113 | 209392 | 2151 |
903644 | 903644 | 2021-01-06 | Dallas | Texas | 48113 | 206802 | 2117 |
900399 | 900399 | 2021-01-05 | Dallas | Texas | 48113 | 204374 | 2087 |
897154 | 897154 | 2021-01-04 | Dallas | Texas | 48113 | 201581 | 2058 |
893908 | 893908 | 2021-01-03 | Dallas | Texas | 48113 | 200011 | 2049 |
890662 | 890662 | 2021-01-02 | Dallas | Texas | 48113 | 196160 | 2042 |
887415 | 887415 | 2021-01-01 | Dallas | Texas | 48113 | 193318 | 2033 |
884170 | 884170 | 2020-12-31 | Dallas | Texas | 48113 | 193318 | 2007 |
880925 | 880925 | 2020-12-30 | Dallas | Texas | 48113 | 191544 | 1971 |
877680 | 877680 | 2020-12-29 | Dallas | Texas | 48113 | 189252 | 1955 |
874435 | 874435 | 2020-12-28 | Dallas | Texas | 48113 | 188123 | 1936 |
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);