ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28113 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79799 | 79799 | 2020-04-22 | Pike | Mississippi | 28113 | 118 | 3 |
77014 | 77014 | 2020-04-21 | Pike | Mississippi | 28113 | 118 | 3 |
74233 | 74233 | 2020-04-20 | Pike | Mississippi | 28113 | 115 | 2 |
71460 | 71460 | 2020-04-19 | Pike | Mississippi | 28113 | 104 | 2 |
68694 | 68694 | 2020-04-18 | Pike | Mississippi | 28113 | 97 | 2 |
65942 | 65942 | 2020-04-17 | Pike | Mississippi | 28113 | 93 | 2 |
63202 | 63202 | 2020-04-16 | Pike | Mississippi | 28113 | 82 | 2 |
60480 | 60480 | 2020-04-15 | Pike | Mississippi | 28113 | 72 | 2 |
57769 | 57769 | 2020-04-14 | Pike | Mississippi | 28113 | 62 | 1 |
55071 | 55071 | 2020-04-13 | Pike | Mississippi | 28113 | 59 | 1 |
52389 | 52389 | 2020-04-12 | Pike | Mississippi | 28113 | 54 | 1 |
49716 | 49716 | 2020-04-11 | Pike | Mississippi | 28113 | 47 | 1 |
47070 | 47070 | 2020-04-10 | Pike | Mississippi | 28113 | 39 | 1 |
44461 | 44461 | 2020-04-09 | Pike | Mississippi | 28113 | 35 | 1 |
41884 | 41884 | 2020-04-08 | Pike | Mississippi | 28113 | 33 | 1 |
39330 | 39330 | 2020-04-07 | Pike | Mississippi | 28113 | 31 | 0 |
36819 | 36819 | 2020-04-06 | Pike | Mississippi | 28113 | 28 | 0 |
34356 | 34356 | 2020-04-05 | Pike | Mississippi | 28113 | 26 | 0 |
31929 | 31929 | 2020-04-04 | Pike | Mississippi | 28113 | 23 | 0 |
29549 | 29549 | 2020-04-03 | Pike | Mississippi | 28113 | 21 | 0 |
27230 | 27230 | 2020-04-02 | Pike | Mississippi | 28113 | 21 | 0 |
24976 | 24976 | 2020-04-01 | Pike | Mississippi | 28113 | 20 | 0 |
22792 | 22792 | 2020-03-31 | Pike | Mississippi | 28113 | 17 | 0 |
20675 | 20675 | 2020-03-30 | Pike | Mississippi | 28113 | 16 | 0 |
18651 | 18651 | 2020-03-29 | Pike | Mississippi | 28113 | 14 | 0 |
16729 | 16729 | 2020-03-28 | Pike | Mississippi | 28113 | 12 | 0 |
14905 | 14905 | 2020-03-27 | Pike | Mississippi | 28113 | 12 | 0 |
13186 | 13186 | 2020-03-26 | Pike | Mississippi | 28113 | 12 | 0 |
11593 | 11593 | 2020-03-25 | Pike | Mississippi | 28113 | 10 | 0 |
10173 | 10173 | 2020-03-24 | Pike | Mississippi | 28113 | 7 | 0 |
8875 | 8875 | 2020-03-23 | Pike | Mississippi | 28113 | 4 | 0 |
7693 | 7693 | 2020-03-22 | Pike | Mississippi | 28113 | 3 | 0 |
6608 | 6608 | 2020-03-21 | Pike | Mississippi | 28113 | 2 | 0 |
5625 | 5625 | 2020-03-20 | Pike | Mississippi | 28113 | 1 | 0 |
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);