ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Pontotoc" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7694 | 7694 | 2020-03-22 | Pontotoc | Mississippi | 28115 | 1 | 0 |
8876 | 8876 | 2020-03-23 | Pontotoc | Mississippi | 28115 | 1 | 0 |
9152 | 9152 | 2020-03-23 | Pontotoc | Oklahoma | 40123 | 1 | 0 |
10174 | 10174 | 2020-03-24 | Pontotoc | Mississippi | 28115 | 2 | 0 |
10469 | 10469 | 2020-03-24 | Pontotoc | Oklahoma | 40123 | 1 | 0 |
11594 | 11594 | 2020-03-25 | Pontotoc | Mississippi | 28115 | 2 | 0 |
11928 | 11928 | 2020-03-25 | Pontotoc | Oklahoma | 40123 | 1 | 0 |
13187 | 13187 | 2020-03-26 | Pontotoc | Mississippi | 28115 | 3 | 0 |
13543 | 13543 | 2020-03-26 | Pontotoc | Oklahoma | 40123 | 1 | 0 |
14906 | 14906 | 2020-03-27 | Pontotoc | Mississippi | 28115 | 4 | 0 |
15287 | 15287 | 2020-03-27 | Pontotoc | Oklahoma | 40123 | 2 | 0 |
16730 | 16730 | 2020-03-28 | Pontotoc | Mississippi | 28115 | 4 | 0 |
17134 | 17134 | 2020-03-28 | Pontotoc | Oklahoma | 40123 | 3 | 0 |
18652 | 18652 | 2020-03-29 | Pontotoc | Mississippi | 28115 | 4 | 0 |
19069 | 19069 | 2020-03-29 | Pontotoc | Oklahoma | 40123 | 3 | 0 |
20676 | 20676 | 2020-03-30 | Pontotoc | Mississippi | 28115 | 5 | 0 |
21119 | 21119 | 2020-03-30 | Pontotoc | Oklahoma | 40123 | 3 | 0 |
22793 | 22793 | 2020-03-31 | Pontotoc | Mississippi | 28115 | 5 | 0 |
23252 | 23252 | 2020-03-31 | Pontotoc | Oklahoma | 40123 | 5 | 0 |
24977 | 24977 | 2020-04-01 | Pontotoc | Mississippi | 28115 | 6 | 0 |
25449 | 25449 | 2020-04-01 | Pontotoc | Oklahoma | 40123 | 5 | 0 |
27231 | 27231 | 2020-04-02 | Pontotoc | Mississippi | 28115 | 10 | 0 |
27721 | 27721 | 2020-04-02 | Pontotoc | Oklahoma | 40123 | 5 | 0 |
29550 | 29550 | 2020-04-03 | Pontotoc | Mississippi | 28115 | 11 | 1 |
30053 | 30053 | 2020-04-03 | Pontotoc | Oklahoma | 40123 | 7 | 0 |
31930 | 31930 | 2020-04-04 | Pontotoc | Mississippi | 28115 | 12 | 1 |
32442 | 32442 | 2020-04-04 | Pontotoc | Oklahoma | 40123 | 7 | 0 |
34357 | 34357 | 2020-04-05 | Pontotoc | Mississippi | 28115 | 12 | 1 |
34876 | 34876 | 2020-04-05 | Pontotoc | Oklahoma | 40123 | 7 | 0 |
36820 | 36820 | 2020-04-06 | Pontotoc | Mississippi | 28115 | 12 | 1 |
37350 | 37350 | 2020-04-06 | Pontotoc | Oklahoma | 40123 | 8 | 0 |
39331 | 39331 | 2020-04-07 | Pontotoc | Mississippi | 28115 | 12 | 1 |
39871 | 39871 | 2020-04-07 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
41885 | 41885 | 2020-04-08 | Pontotoc | Mississippi | 28115 | 13 | 1 |
42431 | 42431 | 2020-04-08 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
44462 | 44462 | 2020-04-09 | Pontotoc | Mississippi | 28115 | 14 | 1 |
45017 | 45017 | 2020-04-09 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
47071 | 47071 | 2020-04-10 | Pontotoc | Mississippi | 28115 | 14 | 1 |
47634 | 47634 | 2020-04-10 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
49717 | 49717 | 2020-04-11 | Pontotoc | Mississippi | 28115 | 14 | 1 |
50290 | 50290 | 2020-04-11 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
52390 | 52390 | 2020-04-12 | Pontotoc | Mississippi | 28115 | 15 | 1 |
52963 | 52963 | 2020-04-12 | Pontotoc | Oklahoma | 40123 | 9 | 0 |
55072 | 55072 | 2020-04-13 | Pontotoc | Mississippi | 28115 | 15 | 1 |
55648 | 55648 | 2020-04-13 | Pontotoc | Oklahoma | 40123 | 10 | 0 |
57770 | 57770 | 2020-04-14 | Pontotoc | Mississippi | 28115 | 15 | 2 |
58350 | 58350 | 2020-04-14 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
60481 | 60481 | 2020-04-15 | Pontotoc | Mississippi | 28115 | 15 | 2 |
61065 | 61065 | 2020-04-15 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
63203 | 63203 | 2020-04-16 | Pontotoc | Mississippi | 28115 | 16 | 2 |
63791 | 63791 | 2020-04-16 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
65943 | 65943 | 2020-04-17 | Pontotoc | Mississippi | 28115 | 17 | 2 |
66536 | 66536 | 2020-04-17 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
68695 | 68695 | 2020-04-18 | Pontotoc | Mississippi | 28115 | 17 | 2 |
69294 | 69294 | 2020-04-18 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
71461 | 71461 | 2020-04-19 | Pontotoc | Mississippi | 28115 | 18 | 2 |
72061 | 72061 | 2020-04-19 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
74234 | 74234 | 2020-04-20 | Pontotoc | Mississippi | 28115 | 18 | 2 |
74836 | 74836 | 2020-04-20 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
77015 | 77015 | 2020-04-21 | Pontotoc | Mississippi | 28115 | 18 | 2 |
77618 | 77618 | 2020-04-21 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
79800 | 79800 | 2020-04-22 | Pontotoc | Mississippi | 28115 | 18 | 2 |
80408 | 80408 | 2020-04-22 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
82596 | 82596 | 2020-04-23 | Pontotoc | Mississippi | 28115 | 18 | 2 |
83207 | 83207 | 2020-04-23 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
85400 | 85400 | 2020-04-24 | Pontotoc | Mississippi | 28115 | 18 | 2 |
86011 | 86011 | 2020-04-24 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
88210 | 88210 | 2020-04-25 | Pontotoc | Mississippi | 28115 | 18 | 2 |
88825 | 88825 | 2020-04-25 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
91026 | 91026 | 2020-04-26 | Pontotoc | Mississippi | 28115 | 18 | 2 |
91641 | 91641 | 2020-04-26 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
93847 | 93847 | 2020-04-27 | Pontotoc | Mississippi | 28115 | 18 | 2 |
94467 | 94467 | 2020-04-27 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
96683 | 96683 | 2020-04-28 | Pontotoc | Mississippi | 28115 | 18 | 2 |
97305 | 97305 | 2020-04-28 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
99529 | 99529 | 2020-04-29 | Pontotoc | Mississippi | 28115 | 18 | 2 |
100154 | 100154 | 2020-04-29 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
102381 | 102381 | 2020-04-30 | Pontotoc | Mississippi | 28115 | 18 | 2 |
103007 | 103007 | 2020-04-30 | Pontotoc | Oklahoma | 40123 | 10 | 1 |
105242 | 105242 | 2020-05-01 | Pontotoc | Mississippi | 28115 | 18 | 2 |
105870 | 105870 | 2020-05-01 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
108107 | 108107 | 2020-05-02 | Pontotoc | Mississippi | 28115 | 20 | 2 |
108737 | 108737 | 2020-05-02 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
110978 | 110978 | 2020-05-03 | Pontotoc | Mississippi | 28115 | 22 | 2 |
111611 | 111611 | 2020-05-03 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
113857 | 113857 | 2020-05-04 | Pontotoc | Mississippi | 28115 | 22 | 2 |
114493 | 114493 | 2020-05-04 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
116739 | 116739 | 2020-05-05 | Pontotoc | Mississippi | 28115 | 22 | 2 |
117374 | 117374 | 2020-05-05 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
119699 | 119699 | 2020-05-06 | Pontotoc | Mississippi | 28115 | 22 | 2 |
120335 | 120335 | 2020-05-06 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
122673 | 122673 | 2020-05-07 | Pontotoc | Mississippi | 28115 | 22 | 2 |
123312 | 123312 | 2020-05-07 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
125655 | 125655 | 2020-05-08 | Pontotoc | Mississippi | 28115 | 22 | 2 |
126295 | 126295 | 2020-05-08 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
128642 | 128642 | 2020-05-09 | Pontotoc | Mississippi | 28115 | 24 | 2 |
129284 | 129284 | 2020-05-09 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
131632 | 131632 | 2020-05-10 | Pontotoc | Mississippi | 28115 | 24 | 2 |
132273 | 132273 | 2020-05-10 | Pontotoc | Oklahoma | 40123 | 10 | 2 |
134623 | 134623 | 2020-05-11 | Pontotoc | Mississippi | 28115 | 23 | 2 |
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);