participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,036 rows where station_code = "NZ0021" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5130980 | 5130980 | 20240917171213_6bLpv | NZ0021 | 2024-09-19T12:14:02.557Z | 2024-09-19T12:14:02.557Z |
5130840 | 5130840 | 20240917155136_p6vSm | NZ0021 | 2024-09-19T12:13:53.310Z | 2024-09-19T12:13:53.310Z |
5130701 | 5130701 | 20240917144601_zvnBU | NZ0021 | 2024-09-19T12:13:45.813Z | 2024-09-19T12:13:45.813Z |
5130680 | 5130680 | 20240917143353_cDyg8 | NZ0021 | 2024-09-19T12:13:44.287Z | 2024-09-19T12:13:44.287Z |
5130593 | 5130593 | 20240917133450_a4ded | NZ0021 | 2024-09-19T12:13:38.177Z | 2024-09-19T12:13:38.177Z |
5130561 | 5130561 | 20240917131342_jCBTm | NZ0021 | 2024-09-19T12:13:35.897Z | 2024-09-19T12:13:35.897Z |
5130403 | 5130403 | 20240917115043_dpm2M | NZ0021 | 2024-09-19T12:13:10.355Z | 2024-09-19T12:13:10.355Z |
5081687 | 5081687 | 20240911082508_1eHut | NZ0021 | 2024-09-15T12:17:41.684Z | 2024-09-19T12:21:46.067Z |
5071560 | 5071560 | 20240911171635_YxUiG | NZ0021 | 2024-09-15T12:02:56.981Z | 2024-09-19T12:21:02.105Z |
5071554 | 5071554 | 20240911171536_owJfA | NZ0021 | 2024-09-15T12:02:55.165Z | 2024-09-19T12:21:02.100Z |
5071429 | 5071429 | 20240911165024_dRddc | NZ0021 | 2024-09-15T12:02:31.463Z | 2024-09-19T12:21:01.886Z |
5062571 | 5062571 | 20240909174129_mHDkJ | NZ0021 | 2024-09-14T12:12:33.909Z | 2024-09-18T12:15:11.503Z |
5062478 | 5062478 | 20240909173026_rxz7Q | NZ0021 | 2024-09-14T12:12:25.949Z | 2024-09-18T12:15:11.389Z |
5062442 | 5062442 | 20240909172559_CWjeF | NZ0021 | 2024-09-14T12:12:22.158Z | 2024-09-18T12:15:11.347Z |
5062440 | 5062440 | 20240909172527_sldlX | NZ0021 | 2024-09-14T12:12:21.746Z | 2024-09-18T12:15:11.331Z |
5062428 | 5062428 | 20240909172413_mFrxd | NZ0021 | 2024-09-14T12:12:19.967Z | 2024-09-18T12:15:11.325Z |
5062356 | 5062356 | 20240909171430_OTiMo | NZ0021 | 2024-09-14T12:12:12.814Z | 2024-09-18T12:15:11.022Z |
5062186 | 5062186 | 20240909165544_iosR4 | NZ0021 | 2024-09-14T12:11:54.653Z | 2024-09-18T12:15:10.523Z |
5061901 | 5061901 | 20240909162059_V7tRH | NZ0021 | 2024-09-14T12:11:36.790Z | 2024-09-18T12:15:10.126Z |
5061724 | 5061724 | 20240909154736_ZUuga | NZ0021 | 2024-09-14T12:11:15.854Z | 2024-09-18T12:15:09.924Z |
5061446 | 5061446 | 20240909150735_fgWcM | NZ0021 | 2024-09-14T12:10:50.383Z | 2024-09-18T12:15:09.241Z |
5061364 | 5061364 | 20240909145712_HLP2q | NZ0021 | 2024-09-14T12:10:44.520Z | 2024-09-18T12:15:08.996Z |
5061252 | 5061252 | 20240909143757_P4OVe | NZ0021 | 2024-09-14T12:10:38.159Z | 2024-09-18T12:15:08.809Z |
5061148 | 5061148 | 20240909142231_o4DSG | NZ0021 | 2024-09-14T12:10:22.756Z | 2024-09-18T12:15:08.329Z |
5061031 | 5061031 | 20240909135534_UNjFp | NZ0021 | 2024-09-14T12:10:07.157Z | 2024-09-18T12:15:07.861Z |
5060905 | 5060905 | 20240909131848_PTXjD | NZ0021 | 2024-09-14T12:09:54.946Z | 2024-09-18T12:15:07.254Z |
5060883 | 5060883 | 20240909131148_s1Kmm | NZ0021 | 2024-09-14T12:09:51.835Z | 2024-09-18T12:15:07.182Z |
5060871 | 5060871 | 20240909130931_biSbC | NZ0021 | 2024-09-14T12:09:51.090Z | 2024-09-18T12:15:07.147Z |
5060865 | 5060865 | 20240909130742_qQm3P | NZ0021 | 2024-09-14T12:09:50.583Z | 2024-09-18T12:15:07.112Z |
5059354 | 5059354 | 20240910173353_EKCx7 | NZ0021 | 2024-09-14T12:05:48.130Z | 2024-09-19T12:21:30.662Z |
5059225 | 5059225 | 20240910172439_Wp3ls | NZ0021 | 2024-09-14T12:05:28.183Z | 2024-09-19T12:21:30.465Z |
5059135 | 5059135 | 20240910171617_g53Nv | NZ0021 | 2024-09-14T12:05:18.116Z | 2024-09-19T12:21:30.399Z |
5058893 | 5058893 | 20240910165441_D0WSv | NZ0021 | 2024-09-14T12:04:46.162Z | 2024-09-19T12:21:30.220Z |
5058669 | 5058669 | 20240910163510_bjFr3 | NZ0021 | 2024-09-14T12:04:17.671Z | 2024-09-19T12:21:29.811Z |
5058556 | 5058556 | 20240910162540_2UYm2 | NZ0021 | 2024-09-14T12:03:57.493Z | 2024-09-19T12:21:29.714Z |
5058459 | 5058459 | 20240910161356_CUGg5 | NZ0021 | 2024-09-14T12:03:44.411Z | 2024-09-19T12:21:29.634Z |
5058425 | 5058425 | 20240910161138_kOQF3 | NZ0021 | 2024-09-14T12:03:40.888Z | 2024-09-19T12:21:29.597Z |
5058278 | 5058278 | 20240910160031_81910 | NZ0021 | 2024-09-14T12:03:18.728Z | 2024-09-19T12:21:29.399Z |
5058265 | 5058265 | 20240910155948_XPHWK | NZ0021 | 2024-09-14T12:03:17.929Z | 2024-09-19T12:21:29.396Z |
5058215 | 5058215 | 20240910155355_s8skQ | NZ0021 | 2024-09-14T12:03:10.058Z | 2024-09-19T12:21:29.358Z |
5058184 | 5058184 | 20240910155030_6JCIY | NZ0021 | 2024-09-14T12:03:06.425Z | 2024-09-19T12:21:29.258Z |
5058139 | 5058139 | 20240910154728_mDMxx | NZ0021 | 2024-09-14T12:03:01.320Z | 2024-09-19T12:21:29.179Z |
5058024 | 5058024 | 20240910153714_6y76X | NZ0021 | 2024-09-14T12:02:38.289Z | 2024-09-19T12:21:29.019Z |
5057912 | 5057912 | 20240910152456_57zKr | NZ0021 | 2024-09-14T12:02:23.404Z | 2024-09-19T12:21:28.921Z |
5057754 | 5057754 | 20240910151036_b9l26 | NZ0021 | 2024-09-14T12:01:53.326Z | 2024-09-19T12:21:28.687Z |
5057670 | 5057670 | 20240910150308_TzHhk | NZ0021 | 2024-09-14T12:01:41.953Z | 2024-09-19T12:21:28.559Z |
5057560 | 5057560 | 20240910144920_qEWu2 | NZ0021 | 2024-09-14T12:01:26.736Z | 2024-09-19T12:21:28.367Z |
5057424 | 5057424 | 20240910142843_u0D4J | NZ0021 | 2024-09-14T12:01:02.894Z | 2024-09-19T12:21:27.842Z |
5055587 | 5055587 | 20240908082632_GX6nr | NZ0021 | 2024-09-13T12:17:18.018Z | 2024-09-16T12:21:20.423Z |
5055432 | 5055432 | 20240908080228_koTmf | NZ0021 | 2024-09-13T12:17:13.852Z | 2024-09-16T12:21:19.788Z |
5055417 | 5055417 | 20240908080053_hRb3v | NZ0021 | 2024-09-13T12:17:12.146Z | 2024-09-16T12:21:19.585Z |
5051599 | 5051599 | 20240907174852_v7rsP | NZ0021 | 2024-09-13T12:14:23.887Z | 2024-09-16T12:21:01.359Z |
5051489 | 5051489 | 20240907173402_E21po | NZ0021 | 2024-09-13T12:14:18.701Z | 2024-09-16T12:21:00.575Z |
5051456 | 5051456 | 20240907172949_WYSzV | NZ0021 | 2024-09-13T12:14:16.652Z | 2024-09-16T12:21:00.501Z |
5050971 | 5050971 | 20240907162959_FagiQ | NZ0021 | 2024-09-13T12:13:55.276Z | 2024-09-16T12:20:59.413Z |
5050841 | 5050841 | 20240907161445_dU52M | NZ0021 | 2024-09-13T12:13:48.440Z | 2024-09-16T12:20:58.769Z |
5050795 | 5050795 | 20240907160757_6qF3n | NZ0021 | 2024-09-13T12:13:46.851Z | 2024-09-16T12:20:58.524Z |
5050639 | 5050639 | 20240907155130_SsYc9 | NZ0021 | 2024-09-13T12:13:41.800Z | 2024-09-16T12:20:58.192Z |
5050583 | 5050583 | 20240907154407_WTO9V | NZ0021 | 2024-09-13T12:13:37.963Z | 2024-09-16T12:20:58.049Z |
5050459 | 5050459 | 20240907152256_6vzeO | NZ0021 | 2024-09-13T12:13:32.588Z | 2024-09-16T12:20:57.729Z |
5050422 | 5050422 | 20240907152018_OdhXP | NZ0021 | 2024-09-13T12:13:31.046Z | 2024-09-16T12:20:57.669Z |
5050230 | 5050230 | 20240907145445_lsoZi | NZ0021 | 2024-09-13T12:13:19.350Z | 2024-09-16T12:20:56.790Z |
5050172 | 5050172 | 20240907144514_e9u7V | NZ0021 | 2024-09-13T12:13:15.311Z | 2024-09-16T12:20:56.615Z |
5050118 | 5050118 | 20240909124936_4zTrM | NZ0021 | 2024-09-13T12:12:41.113Z | 2024-09-17T12:19:12.403Z |
5050048 | 5050048 | 20240909123410_Jf3YF | NZ0021 | 2024-09-13T12:12:37.967Z | 2024-09-17T12:19:12.172Z |
5049867 | 5049867 | 20240909115154_mYfed | NZ0021 | 2024-09-13T12:12:29.365Z | 2024-09-17T12:19:11.694Z |
5049426 | 5049426 | 20240909105428_qKeoy | NZ0021 | 2024-09-13T12:12:10.780Z | 2024-09-17T12:19:10.379Z |
5049029 | 5049029 | 20240909094928_342mN | NZ0021 | 2024-09-13T12:11:28.429Z | 2024-09-17T12:19:08.988Z |
5045175 | 5045175 | 20240908162850_QFj5J | NZ0021 | 2024-09-13T12:03:37.735Z | 2024-09-17T12:18:56.018Z |
5045145 | 5045145 | 20240908162546_KDLZ8 | NZ0021 | 2024-09-13T12:03:36.290Z | 2024-09-17T12:18:56.002Z |
5045105 | 5045105 | 20240908161936_nJ0Nc | NZ0021 | 2024-09-13T12:03:33.192Z | 2024-09-17T12:18:55.914Z |
5044825 | 5044825 | 20240908154820_effqg | NZ0021 | 2024-09-13T12:03:00.548Z | 2024-09-17T12:18:55.257Z |
5044665 | 5044665 | 20240908152727_c9pAm | NZ0021 | 2024-09-13T12:02:45.152Z | 2024-09-17T12:18:54.815Z |
5043331 | 5043331 | 20240907143407_M2xH9 | NZ0021 | 2024-09-12T12:17:26.508Z | 2024-09-16T12:20:56.388Z |
5043305 | 5043305 | 20240907142659_rkVl9 | NZ0021 | 2024-09-12T12:17:26.138Z | 2024-09-16T12:20:56.312Z |
5043276 | 5043276 | 20240907142108_34VGQ | NZ0021 | 2024-09-12T12:17:26.008Z | 2024-09-16T12:20:56.193Z |
5043259 | 5043259 | 20240907141713_xDtHf | NZ0021 | 2024-09-12T12:17:25.889Z | 2024-09-16T12:20:56.058Z |
5043215 | 5043215 | 20240907140834_rwyC9 | NZ0021 | 2024-09-12T12:17:25.359Z | 2024-09-16T12:20:55.903Z |
5043143 | 5043143 | 20240907135708_ksmT2 | NZ0021 | 2024-09-12T12:17:23.908Z | 2024-09-16T12:20:55.583Z |
5043090 | 5043090 | 20240907134819_grb4j | NZ0021 | 2024-09-12T12:17:23.304Z | 2024-09-16T12:20:55.357Z |
5043016 | 5043016 | 20240907133353_xZuNO | NZ0021 | 2024-09-12T12:17:21.853Z | 2024-09-16T12:20:55.183Z |
5042977 | 5042977 | 20240907132413_AXVzA | NZ0021 | 2024-09-12T12:17:21.240Z | 2024-09-16T12:20:55.042Z |
5042966 | 5042966 | 20240907132049_BM2nV | NZ0021 | 2024-09-12T12:17:21.190Z | 2024-09-16T12:20:54.971Z |
5042921 | 5042921 | 20240907131219_G3kfS | NZ0021 | 2024-09-12T12:17:20.818Z | 2024-09-16T12:20:54.907Z |
5042771 | 5042771 | 20240907124406_qYxua | NZ0021 | 2024-09-12T12:17:18.217Z | 2024-09-16T12:20:54.185Z |
5042750 | 5042750 | 20240907123720_Y0po2 | NZ0021 | 2024-09-12T12:17:17.842Z | 2024-09-16T12:20:54.087Z |
5042499 | 5042499 | 20240907114825_B9sQa | NZ0021 | 2024-09-12T12:17:13.209Z | 2024-09-16T12:20:53.344Z |
5041970 | 5041970 | 20240906093351_DgboE | NZ0021 | 2024-09-12T12:16:53.431Z | 2024-09-14T12:23:15.643Z |
5041694 | 5041694 | 20240906085205_ymvFW | NZ0021 | 2024-09-12T12:16:47.301Z | 2024-09-14T12:23:14.344Z |
5041409 | 5041409 | 20240906080858_j1Pic | NZ0021 | 2024-09-12T12:16:40.966Z | 2024-09-14T12:23:13.447Z |
5041110 | 5041110 | 20240906072241_gl2fT | NZ0021 | 2024-09-12T12:16:34.203Z | 2024-09-14T12:23:11.807Z |
5037385 | 5037385 | 20240905155104_bGqin | NZ0021 | 2024-09-12T12:14:06.103Z | 2024-09-14T12:22:54.175Z |
5037285 | 5037285 | 20240905153158_ft4xl | NZ0021 | 2024-09-12T12:14:04.214Z | 2024-09-14T12:22:54.073Z |
5037224 | 5037224 | 20240905152611_cADWV | NZ0021 | 2024-09-12T12:14:03.084Z | 2024-09-14T12:22:53.965Z |
5037094 | 5037094 | 20240905150521_axrDw | NZ0021 | 2024-09-12T12:14:00.842Z | 2024-09-14T12:22:53.704Z |
5037053 | 5037053 | 20240905145947_HqtKz | NZ0021 | 2024-09-12T12:13:59.842Z | 2024-09-14T12:22:53.651Z |
5036668 | 5036668 | 20240905141330_HigzJ | NZ0021 | 2024-09-12T12:13:51.820Z | 2024-09-14T12:22:53.084Z |
5036213 | 5036213 | 20240905125829_SprfM | NZ0021 | 2024-09-12T12:13:29.078Z | 2024-09-14T12:22:52.038Z |
5036142 | 5036142 | 20240905124932_RNtJb | NZ0021 | 2024-09-12T12:13:26.734Z | 2024-09-14T12:22:51.929Z |
5036032 | 5036032 | 20240905123059_C3Yqm | NZ0021 | 2024-09-12T12:13:19.815Z | 2024-09-14T12:22:51.799Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);