Preview UIC Monitoring Records

First 100 rows

Out of roughly 45.7K rows in texas.uic_monitoring. Version obs-81c8692b9f33.

First 100 rows of `texas.uic_monitoring`, 7 columns wide
`cntl_no`	`monitor_date`	`monitor_type`	`monitor_method`	`monitor_result`	`row_no`	`ingested_at`
000000397	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685807	Sept. 2, 2026, 2 a.m.
000000399	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685808	Sept. 2, 2026, 2 a.m.
000000402	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685809	Sept. 2, 2026, 2 a.m.
000000410	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685810	Sept. 2, 2026, 2 a.m.
000000411	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685811	Sept. 2, 2026, 2 a.m.
000000417	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685812	Sept. 2, 2026, 2 a.m.
000000421	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685813	Sept. 2, 2026, 2 a.m.
000000426	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685814	Sept. 2, 2026, 2 a.m.
000000427	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685815	Sept. 2, 2026, 2 a.m.
000000428	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685816	Sept. 2, 2026, 2 a.m.
000000434	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685817	Sept. 2, 2026, 2 a.m.
000000437	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685818	Sept. 2, 2026, 2 a.m.
000000438	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685819	Sept. 2, 2026, 2 a.m.
000000439	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685820	Sept. 2, 2026, 2 a.m.
000000441	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685821	Sept. 2, 2026, 2 a.m.
000000443	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685822	Sept. 2, 2026, 2 a.m.
000000449	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685823	Sept. 2, 2026, 2 a.m.
000000450	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685824	Sept. 2, 2026, 2 a.m.
000000455	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685825	Sept. 2, 2026, 2 a.m.
000000464	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685826	Sept. 2, 2026, 2 a.m.
000000465	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685827	Sept. 2, 2026, 2 a.m.
000000466	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685828	Sept. 2, 2026, 2 a.m.
000000467	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685829	Sept. 2, 2026, 2 a.m.
000000468	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685830	Sept. 2, 2026, 2 a.m.
000000469	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685831	Sept. 2, 2026, 2 a.m.
000000470	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685832	Sept. 2, 2026, 2 a.m.
000000474	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685833	Sept. 2, 2026, 2 a.m.
000000475	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685834	Sept. 2, 2026, 2 a.m.
000000477	null	N	NNNNNYN00000000000000000000000	0000000000000000000000N0000000	685835	Sept. 2, 2026, 2 a.m.
000000478	null	N	NNNNNYN00000000000000000000000	0000000000000000000000N0000000	685836	Sept. 2, 2026, 2 a.m.
000000479	null	N	NNNNNYN00000000000000000000000	0000000000000000000000N0000000	685837	Sept. 2, 2026, 2 a.m.
000000480	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685838	Sept. 2, 2026, 2 a.m.
000000481	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685839	Sept. 2, 2026, 2 a.m.
000000482	null	N	NNNNNYN00000000000000000000000	0000000000000000000000N0000000	685840	Sept. 2, 2026, 2 a.m.
000000483	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685841	Sept. 2, 2026, 2 a.m.
000000484	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685842	Sept. 2, 2026, 2 a.m.
000000485	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685843	Sept. 2, 2026, 2 a.m.
000000486	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685844	Sept. 2, 2026, 2 a.m.
000000487	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685845	Sept. 2, 2026, 2 a.m.
000000488	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685846	Sept. 2, 2026, 2 a.m.
000000489	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685847	Sept. 2, 2026, 2 a.m.
000000491	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685848	Sept. 2, 2026, 2 a.m.
000000493	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685849	Sept. 2, 2026, 2 a.m.
000000494	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685850	Sept. 2, 2026, 2 a.m.
000000495	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685851	Sept. 2, 2026, 2 a.m.
000000496	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685852	Sept. 2, 2026, 2 a.m.
000000497	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685853	Sept. 2, 2026, 2 a.m.
000000498	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685854	Sept. 2, 2026, 2 a.m.
000000502	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685855	Sept. 2, 2026, 2 a.m.
000000504	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685856	Sept. 2, 2026, 2 a.m.
000000505	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685857	Sept. 2, 2026, 2 a.m.
000000506	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685858	Sept. 2, 2026, 2 a.m.
000000507	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685859	Sept. 2, 2026, 2 a.m.
000000508	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685860	Sept. 2, 2026, 2 a.m.
000000509	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685861	Sept. 2, 2026, 2 a.m.
000000510	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685862	Sept. 2, 2026, 2 a.m.
000000511	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685863	Sept. 2, 2026, 2 a.m.
000000512	null	N	NN0NN0000000000000000000000000	0000000000000000000000N0000000	685864	Sept. 2, 2026, 2 a.m.
000000513	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685865	Sept. 2, 2026, 2 a.m.
000000514	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685866	Sept. 2, 2026, 2 a.m.
000000515	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685867	Sept. 2, 2026, 2 a.m.
000000516	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685868	Sept. 2, 2026, 2 a.m.
000000517	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685869	Sept. 2, 2026, 2 a.m.
000000518	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685870	Sept. 2, 2026, 2 a.m.
000000519	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685871	Sept. 2, 2026, 2 a.m.
000000520	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685872	Sept. 2, 2026, 2 a.m.
000000521	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685873	Sept. 2, 2026, 2 a.m.
000000522	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685874	Sept. 2, 2026, 2 a.m.
000000523	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685875	Sept. 2, 2026, 2 a.m.
000000524	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685876	Sept. 2, 2026, 2 a.m.
000000526	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685877	Sept. 2, 2026, 2 a.m.
000000527	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685878	Sept. 2, 2026, 2 a.m.
000000528	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685879	Sept. 2, 2026, 2 a.m.
000000529	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685880	Sept. 2, 2026, 2 a.m.
000000530	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685881	Sept. 2, 2026, 2 a.m.
000000531	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685882	Sept. 2, 2026, 2 a.m.
000000532	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685883	Sept. 2, 2026, 2 a.m.
000000533	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685884	Sept. 2, 2026, 2 a.m.
000000534	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685885	Sept. 2, 2026, 2 a.m.
000000535	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685886	Sept. 2, 2026, 2 a.m.
000000536	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685887	Sept. 2, 2026, 2 a.m.
000000537	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685888	Sept. 2, 2026, 2 a.m.
000000538	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685889	Sept. 2, 2026, 2 a.m.
000000539	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685890	Sept. 2, 2026, 2 a.m.
000000540	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685891	Sept. 2, 2026, 2 a.m.
000000541	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685892	Sept. 2, 2026, 2 a.m.
000000542	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685893	Sept. 2, 2026, 2 a.m.
000000543	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685894	Sept. 2, 2026, 2 a.m.
000000544	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685895	Sept. 2, 2026, 2 a.m.
000000545	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685896	Sept. 2, 2026, 2 a.m.
000000546	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685897	Sept. 2, 2026, 2 a.m.
000000548	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685898	Sept. 2, 2026, 2 a.m.
000000549	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685899	Sept. 2, 2026, 2 a.m.
000000551	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685900	Sept. 2, 2026, 2 a.m.
000000552	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685901	Sept. 2, 2026, 2 a.m.
000000554	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685902	Sept. 2, 2026, 2 a.m.
000000556	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685903	Sept. 2, 2026, 2 a.m.
000000557	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685904	Sept. 2, 2026, 2 a.m.
000000561	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685905	Sept. 2, 2026, 2 a.m.
000000562	null	N	NNNNNNN00000000000000000000000	0000000000000000000000N0000000	685906	Sept. 2, 2026, 2 a.m.

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.

