ny_times_us_states

1,884 rows

- column - rowid date state fips cases deaths

= != contains ends with starts with > ≥ < ≤ like glob in not in date is null is not null is blank is not blank

Sort... Sort by rowid Sort by date Sort by state Sort by fips Sort by cases Sort by deaths

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link	rowid ▼	date	state	fips	cases	deaths
1	1	2020-01-21	Washington	53	1	0
2	2	2020-01-22	Washington	53	1	0
3	3	2020-01-23	Washington	53	1	0
4	4	2020-01-24	Illinois	17	1	0
5	5	2020-01-24	Washington	53	1	0
6	6	2020-01-25	California	6	1	0
7	7	2020-01-25	Illinois	17	1	0
8	8	2020-01-25	Washington	53	1	0
9	9	2020-01-26	Arizona	4	1	0
10	10	2020-01-26	California	6	2	0
11	11	2020-01-26	Illinois	17	1	0
12	12	2020-01-26	Washington	53	1	0
13	13	2020-01-27	Arizona	4	1	0
14	14	2020-01-27	California	6	2	0
15	15	2020-01-27	Illinois	17	1	0
16	16	2020-01-27	Washington	53	1	0
17	17	2020-01-28	Arizona	4	1	0
18	18	2020-01-28	California	6	2	0
19	19	2020-01-28	Illinois	17	1	0
20	20	2020-01-28	Washington	53	1	0
21	21	2020-01-29	Arizona	4	1	0
22	22	2020-01-29	California	6	2	0
23	23	2020-01-29	Illinois	17	1	0
24	24	2020-01-29	Washington	53	1	0
25	25	2020-01-30	Arizona	4	1	0
26	26	2020-01-30	California	6	2	0
27	27	2020-01-30	Illinois	17	2	0
28	28	2020-01-30	Washington	53	1	0
29	29	2020-01-31	Arizona	4	1	0
30	30	2020-01-31	California	6	3	0
31	31	2020-01-31	Illinois	17	2	0
32	32	2020-01-31	Washington	53	1	0
33	33	2020-02-01	Arizona	4	1	0
34	34	2020-02-01	California	6	3	0
35	35	2020-02-01	Illinois	17	2	0
36	36	2020-02-01	Massachusetts	25	1	0
37	37	2020-02-01	Washington	53	1	0
38	38	2020-02-02	Arizona	4	1	0
39	39	2020-02-02	California	6	6	0
40	40	2020-02-02	Illinois	17	2	0
41	41	2020-02-02	Massachusetts	25	1	0
42	42	2020-02-02	Washington	53	1	0
43	43	2020-02-03	Arizona	4	1	0
44	44	2020-02-03	California	6	6	0
45	45	2020-02-03	Illinois	17	2	0
46	46	2020-02-03	Massachusetts	25	1	0
47	47	2020-02-03	Washington	53	1	0
48	48	2020-02-04	Arizona	4	1	0
49	49	2020-02-04	California	6	6	0
50	50	2020-02-04	Illinois	17	2	0
51	51	2020-02-04	Massachusetts	25	1	0
52	52	2020-02-04	Washington	53	1	0
53	53	2020-02-05	Arizona	4	1	0
54	54	2020-02-05	California	6	6	0
55	55	2020-02-05	Illinois	17	2	0
56	56	2020-02-05	Massachusetts	25	1	0
57	57	2020-02-05	Washington	53	1	0
58	58	2020-02-05	Wisconsin	55	1	0
59	59	2020-02-06	Arizona	4	1	0
60	60	2020-02-06	California	6	6	0
61	61	2020-02-06	Illinois	17	2	0
62	62	2020-02-06	Massachusetts	25	1	0
63	63	2020-02-06	Washington	53	1	0
64	64	2020-02-06	Wisconsin	55	1	0
65	65	2020-02-07	Arizona	4	1	0
66	66	2020-02-07	California	6	6	0
67	67	2020-02-07	Illinois	17	2	0
68	68	2020-02-07	Massachusetts	25	1	0
69	69	2020-02-07	Washington	53	1	0
70	70	2020-02-07	Wisconsin	55	1	0
71	71	2020-02-08	Arizona	4	1	0
72	72	2020-02-08	California	6	6	0
73	73	2020-02-08	Illinois	17	2	0
74	74	2020-02-08	Massachusetts	25	1	0
75	75	2020-02-08	Washington	53	1	0
76	76	2020-02-08	Wisconsin	55	1	0
77	77	2020-02-09	Arizona	4	1	0
78	78	2020-02-09	California	6	6	0
79	79	2020-02-09	Illinois	17	2	0
80	80	2020-02-09	Massachusetts	25	1	0
81	81	2020-02-09	Washington	53	1	0
82	82	2020-02-09	Wisconsin	55	1	0
83	83	2020-02-10	Arizona	4	1	0
84	84	2020-02-10	California	6	7	0
85	85	2020-02-10	Illinois	17	2	0
86	86	2020-02-10	Massachusetts	25	1	0
87	87	2020-02-10	Washington	53	1	0
88	88	2020-02-10	Wisconsin	55	1	0
89	89	2020-02-11	Arizona	4	1	0
90	90	2020-02-11	California	6	7	0
91	91	2020-02-11	Illinois	17	2	0
92	92	2020-02-11	Massachusetts	25	1	0
93	93	2020-02-11	Washington	53	1	0
94	94	2020-02-11	Wisconsin	55	1	0
95	95	2020-02-12	Arizona	4	1	0
96	96	2020-02-12	California	6	7	0
97	97	2020-02-12	Illinois	17	2	0
98	98	2020-02-12	Massachusetts	25	1	0
99	99	2020-02-12	Texas	48	1	0
100	100	2020-02-12	Washington	53	1	0

Next page

CREATE TABLE [ny_times_us_states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);