ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where county = "Warren" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- Tennessee 13
- Indiana 11
- Missouri 8
- Illinois 7
- Georgia 5
- Iowa 3
- Kentucky 3
- New Jersey 3
- Ohio 2
- Virginia 2
- Mississippi 1
- New York 1
- North Carolina 1
- Pennsylvania 1
fips 14
county 1
- Warren · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
818906 | 818906 | 2020-12-11 | Warren | Pennsylvania | 42123 | 718 | 3 |
771940 | 771940 | 2020-11-27 | Warren | Indiana | 18171 | 258 | 3 |
768695 | 768695 | 2020-11-26 | Warren | Indiana | 18171 | 256 | 3 |
765449 | 765449 | 2020-11-25 | Warren | Indiana | 18171 | 240 | 3 |
762204 | 762204 | 2020-11-24 | Warren | Indiana | 18171 | 240 | 3 |
758959 | 758959 | 2020-11-23 | Warren | Indiana | 18171 | 237 | 3 |
755712 | 755712 | 2020-11-22 | Warren | Indiana | 18171 | 229 | 3 |
752466 | 752466 | 2020-11-21 | Warren | Indiana | 18171 | 226 | 3 |
749220 | 749220 | 2020-11-20 | Warren | Indiana | 18171 | 218 | 3 |
745974 | 745974 | 2020-11-19 | Warren | Indiana | 18171 | 203 | 3 |
742727 | 742727 | 2020-11-18 | Warren | Indiana | 18171 | 195 | 3 |
739480 | 739480 | 2020-11-17 | Warren | Indiana | 18171 | 187 | 3 |
698132 | 698132 | 2020-11-04 | Warren | Missouri | 29219 | 898 | 3 |
694889 | 694889 | 2020-11-03 | Warren | Missouri | 29219 | 878 | 3 |
691647 | 691647 | 2020-11-02 | Warren | Missouri | 29219 | 856 | 3 |
688402 | 688402 | 2020-11-01 | Warren | Missouri | 29219 | 841 | 3 |
685158 | 685158 | 2020-10-31 | Warren | Missouri | 29219 | 832 | 3 |
681915 | 681915 | 2020-10-30 | Warren | Missouri | 29219 | 822 | 3 |
678671 | 678671 | 2020-10-29 | Warren | Missouri | 29219 | 796 | 3 |
675429 | 675429 | 2020-10-28 | Warren | Missouri | 29219 | 780 | 3 |
609634 | 609634 | 2020-10-08 | Warren | Illinois | 17187 | 373 | 3 |
606391 | 606391 | 2020-10-07 | Warren | Illinois | 17187 | 369 | 3 |
603149 | 603149 | 2020-10-06 | Warren | Illinois | 17187 | 363 | 3 |
599906 | 599906 | 2020-10-05 | Warren | Illinois | 17187 | 357 | 3 |
596664 | 596664 | 2020-10-04 | Warren | Illinois | 17187 | 354 | 3 |
593422 | 593422 | 2020-10-03 | Warren | Illinois | 17187 | 351 | 3 |
590181 | 590181 | 2020-10-02 | Warren | Illinois | 17187 | 343 | 3 |
463821 | 463821 | 2020-08-24 | Warren | Georgia | 13301 | 110 | 3 |
460592 | 460592 | 2020-08-23 | Warren | Georgia | 13301 | 110 | 3 |
457365 | 457365 | 2020-08-22 | Warren | Georgia | 13301 | 110 | 3 |
454137 | 454137 | 2020-08-21 | Warren | Georgia | 13301 | 110 | 3 |
450909 | 450909 | 2020-08-20 | Warren | Georgia | 13301 | 100 | 3 |
448027 | 448027 | 2020-08-19 | Warren | Iowa | 19181 | 613 | 3 |
444800 | 444800 | 2020-08-18 | Warren | Iowa | 19181 | 608 | 3 |
441574 | 441574 | 2020-08-17 | Warren | Iowa | 19181 | 606 | 3 |
385312 | 385312 | 2020-07-30 | Warren | Tennessee | 47177 | 349 | 3 |
382094 | 382094 | 2020-07-29 | Warren | Tennessee | 47177 | 339 | 3 |
378877 | 378877 | 2020-07-28 | Warren | Tennessee | 47177 | 332 | 3 |
375661 | 375661 | 2020-07-27 | Warren | Tennessee | 47177 | 317 | 3 |
372448 | 372448 | 2020-07-26 | Warren | Tennessee | 47177 | 293 | 3 |
369236 | 369236 | 2020-07-25 | Warren | Tennessee | 47177 | 282 | 3 |
366027 | 366027 | 2020-07-24 | Warren | Tennessee | 47177 | 267 | 3 |
362821 | 362821 | 2020-07-23 | Warren | Tennessee | 47177 | 262 | 3 |
359614 | 359614 | 2020-07-22 | Warren | Tennessee | 47177 | 248 | 3 |
356409 | 356409 | 2020-07-21 | Warren | Tennessee | 47177 | 248 | 3 |
353206 | 353206 | 2020-07-20 | Warren | Tennessee | 47177 | 222 | 3 |
350004 | 350004 | 2020-07-19 | Warren | Tennessee | 47177 | 215 | 3 |
346804 | 346804 | 2020-07-18 | Warren | Tennessee | 47177 | 215 | 3 |
251382 | 251382 | 2020-06-18 | Warren | North Carolina | 37185 | 142 | 3 |
208966 | 208966 | 2020-06-04 | Warren | Virginia | 51187 | 217 | 3 |
205884 | 205884 | 2020-06-03 | Warren | Virginia | 51187 | 204 | 3 |
161327 | 161327 | 2020-05-20 | Warren | Kentucky | 21227 | 863 | 3 |
158301 | 158301 | 2020-05-19 | Warren | Kentucky | 21227 | 828 | 3 |
155284 | 155284 | 2020-05-18 | Warren | Kentucky | 21227 | 810 | 3 |
143619 | 143619 | 2020-05-14 | Warren | Mississippi | 28149 | 127 | 3 |
61007 | 61007 | 2020-04-15 | Warren | Ohio | 39165 | 85 | 3 |
58081 | 58081 | 2020-04-14 | Warren | New York | 36113 | 77 | 3 |
58292 | 58292 | 2020-04-14 | Warren | Ohio | 39165 | 78 | 3 |
29740 | 29740 | 2020-04-03 | Warren | New Jersey | 34041 | 149 | 3 |
27417 | 27417 | 2020-04-02 | Warren | New Jersey | 34041 | 116 | 3 |
25157 | 25157 | 2020-04-01 | Warren | New Jersey | 34041 | 96 | 3 |
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);