First 100 rows
Out of roughly 951.6K rows in
texas.dp_permit.
Version obs-12ba2d570d10.
What is in each column
Sampled, not exhaustive — enough to tell whether this is the
data you want without making the database read tens of millions of
rows.
status_no
int4
- Sampled
- 50K
- Distinct
- 49.9K
-
16988
3
-
39427
3
-
25839
2
-
33800
2
-
26177
2
-
39400
2
-
36914
2
-
23851
2
-
46401
2
-
30747
2
-
14
2
-
30169
2
status_seq
int4
- Sampled
- 50K
- Distinct
- 3
permit_no
int4
- Sampled
- 50K
- Distinct
- 49.9K
-
16988
5
-
43810
3
-
39587
3
-
28624
2
-
28618
2
-
47220
2
-
42160
2
-
33283
2
-
45551
2
-
15101
2
-
14
2
-
2354
2
county_code
varchar
- Sampled
- 50K
- Distinct
- 14
-
003
23.4K
-
009
11.5K
-
013
6.4K
-
001
2.4K
-
021
1.6K
-
023
1.6K
-
015
1.3K
-
007
767
-
005
616
-
025
315
-
019
32
-
011
16
district
varchar
- Sampled
- 50K
- Distinct
- 2
operator_no
int4
- Sampled
- 50K
- Distinct
- 865
-
27200
9.7K
-
20425
7.2K
-
20528
4.5K
-
20572
4K
-
20542
2.6K
-
20430
1.3K
-
20566
853
-
16980
835
-
18900
831
-
3125
582
-
18023
575
-
15726
569
api_number
varchar
- Sampled
- 50K
- Distinct
- 42K
-
42-007-30739
11
-
42-007-30780
9
-
42-003-36834
9
-
42-015-30139
9
-
42-003-38201
8
-
42-007-30641
7
-
42-015-30950
7
-
42-003-36803
7
-
42-003-37015
7
-
42-003-38262
7
-
42-015-30584
6
-
42-015-30485
6
application_type
varchar
- Sampled
- 50K
- Distinct
- 6
-
01
44.9K
-
14
3.8K
-
07
485
-
05
453
-
09
276
-
15
122