participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,434 rows where station_code = "NZ0051" 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 |
---|---|---|---|---|---|
5569449 | 5569449 | 20241121153321_iu2bI | NZ0051 | 2024-11-22T14:10:53.842Z | 2024-11-22T14:10:53.842Z |
5569438 | 5569438 | 20241121153007_33ryN | NZ0051 | 2024-11-22T14:10:52.861Z | 2024-11-22T14:10:52.861Z |
5569434 | 5569434 | 20241121152947_YygU3 | NZ0051 | 2024-11-22T14:10:52.520Z | 2024-11-22T14:10:52.520Z |
5569427 | 5569427 | 20241121152733_cZAP3 | NZ0051 | 2024-11-22T14:10:52.104Z | 2024-11-22T14:10:52.104Z |
5569227 | 5569227 | 20241121145402_m4Q2K | NZ0051 | 2024-11-22T14:10:40.561Z | 2024-11-22T14:10:40.561Z |
5569080 | 5569080 | 20241121142800_ccArN | NZ0051 | 2024-11-22T14:10:17.758Z | 2024-11-22T14:10:17.758Z |
5569052 | 5569052 | 20241121142442_aG4ax | NZ0051 | 2024-11-22T14:10:14.909Z | 2024-11-22T14:10:14.909Z |
5569048 | 5569048 | 20241121142441_5SVFq | NZ0051 | 2024-11-22T14:10:14.643Z | 2024-11-22T14:10:14.643Z |
5568984 | 5568984 | 20241121141231_r2t8v | NZ0051 | 2024-11-22T14:10:08.984Z | 2024-11-22T14:10:08.984Z |
5568898 | 5568898 | 20241121135921_sIiCT | NZ0051 | 2024-11-22T14:10:02.511Z | 2024-11-22T14:10:02.511Z |
5568817 | 5568817 | 20241121134333_CZGb9 | NZ0051 | 2024-11-22T14:09:49.075Z | 2024-11-22T14:09:49.075Z |
5568790 | 5568790 | 20241121133312_EU7jz | NZ0051 | 2024-11-22T14:09:42.734Z | 2024-11-22T14:09:42.734Z |
5568786 | 5568786 | 20241121133257_HqdDg | NZ0051 | 2024-11-22T14:09:42.277Z | 2024-11-22T14:09:42.277Z |
5568592 | 5568592 | 20241121130944_DxiA5 | NZ0051 | 2024-11-22T14:09:24.189Z | 2024-11-22T14:09:24.189Z |
5568561 | 5568561 | 20241121130050_HKo1o | NZ0051 | 2024-11-22T14:09:20.738Z | 2024-11-22T14:09:20.738Z |
5568470 | 5568470 | 20241121125036_QaxwU | NZ0051 | 2024-11-22T14:09:02.027Z | 2024-11-22T14:09:02.027Z |
5568417 | 5568417 | 20241121124326_YF1ih | NZ0051 | 2024-11-22T14:08:54.649Z | 2024-11-22T14:08:54.649Z |
5568383 | 5568383 | 20241121123538_LO4qN | NZ0051 | 2024-11-22T14:08:50.369Z | 2024-11-22T14:08:50.369Z |
5568372 | 5568372 | 20241121123418_JjmXK | NZ0051 | 2024-11-22T14:08:49.327Z | 2024-11-22T14:08:49.327Z |
5568152 | 5568152 | 20241121115617_EWOlm | NZ0051 | 2024-11-22T14:08:13.638Z | 2024-11-22T14:08:13.638Z |
5567962 | 5567962 | 20241121113648_V2WkC | NZ0051 | 2024-11-22T14:07:52.146Z | 2024-11-22T14:07:52.146Z |
5567901 | 5567901 | 20241121112700_3VtzZ | NZ0051 | 2024-11-22T14:07:32.122Z | 2024-11-22T14:07:32.122Z |
5567823 | 5567823 | 20241121111549_eZxzN | NZ0051 | 2024-11-22T14:07:19.915Z | 2024-11-22T14:07:19.915Z |
5567759 | 5567759 | 20241121110033_1Vgr2 | NZ0051 | 2024-11-22T14:07:12.982Z | 2024-11-22T14:07:12.982Z |
5567583 | 5567583 | 20241121104105_eoho2 | NZ0051 | 2024-11-22T14:06:34.283Z | 2024-11-22T14:06:34.283Z |
5567577 | 5567577 | 20241121103917_7AdrV | NZ0051 | 2024-11-22T14:06:33.245Z | 2024-11-22T14:06:33.245Z |
5567300 | 5567300 | 20241121100040_xdy8L | NZ0051 | 2024-11-22T14:05:49.236Z | 2024-11-22T14:05:49.236Z |
5567267 | 5567267 | 20241121095400_lm6ct | NZ0051 | 2024-11-22T14:05:43.942Z | 2024-11-22T14:05:43.942Z |
5567193 | 5567193 | 20241121093835_1743l | NZ0051 | 2024-11-22T14:05:32.243Z | 2024-11-22T14:05:32.243Z |
5567110 | 5567110 | 20241121092406_L4WLn | NZ0051 | 2024-11-22T14:05:20.810Z | 2024-11-22T14:05:20.810Z |
5567008 | 5567008 | 20241121085600_u6JVw | NZ0051 | 2024-11-22T14:04:52.535Z | 2024-11-22T14:04:52.535Z |
5560979 | 5560979 | 20241120154253_d2CV9 | NZ0051 | 2024-11-21T14:10:07.941Z | 2024-11-22T14:19:21.776Z |
5560950 | 5560950 | 20241120152722_AtaJR | NZ0051 | 2024-11-21T14:10:03.928Z | 2024-11-22T14:19:21.768Z |
5560935 | 5560935 | 20241120152432_X7LdN | NZ0051 | 2024-11-21T14:09:59.393Z | 2024-11-22T14:19:21.764Z |
5560933 | 5560933 | 20241120152425_STRt9 | NZ0051 | 2024-11-21T14:09:59.317Z | 2024-11-22T14:19:21.763Z |
5560931 | 5560931 | 20241120152423_MEHy2 | NZ0051 | 2024-11-21T14:09:59.125Z | 2024-11-22T14:19:21.762Z |
5560862 | 5560862 | 20241120145700_U4jfL | NZ0051 | 2024-11-21T14:09:53.348Z | 2024-11-22T14:19:21.749Z |
5560818 | 5560818 | 20241120143537_EGmc9 | NZ0051 | 2024-11-21T14:09:48.027Z | 2024-11-22T14:19:21.739Z |
5560789 | 5560789 | 20241120142319_idTR6 | NZ0051 | 2024-11-21T14:09:44.800Z | 2024-11-22T14:19:21.732Z |
5560785 | 5560785 | 20241120142230_cXa3L | NZ0051 | 2024-11-21T14:09:44.608Z | 2024-11-22T14:19:21.732Z |
5560775 | 5560775 | 20241120142151_Unbc0 | NZ0051 | 2024-11-21T14:09:44.002Z | 2024-11-22T14:19:21.730Z |
5560756 | 5560756 | 20241120141558_A2QQe | NZ0051 | 2024-11-21T14:09:42.349Z | 2024-11-22T14:19:21.727Z |
5560691 | 5560691 | 20241120135637_OV40I | NZ0051 | 2024-11-21T14:09:28.615Z | 2024-11-22T14:19:21.714Z |
5560660 | 5560660 | 20241120134550_O15SL | NZ0051 | 2024-11-21T14:09:22.248Z | 2024-11-22T14:19:21.707Z |
5560650 | 5560650 | 20241120134046_rUc5L | NZ0051 | 2024-11-21T14:09:21.209Z | 2024-11-22T14:19:21.706Z |
5560642 | 5560642 | 20241120133755_WO8qK | NZ0051 | 2024-11-21T14:09:19.527Z | 2024-11-22T14:19:21.704Z |
5560634 | 5560634 | 20241120133046_MfraD | NZ0051 | 2024-11-21T14:09:18.394Z | 2024-11-22T14:19:21.701Z |
5560625 | 5560625 | 20241120132747_pThcw | NZ0051 | 2024-11-21T14:09:16.524Z | 2024-11-22T14:19:21.699Z |
5560616 | 5560616 | 20241120132504_Ls2A8 | NZ0051 | 2024-11-21T14:09:15.472Z | 2024-11-22T14:19:21.696Z |
5560604 | 5560604 | 20241120132040_RMJmF | NZ0051 | 2024-11-21T14:09:12.671Z | 2024-11-22T14:19:21.693Z |
5560588 | 5560588 | 20241120131801_UF2je | NZ0051 | 2024-11-21T14:09:09.857Z | 2024-11-22T14:19:21.690Z |
5560514 | 5560514 | 20241120130451_bV2Q7 | NZ0051 | 2024-11-21T14:09:00.193Z | 2024-11-22T14:19:21.676Z |
5560279 | 5560279 | 20241120122925_E70Cu | NZ0051 | 2024-11-21T14:08:29.060Z | 2024-11-22T14:19:21.627Z |
5560249 | 5560249 | 20241120122418_LHy3d | NZ0051 | 2024-11-21T14:08:24.203Z | 2024-11-22T14:19:21.620Z |
5560142 | 5560142 | 20241120120727_tw0Ul | NZ0051 | 2024-11-21T14:08:07.422Z | 2024-11-22T14:19:21.597Z |
5560096 | 5560096 | 20241120115759_Qp2JL | NZ0051 | 2024-11-21T14:08:01.896Z | 2024-11-22T14:19:21.586Z |
5560017 | 5560017 | 20241120114629_falW7 | NZ0051 | 2024-11-21T14:07:52.170Z | 2024-11-22T14:19:21.569Z |
5559962 | 5559962 | 20241120113913_DUWY7 | NZ0051 | 2024-11-21T14:07:41.834Z | 2024-11-22T14:19:21.557Z |
5559802 | 5559802 | 20241120111850_3K3Lp | NZ0051 | 2024-11-21T14:07:12.891Z | 2024-11-22T14:19:21.527Z |
5559778 | 5559778 | 20241120111652_lIuU8 | NZ0051 | 2024-11-21T14:07:10.531Z | 2024-11-22T14:19:21.523Z |
5556233 | 5556233 | 20241118114637_eX9Ss | NZ0051 | 2024-11-20T14:08:45.819Z | 2024-11-22T14:22:06.687Z |
5551884 | 5551884 | 20241118153229_C3zZ9 | NZ0051 | 2024-11-19T14:05:45.938Z | 2024-11-22T14:22:12.884Z |
5551878 | 5551878 | 20241118153201_ZxDqx | NZ0051 | 2024-11-19T14:05:45.413Z | 2024-11-22T14:22:12.857Z |
5551657 | 5551657 | 20241118143630_dhbg6 | NZ0051 | 2024-11-19T14:05:07.844Z | 2024-11-22T14:22:11.937Z |
5551620 | 5551620 | 20241118142856_Mgsvh | NZ0051 | 2024-11-19T14:05:05.256Z | 2024-11-22T14:22:11.727Z |
5551613 | 5551613 | 20241118142826_OMsW2 | NZ0051 | 2024-11-19T14:05:04.684Z | 2024-11-22T14:22:11.709Z |
5551583 | 5551583 | 20241118142007_FUkzY | NZ0051 | 2024-11-19T14:05:01.218Z | 2024-11-22T14:22:11.502Z |
5551502 | 5551502 | 20241118140021_9ViQH | NZ0051 | 2024-11-19T14:04:54.346Z | 2024-11-22T14:22:11.086Z |
5551434 | 5551434 | 20241118133530_ne43Q | NZ0051 | 2024-11-19T14:04:46.579Z | 2024-11-22T14:22:10.652Z |
5551396 | 5551396 | 20241118132510_haubB | NZ0051 | 2024-11-19T14:04:43.990Z | 2024-11-22T14:22:10.517Z |
5551351 | 5551351 | 20241118131027_4eH8Q | NZ0051 | 2024-11-19T14:04:33.185Z | 2024-11-22T14:22:10.296Z |
5551303 | 5551303 | 20241118125954_ZUp3q | NZ0051 | 2024-11-19T14:04:20.352Z | 2024-11-22T14:22:09.899Z |
5551218 | 5551218 | 20241118124531_cIYwm | NZ0051 | 2024-11-19T14:04:07.282Z | 2024-11-22T14:22:09.279Z |
5551150 | 5551150 | 20241118123331_tlUyo | NZ0051 | 2024-11-19T14:03:59.755Z | 2024-11-22T14:22:08.711Z |
5551094 | 5551094 | 20241118122428_rmUB3 | NZ0051 | 2024-11-19T14:03:53.990Z | 2024-11-22T14:22:08.206Z |
5551046 | 5551046 | 20241118121356_jitUi | NZ0051 | 2024-11-19T14:03:49.633Z | 2024-11-22T14:22:07.897Z |
5550988 | 5550988 | 20241118120700_9picy | NZ0051 | 2024-11-19T14:03:44.410Z | 2024-11-22T14:22:07.415Z |
5550971 | 5550971 | 20241118120500_svt5Y | NZ0051 | 2024-11-19T14:03:42.688Z | 2024-11-22T14:22:07.288Z |
5550826 | 5550826 | 20241118113210_QA9Ym | NZ0051 | 2024-11-19T14:03:10.121Z | 2024-11-22T14:22:05.949Z |
5550815 | 5550815 | 20241118113120_bPyye | NZ0051 | 2024-11-19T14:03:09.347Z | 2024-11-22T14:22:05.905Z |
5550609 | 5550609 | 20241118105542_gWKU5 | NZ0051 | 2024-11-19T14:02:48.289Z | 2024-11-22T14:22:04.308Z |
5550398 | 5550398 | 20241118101639_JOO12 | NZ0051 | 2024-11-19T14:02:17.057Z | 2024-11-22T14:22:02.669Z |
5550393 | 5550393 | 20241118101549_j1QoN | NZ0051 | 2024-11-19T14:02:16.775Z | 2024-11-22T14:22:02.659Z |
5547278 | 5547278 | 20241117152439_FBbjL | NZ0051 | 2024-11-18T14:05:24.468Z | 2024-11-22T14:22:38.310Z |
5547114 | 5547114 | 20241117144727_kEBau | NZ0051 | 2024-11-18T14:05:05.177Z | 2024-11-22T14:22:37.125Z |
5547097 | 5547097 | 20241117144123_Do3qR | NZ0051 | 2024-11-18T14:04:58.286Z | 2024-11-22T14:22:36.831Z |
5547088 | 5547088 | 20241117143911_dI5in | NZ0051 | 2024-11-18T14:04:56.329Z | 2024-11-22T14:22:36.793Z |
5546979 | 5546979 | 20241117134939_kKDO3 | NZ0051 | 2024-11-18T14:04:36.392Z | 2024-11-22T14:22:36.007Z |
5546964 | 5546964 | 20241117134615_T7UGe | NZ0051 | 2024-11-18T14:04:33.900Z | 2024-11-22T14:22:35.818Z |
5546918 | 5546918 | 20241117132316_cy7lt | NZ0051 | 2024-11-18T14:04:27.349Z | 2024-11-22T14:22:35.415Z |
5546885 | 5546885 | 20241117131503_c37zO | NZ0051 | 2024-11-18T14:04:24.156Z | 2024-11-22T14:22:35.261Z |
5546873 | 5546873 | 20241117130912_NM2XL | NZ0051 | 2024-11-18T14:04:23.056Z | 2024-11-22T14:22:35.231Z |
5546594 | 5546594 | 20241117114952_A8MLd | NZ0051 | 2024-11-18T14:03:35.279Z | 2024-11-22T14:22:33.244Z |
5546497 | 5546497 | 20241117111516_RwpVU | NZ0051 | 2024-11-18T14:03:13.442Z | 2024-11-22T14:22:32.264Z |
5546470 | 5546470 | 20241117110603_KuNDn | NZ0051 | 2024-11-18T14:03:10.991Z | 2024-11-22T14:22:32.152Z |
5546054 | 5546054 | 20241117090022_09zlU | NZ0051 | 2024-11-18T14:01:51.783Z | 2024-11-22T14:22:28.622Z |
5546047 | 5546047 | 20241117085829_WiFCc | NZ0051 | 2024-11-18T14:01:50.459Z | 2024-11-22T14:22:28.451Z |
5546039 | 5546039 | 20241117085549_d05P9 | NZ0051 | 2024-11-18T14:01:47.783Z | 2024-11-22T14:22:28.306Z |
5544819 | 5544819 | 20241116154903_3LeJJ | NZ0051 | 2024-11-17T14:02:13.842Z | 2024-11-22T14:23:06.453Z |
5544803 | 5544803 | 20241116153712_5l2E8 | NZ0051 | 2024-11-17T14:02:09.312Z | 2024-11-22T14:23:06.312Z |
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);