participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,299 rows where station_code = "NZ003U" 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 |
---|---|---|---|---|---|
5560949 | 5560949 | 20241120152722_AtaJR | NZ003U | 2024-11-21T14:10:03.927Z | 2024-11-21T14:10:03.927Z |
5560749 | 5560749 | 20241120141509_CjaeG | NZ003U | 2024-11-21T14:09:42.118Z | 2024-11-21T14:09:42.118Z |
5560708 | 5560708 | 20241120140045_XToNe | NZ003U | 2024-11-21T14:09:33.375Z | 2024-11-21T14:09:33.375Z |
5560673 | 5560673 | 20241120135128_MvJOY | NZ003U | 2024-11-21T14:09:24.243Z | 2024-11-21T14:09:24.243Z |
5560655 | 5560655 | 20241120134550_O15SL | NZ003U | 2024-11-21T14:09:22.248Z | 2024-11-21T14:09:22.248Z |
5560649 | 5560649 | 20241120134046_rUc5L | NZ003U | 2024-11-21T14:09:21.209Z | 2024-11-21T14:09:21.209Z |
5560648 | 5560648 | 20241120134009_7JwFo | NZ003U | 2024-11-21T14:09:20.831Z | 2024-11-21T14:09:20.831Z |
5560623 | 5560623 | 20241120132747_pThcw | NZ003U | 2024-11-21T14:09:16.524Z | 2024-11-21T14:09:16.524Z |
5560614 | 5560614 | 20241120132504_Ls2A8 | NZ003U | 2024-11-21T14:09:15.472Z | 2024-11-21T14:09:15.472Z |
5560544 | 5560544 | 20241120130803_NhfUG | NZ003U | 2024-11-21T14:09:04.008Z | 2024-11-21T14:09:04.008Z |
5560538 | 5560538 | 20241120130756_Qh7BI | NZ003U | 2024-11-21T14:09:03.520Z | 2024-11-21T14:09:03.520Z |
5560452 | 5560452 | 20241120125320_q93QS | NZ003U | 2024-11-21T14:08:53.524Z | 2024-11-21T14:08:53.524Z |
5560437 | 5560437 | 20241120125205_LAZg7 | NZ003U | 2024-11-21T14:08:51.545Z | 2024-11-21T14:08:51.545Z |
5560426 | 5560426 | 20241120125056_Ig13Z | NZ003U | 2024-11-21T14:08:50.299Z | 2024-11-21T14:08:50.299Z |
5560410 | 5560410 | 20241120124843_wpK0c | NZ003U | 2024-11-21T14:08:48.338Z | 2024-11-21T14:08:48.338Z |
5560396 | 5560396 | 20241120124634_nUuNv | NZ003U | 2024-11-21T14:08:47.018Z | 2024-11-21T14:08:47.018Z |
5560355 | 5560355 | 20241120124146_rR2Xc | NZ003U | 2024-11-21T14:08:43.252Z | 2024-11-21T14:08:43.252Z |
5560290 | 5560290 | 20241120123011_Lu6mk | NZ003U | 2024-11-21T14:08:32.016Z | 2024-11-21T14:08:32.016Z |
5560248 | 5560248 | 20241120122418_LHy3d | NZ003U | 2024-11-21T14:08:24.203Z | 2024-11-21T14:08:24.203Z |
5560092 | 5560092 | 20241120115759_Qp2JL | NZ003U | 2024-11-21T14:08:01.896Z | 2024-11-21T14:08:01.896Z |
5560064 | 5560064 | 20241120115351_CVKnk | NZ003U | 2024-11-21T14:07:58.207Z | 2024-11-21T14:07:58.207Z |
5559878 | 5559878 | 20241120112853_Vi5j5 | NZ003U | 2024-11-21T14:07:25.524Z | 2024-11-21T14:07:25.524Z |
5559840 | 5559840 | 20241120112301_zyiMG | NZ003U | 2024-11-21T14:07:18.700Z | 2024-11-21T14:07:18.700Z |
5559825 | 5559825 | 20241120112200_d5g1h | NZ003U | 2024-11-21T14:07:16.881Z | 2024-11-21T14:07:16.881Z |
5559705 | 5559705 | 20241120110146_PLxqn | NZ003U | 2024-11-21T14:07:00.596Z | 2024-11-21T14:07:00.596Z |
5559644 | 5559644 | 20241120105335_UUGeo | NZ003U | 2024-11-21T14:06:51.487Z | 2024-11-21T14:06:51.487Z |
5559620 | 5559620 | 20241120105023_Zg2WA | NZ003U | 2024-11-21T14:06:44.929Z | 2024-11-21T14:06:44.929Z |
5559398 | 5559398 | 20241120101843_XJhOC | NZ003U | 2024-11-21T14:06:14.235Z | 2024-11-21T14:06:14.235Z |
5559312 | 5559312 | 20241120100231_F9srm | NZ003U | 2024-11-21T14:05:56.597Z | 2024-11-21T14:05:56.597Z |
5559042 | 5559042 | 20241120090746_M2P84 | NZ003U | 2024-11-21T14:05:08.270Z | 2024-11-21T14:05:08.270Z |
5558966 | 5558966 | 20241120090002_VpWkX | NZ003U | 2024-11-21T14:04:54.821Z | 2024-11-21T14:04:54.821Z |
5557250 | 5557250 | 20241117150344_e0XZa | NZ003U | 2024-11-20T14:14:15.968Z | 2024-11-21T14:21:36.699Z |
5555757 | 5555757 | 20241119154052_mSElt | NZ003U | 2024-11-20T14:06:32.563Z | 2024-11-21T14:18:53.342Z |
5555741 | 5555741 | 20241119152309_PurUp | NZ003U | 2024-11-20T14:06:31.055Z | 2024-11-21T14:18:53.339Z |
5555673 | 5555673 | 20241119143307_vPBwG | NZ003U | 2024-11-20T14:06:22.927Z | 2024-11-21T14:18:53.324Z |
5555654 | 5555654 | 20241119142318_n2p7d | NZ003U | 2024-11-20T14:06:20.579Z | 2024-11-21T14:18:53.321Z |
5555633 | 5555633 | 20241119141210_tgBqo | NZ003U | 2024-11-20T14:06:11.404Z | 2024-11-21T14:18:53.316Z |
5555607 | 5555607 | 20241119140505_8FTr2 | NZ003U | 2024-11-20T14:06:05.828Z | 2024-11-21T14:18:53.309Z |
5555604 | 5555604 | 20241119140341_vYooS | NZ003U | 2024-11-20T14:06:05.093Z | 2024-11-21T14:18:53.308Z |
5555581 | 5555581 | 20241119135705_ppKB4 | NZ003U | 2024-11-20T14:06:02.507Z | 2024-11-21T14:18:53.304Z |
5555554 | 5555554 | 20241119135057_uiIpx | NZ003U | 2024-11-20T14:05:58.760Z | 2024-11-21T14:18:53.298Z |
5555516 | 5555516 | 20241119134024_2VUSO | NZ003U | 2024-11-20T14:05:54.532Z | 2024-11-21T14:18:53.293Z |
5555500 | 5555500 | 20241119133504_bLIRR | NZ003U | 2024-11-20T14:05:52.028Z | 2024-11-21T14:18:53.288Z |
5555468 | 5555468 | 20241119132458_CwWhg | NZ003U | 2024-11-20T14:05:43.009Z | 2024-11-21T14:18:53.283Z |
5555388 | 5555388 | 20241119130228_T76o6 | NZ003U | 2024-11-20T14:05:25.188Z | 2024-11-21T14:18:53.266Z |
5555354 | 5555354 | 20241119125420_iy26f | NZ003U | 2024-11-20T14:05:16.392Z | 2024-11-21T14:18:53.260Z |
5555319 | 5555319 | 20241119124037_K4nOO | NZ003U | 2024-11-20T14:05:10.760Z | 2024-11-21T14:18:53.251Z |
5555276 | 5555276 | 20241119123111_9dAA3 | NZ003U | 2024-11-20T14:05:04.416Z | 2024-11-21T14:18:53.241Z |
5554426 | 5554426 | 20241119085543_9v9sl | NZ003U | 2024-11-20T14:02:00.655Z | 2024-11-21T14:18:53.055Z |
5551810 | 5551810 | 20241118151946_3bOgz | NZ003U | 2024-11-19T14:05:34.763Z | 2024-11-21T14:20:04.125Z |
5551757 | 5551757 | 20241118150557_eeErT | NZ003U | 2024-11-19T14:05:24.584Z | 2024-11-21T14:20:02.480Z |
5551733 | 5551733 | 20241118145835_nY4To | NZ003U | 2024-11-19T14:05:22.058Z | 2024-11-21T14:20:02.241Z |
5551634 | 5551634 | 20241118143137_OVyS3 | NZ003U | 2024-11-19T14:05:06.230Z | 2024-11-21T14:19:58.108Z |
5551612 | 5551612 | 20241118142826_OMsW2 | NZ003U | 2024-11-19T14:05:04.684Z | 2024-11-21T14:19:57.915Z |
5551524 | 5551524 | 20241118140721_Fr2vV | NZ003U | 2024-11-19T14:04:56.716Z | 2024-11-21T14:19:55.362Z |
5551433 | 5551433 | 20241118133530_ne43Q | NZ003U | 2024-11-19T14:04:46.579Z | 2024-11-21T14:19:52.191Z |
5551366 | 5551366 | 20241118131619_p0cEN | NZ003U | 2024-11-19T14:04:37.451Z | 2024-11-21T14:19:49.537Z |
5551350 | 5551350 | 20241118131027_4eH8Q | NZ003U | 2024-11-19T14:04:33.185Z | 2024-11-21T14:19:49.352Z |
5551012 | 5551012 | 20241118120913_MCiZC | NZ003U | 2024-11-19T14:03:46.469Z | 2024-11-21T14:19:41.189Z |
5550987 | 5550987 | 20241118120700_9picy | NZ003U | 2024-11-19T14:03:44.410Z | 2024-11-21T14:19:40.677Z |
5550948 | 5550948 | 20241118115940_HgTxW | NZ003U | 2024-11-19T14:03:34.481Z | 2024-11-21T14:19:39.326Z |
5550824 | 5550824 | 20241118113210_QA9Ym | NZ003U | 2024-11-19T14:03:10.121Z | 2024-11-21T14:19:33.714Z |
5550739 | 5550739 | 20241118111914_tCU4Z | NZ003U | 2024-11-19T14:03:00.069Z | 2024-11-21T14:19:28.964Z |
5550547 | 5550547 | 20241118104414_2DXHa | NZ003U | 2024-11-19T14:02:33.613Z | 2024-11-21T14:19:23.553Z |
5550421 | 5550421 | 20241118101818_F38mG | NZ003U | 2024-11-19T14:02:18.946Z | 2024-11-21T14:19:17.963Z |
5550381 | 5550381 | 20241118101119_gXOQR | NZ003U | 2024-11-19T14:02:15.978Z | 2024-11-21T14:19:16.723Z |
5547304 | 5547304 | 20241117153406_4HgMt | NZ003U | 2024-11-18T14:05:26.982Z | 2024-11-21T14:21:38.620Z |
5547275 | 5547275 | 20241117152439_FBbjL | NZ003U | 2024-11-18T14:05:24.468Z | 2024-11-21T14:21:38.118Z |
5547179 | 5547179 | 20241117150344_G1fzq | NZ003U | 2024-11-18T14:05:13.718Z | 2024-11-21T14:21:36.712Z |
5547157 | 5547157 | 20241117145946_6QzRM | NZ003U | 2024-11-18T14:05:11.825Z | 2024-11-21T14:21:36.433Z |
5547140 | 5547140 | 20241117145842_EoWLd | NZ003U | 2024-11-18T14:05:10.231Z | 2024-11-21T14:21:36.092Z |
5547112 | 5547112 | 20241117144727_kEBau | NZ003U | 2024-11-18T14:05:05.176Z | 2024-11-21T14:21:35.445Z |
5547043 | 5547043 | 20241117142724_jhWJH | NZ003U | 2024-11-18T14:04:46.584Z | 2024-11-21T14:21:34.636Z |
5546996 | 5546996 | 20241117140631_oCPmx | NZ003U | 2024-11-18T14:04:40.789Z | 2024-11-21T14:21:33.368Z |
5546977 | 5546977 | 20241117134939_kKDO3 | NZ003U | 2024-11-18T14:04:36.392Z | 2024-11-21T14:21:31.687Z |
5546963 | 5546963 | 20241117134615_T7UGe | NZ003U | 2024-11-18T14:04:33.900Z | 2024-11-21T14:21:31.450Z |
5546910 | 5546910 | 20241117132248_9eIuk | NZ003U | 2024-11-18T14:04:27.083Z | 2024-11-21T14:21:29.235Z |
5546841 | 5546841 | 20241117125903_FqTL2 | NZ003U | 2024-11-18T14:04:19.753Z | 2024-11-21T14:21:27.748Z |
5546697 | 5546697 | 20241117121736_8ONRS | NZ003U | 2024-11-18T14:03:52.303Z | 2024-11-21T14:21:24.378Z |
5546211 | 5546211 | 20241117094802_kJdtR | NZ003U | 2024-11-18T14:02:28.078Z | 2024-11-21T14:21:13.767Z |
5546190 | 5546190 | 20241117093913_dm2ay | NZ003U | 2024-11-18T14:02:24.862Z | 2024-11-21T14:21:13.250Z |
5546146 | 5546146 | 20241117092753_Cs14M | NZ003U | 2024-11-18T14:02:18.123Z | 2024-11-21T14:21:11.624Z |
5546053 | 5546053 | 20241117090022_09zlU | NZ003U | 2024-11-18T14:01:51.783Z | 2024-11-21T14:21:09.554Z |
5546037 | 5546037 | 20241117085549_d05P9 | NZ003U | 2024-11-18T14:01:47.767Z | 2024-11-21T14:21:09.148Z |
5544796 | 5544796 | 20241116152533_ll8h3 | NZ003U | 2024-11-17T14:02:07.646Z | 2024-11-21T14:22:40.561Z |
5544792 | 5544792 | 20241116152426_Ch2TD | NZ003U | 2024-11-17T14:02:07.186Z | 2024-11-21T14:22:40.541Z |
5544773 | 5544773 | 20241116151501_hM9Ov | NZ003U | 2024-11-17T14:02:03.694Z | 2024-11-21T14:22:40.266Z |
5544712 | 5544712 | 20241116144204_0Y5nQ | NZ003U | 2024-11-17T14:01:53.888Z | 2024-11-21T14:22:39.678Z |
5544684 | 5544684 | 20241116142114_7ngEL | NZ003U | 2024-11-17T14:01:50.706Z | 2024-11-21T14:22:38.927Z |
5544667 | 5544667 | 20241116140047_hX3Rz | NZ003U | 2024-11-17T14:01:48.444Z | 2024-11-21T14:22:38.825Z |
5544489 | 5544489 | 20241116114418_HGXAY | NZ003U | 2024-11-17T14:01:17.210Z | 2024-11-21T14:22:34.637Z |
5541154 | 5541154 | 20241113112222_oa8p7 | NZ003U | 2024-11-15T14:06:29.013Z | 2024-11-21T14:25:00.030Z |
5536109 | 5536109 | 20241112154115_sjuLs | NZ003U | 2024-11-14T14:09:12.055Z | 2024-11-21T14:25:56.725Z |
5527259 | 5527259 | 20241111125829_NdKaG | NZ003U | 2024-11-13T14:07:11.817Z | 2024-11-20T14:24:57.773Z |
5520422 | 5520422 | 20241111154527_Loemj | NZ003U | 2024-11-12T14:06:18.402Z | 2024-11-20T14:25:08.668Z |
5520344 | 5520344 | 20241111152428_6jOX3 | NZ003U | 2024-11-12T14:06:11.176Z | 2024-11-20T14:25:07.113Z |
5520246 | 5520246 | 20241111150240_AppnC | NZ003U | 2024-11-12T14:06:01.526Z | 2024-11-20T14:25:06.304Z |
5520197 | 5520197 | 20241111145725_bhWlu | NZ003U | 2024-11-12T14:05:57.000Z | 2024-11-20T14:25:05.739Z |
5520194 | 5520194 | 20241111145659_ufmNX | NZ003U | 2024-11-12T14:05:56.300Z | 2024-11-20T14:25:05.714Z |
5520174 | 5520174 | 20241111145348_Dhq6s | NZ003U | 2024-11-12T14:05:48.690Z | 2024-11-20T14:25:05.355Z |
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);