ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Brazoria" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280186 | 1280186 | 2021-05-02 | Brazoria | Texas | 48039 | 37266 | 488 |
1276939 | 1276939 | 2021-05-01 | Brazoria | Texas | 48039 | 37266 | 488 |
1273692 | 1273692 | 2021-04-30 | Brazoria | Texas | 48039 | 37188 | 487 |
1270445 | 1270445 | 2021-04-29 | Brazoria | Texas | 48039 | 37139 | 487 |
1267198 | 1267198 | 2021-04-28 | Brazoria | Texas | 48039 | 37062 | 486 |
1263951 | 1263951 | 2021-04-27 | Brazoria | Texas | 48039 | 37046 | 483 |
1260704 | 1260704 | 2021-04-26 | Brazoria | Texas | 48039 | 36992 | 482 |
1257457 | 1257457 | 2021-04-25 | Brazoria | Texas | 48039 | 36958 | 482 |
1254210 | 1254210 | 2021-04-24 | Brazoria | Texas | 48039 | 36895 | 481 |
1250963 | 1250963 | 2021-04-23 | Brazoria | Texas | 48039 | 36880 | 480 |
1247716 | 1247716 | 2021-04-22 | Brazoria | Texas | 48039 | 36811 | 478 |
1244469 | 1244469 | 2021-04-21 | Brazoria | Texas | 48039 | 36775 | 477 |
1241222 | 1241222 | 2021-04-20 | Brazoria | Texas | 48039 | 36694 | 474 |
1237975 | 1237975 | 2021-04-19 | Brazoria | Texas | 48039 | 36650 | 473 |
1234728 | 1234728 | 2021-04-18 | Brazoria | Texas | 48039 | 36587 | 472 |
1231480 | 1231480 | 2021-04-17 | Brazoria | Texas | 48039 | 36473 | 473 |
1228232 | 1228232 | 2021-04-16 | Brazoria | Texas | 48039 | 36473 | 469 |
1224984 | 1224984 | 2021-04-15 | Brazoria | Texas | 48039 | 36422 | 468 |
1221737 | 1221737 | 2021-04-14 | Brazoria | Texas | 48039 | 36374 | 468 |
1218489 | 1218489 | 2021-04-13 | Brazoria | Texas | 48039 | 36323 | 467 |
1215241 | 1215241 | 2021-04-12 | Brazoria | Texas | 48039 | 36222 | 465 |
1211994 | 1211994 | 2021-04-11 | Brazoria | Texas | 48039 | 36152 | 465 |
1208745 | 1208745 | 2021-04-10 | Brazoria | Texas | 48039 | 36134 | 465 |
1205497 | 1205497 | 2021-04-09 | Brazoria | Texas | 48039 | 36043 | 463 |
1202249 | 1202249 | 2021-04-08 | Brazoria | Texas | 48039 | 35970 | 460 |
1199000 | 1199000 | 2021-04-07 | Brazoria | Texas | 48039 | 35918 | 458 |
1195751 | 1195751 | 2021-04-06 | Brazoria | Texas | 48039 | 35749 | 457 |
1192503 | 1192503 | 2021-04-05 | Brazoria | Texas | 48039 | 35737 | 454 |
1189254 | 1189254 | 2021-04-04 | Brazoria | Texas | 48039 | 35737 | 454 |
1186007 | 1186007 | 2021-04-03 | Brazoria | Texas | 48039 | 35605 | 454 |
1182760 | 1182760 | 2021-04-02 | Brazoria | Texas | 48039 | 35604 | 453 |
1179513 | 1179513 | 2021-04-01 | Brazoria | Texas | 48039 | 35579 | 453 |
1176266 | 1176266 | 2021-03-31 | Brazoria | Texas | 48039 | 35505 | 449 |
1173019 | 1173019 | 2021-03-30 | Brazoria | Texas | 48039 | 35462 | 447 |
1169772 | 1169772 | 2021-03-29 | Brazoria | Texas | 48039 | 35387 | 445 |
1166524 | 1166524 | 2021-03-28 | Brazoria | Texas | 48039 | 35320 | 445 |
1163276 | 1163276 | 2021-03-27 | Brazoria | Texas | 48039 | 35288 | 445 |
1160027 | 1160027 | 2021-03-26 | Brazoria | Texas | 48039 | 35190 | 444 |
1156780 | 1156780 | 2021-03-25 | Brazoria | Texas | 48039 | 35107 | 443 |
1153533 | 1153533 | 2021-03-24 | Brazoria | Texas | 48039 | 35039 | 438 |
1150286 | 1150286 | 2021-03-23 | Brazoria | Texas | 48039 | 34979 | 434 |
1147039 | 1147039 | 2021-03-22 | Brazoria | Texas | 48039 | 34803 | 429 |
1143792 | 1143792 | 2021-03-21 | Brazoria | Texas | 48039 | 34803 | 428 |
1140545 | 1140545 | 2021-03-20 | Brazoria | Texas | 48039 | 34691 | 427 |
1137299 | 1137299 | 2021-03-19 | Brazoria | Texas | 48039 | 34629 | 424 |
1134053 | 1134053 | 2021-03-18 | Brazoria | Texas | 48039 | 34584 | 424 |
1130805 | 1130805 | 2021-03-17 | Brazoria | Texas | 48039 | 34515 | 421 |
1127558 | 1127558 | 2021-03-16 | Brazoria | Texas | 48039 | 34426 | 415 |
1124312 | 1124312 | 2021-03-15 | Brazoria | Texas | 48039 | 34373 | 411 |
1121066 | 1121066 | 2021-03-14 | Brazoria | Texas | 48039 | 34301 | 411 |
1117819 | 1117819 | 2021-03-13 | Brazoria | Texas | 48039 | 34221 | 411 |
1114572 | 1114572 | 2021-03-12 | Brazoria | Texas | 48039 | 34102 | 406 |
1111326 | 1111326 | 2021-03-11 | Brazoria | Texas | 48039 | 34030 | 405 |
1108080 | 1108080 | 2021-03-10 | Brazoria | Texas | 48039 | 33943 | 402 |
1104834 | 1104834 | 2021-03-09 | Brazoria | Texas | 48039 | 33839 | 399 |
1101588 | 1101588 | 2021-03-08 | Brazoria | Texas | 48039 | 33698 | 397 |
1098342 | 1098342 | 2021-03-07 | Brazoria | Texas | 48039 | 33669 | 397 |
1095094 | 1095094 | 2021-03-06 | Brazoria | Texas | 48039 | 33450 | 396 |
1091848 | 1091848 | 2021-03-05 | Brazoria | Texas | 48039 | 33450 | 394 |
1088602 | 1088602 | 2021-03-04 | Brazoria | Texas | 48039 | 33169 | 391 |
1085357 | 1085357 | 2021-03-03 | Brazoria | Texas | 48039 | 33152 | 387 |
1082111 | 1082111 | 2021-03-02 | Brazoria | Texas | 48039 | 33040 | 383 |
1078865 | 1078865 | 2021-03-01 | Brazoria | Texas | 48039 | 32966 | 380 |
1075620 | 1075620 | 2021-02-28 | Brazoria | Texas | 48039 | 32834 | 380 |
1072374 | 1072374 | 2021-02-27 | Brazoria | Texas | 48039 | 32645 | 377 |
1069128 | 1069128 | 2021-02-26 | Brazoria | Texas | 48039 | 32573 | 375 |
1065883 | 1065883 | 2021-02-25 | Brazoria | Texas | 48039 | 32289 | 371 |
1062638 | 1062638 | 2021-02-24 | Brazoria | Texas | 48039 | 32134 | 368 |
1059393 | 1059393 | 2021-02-23 | Brazoria | Texas | 48039 | 32047 | 361 |
1056147 | 1056147 | 2021-02-22 | Brazoria | Texas | 48039 | 31400 | 360 |
1052901 | 1052901 | 2021-02-21 | Brazoria | Texas | 48039 | 31400 | 359 |
1049654 | 1049654 | 2021-02-20 | Brazoria | Texas | 48039 | 31367 | 357 |
1046407 | 1046407 | 2021-02-19 | Brazoria | Texas | 48039 | 31331 | 353 |
1043162 | 1043162 | 2021-02-18 | Brazoria | Texas | 48039 | 31212 | 351 |
1039917 | 1039917 | 2021-02-17 | Brazoria | Texas | 48039 | 31212 | 351 |
1036672 | 1036672 | 2021-02-16 | Brazoria | Texas | 48039 | 31225 | 351 |
1033427 | 1033427 | 2021-02-15 | Brazoria | Texas | 48039 | 31127 | 350 |
1030181 | 1030181 | 2021-02-14 | Brazoria | Texas | 48039 | 31012 | 349 |
1026934 | 1026934 | 2021-02-13 | Brazoria | Texas | 48039 | 30797 | 349 |
1023689 | 1023689 | 2021-02-12 | Brazoria | Texas | 48039 | 30675 | 344 |
1020444 | 1020444 | 2021-02-11 | Brazoria | Texas | 48039 | 30658 | 342 |
1017199 | 1017199 | 2021-02-10 | Brazoria | Texas | 48039 | 30364 | 339 |
1013954 | 1013954 | 2021-02-09 | Brazoria | Texas | 48039 | 30201 | 335 |
1010709 | 1010709 | 2021-02-08 | Brazoria | Texas | 48039 | 30155 | 333 |
1007463 | 1007463 | 2021-02-07 | Brazoria | Texas | 48039 | 29985 | 332 |
1004217 | 1004217 | 2021-02-06 | Brazoria | Texas | 48039 | 29833 | 331 |
1000971 | 1000971 | 2021-02-05 | Brazoria | Texas | 48039 | 29664 | 328 |
997725 | 997725 | 2021-02-04 | Brazoria | Texas | 48039 | 29361 | 323 |
994479 | 994479 | 2021-02-03 | Brazoria | Texas | 48039 | 29104 | 318 |
991233 | 991233 | 2021-02-02 | Brazoria | Texas | 48039 | 28901 | 311 |
987987 | 987987 | 2021-02-01 | Brazoria | Texas | 48039 | 28688 | 309 |
984740 | 984740 | 2021-01-31 | Brazoria | Texas | 48039 | 28599 | 308 |
981493 | 981493 | 2021-01-30 | Brazoria | Texas | 48039 | 28430 | 306 |
978247 | 978247 | 2021-01-29 | Brazoria | Texas | 48039 | 28149 | 304 |
975002 | 975002 | 2021-01-28 | Brazoria | Texas | 48039 | 27787 | 303 |
971757 | 971757 | 2021-01-27 | Brazoria | Texas | 48039 | 27709 | 299 |
968512 | 968512 | 2021-01-26 | Brazoria | Texas | 48039 | 27615 | 292 |
965268 | 965268 | 2021-01-25 | Brazoria | Texas | 48039 | 27177 | 288 |
962023 | 962023 | 2021-01-24 | Brazoria | Texas | 48039 | 27177 | 288 |
958778 | 958778 | 2021-01-23 | Brazoria | Texas | 48039 | 26884 | 287 |
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);