`cntl_no`

varchar

Sampled: 45.7K
Distinct: 45.7K

000063933 1
000011844 1
000120883 1
000050831 1
000062184 1
000011902 1
000002725 1
000038634 1
000122279 1
000084612 1
000126456 1
000071743 1

`row_no`

int4

Sampled: 45.7K
Distinct: 45.7K

694339 1
718391 1
694366 1
690303 1
721648 1
717336 1
704356 1
714240 1
720464 1
710020 1
688440 1
703143 1

`monitor_date`

date

Sampled: 45.7K
Distinct: 0
Empty: 1.0

`monitor_type`

varchar

Sampled: 45.7K
Distinct: 1
Empty: 0.2236

N 35.5K

`monitor_method`

varchar

Sampled: 45.7K
Distinct: 22

NNNNNNN00000000000000000000000 23K
00000000000000000000000 10.2K
N NN 00000000000000000000000 5.9K
NN0NN0000000000000000000000000 4.1K
NNNNNYN00000000000000000000000 1.8K
NNN NN00000000000000000000000 269
NNN YN00000000000000000000000 191
NNYNNNN00000000000000000000000 94
NNNNNNY00000000000000000000000 86
NYN NN00000000000000000000000 64
NN0NNY000000000000000000000000 8
YNNNNNN00000000000000000000000 7

`monitor_result`

varchar

Sampled: 45.7K
Distinct: 8

0000000000000000000000N0000000 45.2K
0000000000000000000000 524
0000000000000000000000Y1998071 4
0000000000000000000000Y1989012 2
0000000000000000000000Y1989121 2
0000000000000000000000Y1988051 1
0000000000000000000000Y2010012 1
0000000000000000000000Y1986081 1

`ingested_at`

timestamptz

Sampled: 45.7K
Distinct: 288

Sept. 2, 2026, 2:13 a.m. 600
Sept. 2, 2026, 2:02 a.m. 561
Sept. 2, 2026, 2:02 a.m. 509
Sept. 2, 2026, 2:12 a.m. 500
Sept. 2, 2026, 2:12 a.m. 489
Sept. 2, 2026, 2:13 a.m. 484
Sept. 2, 2026, 2:48 a.m. 478
Sept. 2, 2026, 2:18 a.m. 457
Sept. 2, 2026, 2:14 a.m. 455
Sept. 2, 2026, 2:47 a.m. 446
Sept. 2, 2026, 2:47 a.m. 440
Sept. 2, 2026, 2:03 a.m. 435

Take it away

Back to everything we know about UIC Monitoring Records