participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,974 rows where station_code = "NZ003E" 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 |
---|---|---|---|---|---|
5569713 | 5569713 | 20241120132647_5dPuq | NZ003E | 2024-11-22T14:13:43.847Z | 2024-11-22T14:19:21.698Z |
5569415 | 5569415 | 20241121152555_L1A8u | NZ003E | 2024-11-22T14:10:51.424Z | 2024-11-22T14:10:51.424Z |
5569388 | 5569388 | 20241121152204_aEgWX | NZ003E | 2024-11-22T14:10:50.250Z | 2024-11-22T14:10:50.250Z |
5569317 | 5569317 | 20241121150806_C2wqk | NZ003E | 2024-11-22T14:10:45.447Z | 2024-11-22T14:10:45.447Z |
5569235 | 5569235 | 20241121145506_rjDQH | NZ003E | 2024-11-22T14:10:41.190Z | 2024-11-22T14:10:41.190Z |
5569012 | 5569012 | 20241121141912_ZNt0u | NZ003E | 2024-11-22T14:10:11.314Z | 2024-11-22T14:10:11.314Z |
5568979 | 5568979 | 20241121141221_9LGTn | NZ003E | 2024-11-22T14:10:08.603Z | 2024-11-22T14:10:08.603Z |
5568909 | 5568909 | 20241121140208_8o4Ld | NZ003E | 2024-11-22T14:10:03.315Z | 2024-11-22T14:10:03.315Z |
5568845 | 5568845 | 20241121134802_XaJlm | NZ003E | 2024-11-22T14:09:58.468Z | 2024-11-22T14:09:58.468Z |
5568674 | 5568674 | 20241121132014_93Z85 | NZ003E | 2024-11-22T14:09:32.779Z | 2024-11-22T14:09:32.779Z |
5568640 | 5568640 | 20241121131705_3s7Ea | NZ003E | 2024-11-22T14:09:28.713Z | 2024-11-22T14:09:28.713Z |
5568476 | 5568476 | 20241121125150_7jgkB | NZ003E | 2024-11-22T14:09:02.940Z | 2024-11-22T14:09:02.940Z |
5568464 | 5568464 | 20241121124933_W1JEB | NZ003E | 2024-11-22T14:09:00.271Z | 2024-11-22T14:09:00.271Z |
5568363 | 5568363 | 20241121123112_cScL5 | NZ003E | 2024-11-22T14:08:48.244Z | 2024-11-22T14:08:48.244Z |
5568271 | 5568271 | 20241121121614_K9CO2 | NZ003E | 2024-11-22T14:08:37.485Z | 2024-11-22T14:08:37.485Z |
5568262 | 5568262 | 20241121121542_nPK38 | NZ003E | 2024-11-22T14:08:36.784Z | 2024-11-22T14:08:36.784Z |
5568177 | 5568177 | 20241121120128_FVvrC | NZ003E | 2024-11-22T14:08:18.287Z | 2024-11-22T14:08:18.287Z |
5568068 | 5568068 | 20241121114602_uojWd | NZ003E | 2024-11-22T14:08:03.018Z | 2024-11-22T14:08:03.018Z |
5567875 | 5567875 | 20241121112044_UT9vh | NZ003E | 2024-11-22T14:07:28.379Z | 2024-11-22T14:07:28.379Z |
5560926 | 5560926 | 20241120152216_E77Q2 | NZ003E | 2024-11-21T14:09:58.868Z | 2024-11-22T14:19:21.762Z |
5560905 | 5560905 | 20241120151809_lgsTF | NZ003E | 2024-11-21T14:09:57.196Z | 2024-11-22T14:19:21.757Z |
5560903 | 5560903 | 20241120151715_f2ca9 | NZ003E | 2024-11-21T14:09:56.916Z | 2024-11-22T14:19:21.757Z |
5560895 | 5560895 | 20241120151405_FfxpS | NZ003E | 2024-11-21T14:09:56.187Z | 2024-11-22T14:19:21.755Z |
5560889 | 5560889 | 20241120150933_I5O33 | NZ003E | 2024-11-21T14:09:55.453Z | 2024-11-22T14:19:21.754Z |
5560870 | 5560870 | 20241120150455_S2LkO | NZ003E | 2024-11-21T14:09:54.236Z | 2024-11-22T14:19:21.751Z |
5558811 | 5558811 | 20241120081152_ZRJuw | NZ003E | 2024-11-21T14:04:27.930Z | 2024-11-22T14:19:21.305Z |
5555509 | 5555509 | 20241119133850_rEVwV | NZ003E | 2024-11-20T14:05:53.427Z | 2024-11-22T14:20:07.873Z |
5555488 | 5555488 | 20241119133118_D75Fl | NZ003E | 2024-11-20T14:05:51.084Z | 2024-11-22T14:20:07.482Z |
5555124 | 5555124 | 20241119115109_C7FHf | NZ003E | 2024-11-20T14:04:30.787Z | 2024-11-22T14:19:59.334Z |
5555100 | 5555100 | 20241119114442_gu3iC | NZ003E | 2024-11-20T14:04:27.643Z | 2024-11-22T14:19:58.424Z |
5554545 | 5554545 | 20241119093047_Qzjbm | NZ003E | 2024-11-20T14:02:24.899Z | 2024-11-22T14:19:43.225Z |
5554502 | 5554502 | 20241119091904_IGDTr | NZ003E | 2024-11-20T14:02:19.005Z | 2024-11-22T14:19:42.330Z |
5551893 | 5551893 | 20241118153559_Glpyi | NZ003E | 2024-11-19T14:05:46.763Z | 2024-11-22T14:22:12.927Z |
5551845 | 5551845 | 20241118152340_KsOu2 | NZ003E | 2024-11-19T14:05:43.152Z | 2024-11-22T14:22:12.718Z |
5551835 | 5551835 | 20241118152244_2LFFA | NZ003E | 2024-11-19T14:05:41.101Z | 2024-11-22T14:22:12.650Z |
5551692 | 5551692 | 20241118144536_xT377 | NZ003E | 2024-11-19T14:05:14.367Z | 2024-11-22T14:22:12.140Z |
5551671 | 5551671 | 20241118144023_3AIM5 | NZ003E | 2024-11-19T14:05:09.716Z | 2024-11-22T14:22:11.982Z |
5551653 | 5551653 | 20241118143608_5lldX | NZ003E | 2024-11-19T14:05:07.550Z | 2024-11-22T14:22:11.936Z |
5551645 | 5551645 | 20241118143413_ZddVJ | NZ003E | 2024-11-19T14:05:07.263Z | 2024-11-22T14:22:11.907Z |
5551628 | 5551628 | 20241118143012_9Eb7E | NZ003E | 2024-11-19T14:05:06.039Z | 2024-11-22T14:22:11.805Z |
5551593 | 5551593 | 20241118142227_3UWpH | NZ003E | 2024-11-19T14:05:02.685Z | 2024-11-22T14:22:11.555Z |
5551392 | 5551392 | 20241118132233_8V6xt | NZ003E | 2024-11-19T14:04:43.602Z | 2024-11-22T14:22:10.487Z |
5550876 | 5550876 | 20241118114029_81Yom | NZ003E | 2024-11-19T14:03:16.664Z | 2024-11-22T14:22:06.380Z |
5550689 | 5550689 | 20241118110943_R5ikq | NZ003E | 2024-11-19T14:02:55.353Z | 2024-11-22T14:22:04.864Z |
5550513 | 5550513 | 20241118103624_W5rbh | NZ003E | 2024-11-19T14:02:28.930Z | 2024-11-22T14:22:03.617Z |
5550477 | 5550477 | 20241118102431_jCRxv | NZ003E | 2024-11-19T14:02:24.030Z | 2024-11-22T14:22:03.285Z |
5550412 | 5550412 | 20241118101750_72uPF | NZ003E | 2024-11-19T14:02:18.663Z | 2024-11-22T14:22:02.783Z |
5550282 | 5550282 | 20241118095844_9SqQ1 | NZ003E | 2024-11-19T14:02:03.460Z | 2024-11-22T14:22:00.694Z |
5550205 | 5550205 | 20241118094618_UjUAq | NZ003E | 2024-11-19T14:01:45.835Z | 2024-11-22T14:21:59.625Z |
5550175 | 5550175 | 20241118094333_rrpl2 | NZ003E | 2024-11-19T14:01:41.457Z | 2024-11-22T14:21:59.256Z |
5550100 | 5550100 | 20241118093004_OvQgg | NZ003E | 2024-11-19T14:01:34.467Z | 2024-11-22T14:21:58.122Z |
5550084 | 5550084 | 20241118092906_o3Mhp | NZ003E | 2024-11-19T14:01:33.449Z | 2024-11-22T14:21:57.900Z |
5550019 | 5550019 | 20241118090905_mOJJB | NZ003E | 2024-11-19T14:01:27.221Z | 2024-11-22T14:21:56.872Z |
5549897 | 5549897 | 20241118083546_MVa7m | NZ003E | 2024-11-19T14:01:10.375Z | 2024-11-22T14:21:54.795Z |
5547126 | 5547126 | 20241117145620_eozo6 | NZ003E | 2024-11-18T14:05:08.710Z | 2024-11-22T14:22:37.311Z |
5547074 | 5547074 | 20241117143540_pL5f2 | NZ003E | 2024-11-18T14:04:54.052Z | 2024-11-22T14:22:36.645Z |
5546151 | 5546151 | 20241117093117_ugCC2 | NZ003E | 2024-11-18T14:02:19.147Z | 2024-11-22T14:22:29.596Z |
5546142 | 5546142 | 20241117092447_3WIcT | NZ003E | 2024-11-18T14:02:17.086Z | 2024-11-22T14:22:29.554Z |
5535640 | 5535640 | 20241112132200_JQN9H | NZ003E | 2024-11-14T14:08:13.229Z | 2024-11-21T14:25:50.784Z |
5535531 | 5535531 | 20241112124524_WI42H | NZ003E | 2024-11-14T14:08:02.576Z | 2024-11-21T14:25:49.474Z |
5526768 | 5526768 | 20241112101251_tenSr | NZ003E | 2024-11-13T14:04:07.320Z | 2024-11-21T14:25:38.157Z |
5520248 | 5520248 | 20241111150302_VVnLc | NZ003E | 2024-11-12T14:06:01.955Z | 2024-11-20T14:25:06.316Z |
5520233 | 5520233 | 20241111150136_fkNRo | NZ003E | 2024-11-12T14:06:00.050Z | 2024-11-20T14:25:06.163Z |
5520225 | 5520225 | 20241111145916_oO4lw | NZ003E | 2024-11-12T14:05:59.452Z | 2024-11-20T14:25:05.990Z |
5520181 | 5520181 | 20241111145449_rSKX7 | NZ003E | 2024-11-12T14:05:52.668Z | 2024-11-20T14:25:05.488Z |
5520170 | 5520170 | 20241111145328_ydHTv | NZ003E | 2024-11-12T14:05:47.840Z | 2024-11-20T14:25:05.335Z |
5520135 | 5520135 | 20241111144507_B7k7u | NZ003E | 2024-11-12T14:05:41.151Z | 2024-11-20T14:25:04.206Z |
5520121 | 5520121 | 20241111144159_lCySs | NZ003E | 2024-11-12T14:05:39.668Z | 2024-11-20T14:25:04.115Z |
5520107 | 5520107 | 20241111143753_i37je | NZ003E | 2024-11-12T14:05:37.409Z | 2024-11-20T14:25:03.767Z |
5519772 | 5519772 | 20241111125823_WYi2H | NZ003E | 2024-11-12T14:04:57.649Z | 2024-11-20T14:24:57.629Z |
5519727 | 5519727 | 20241111124255_20pYv | NZ003E | 2024-11-12T14:04:51.046Z | 2024-11-20T14:24:56.239Z |
5519714 | 5519714 | 20241111123723_AZ6kw | NZ003E | 2024-11-12T14:04:48.823Z | 2024-11-20T14:24:55.840Z |
5518628 | 5518628 | 20241111084016_MtWo1 | NZ003E | 2024-11-12T14:01:32.589Z | 2024-11-20T14:24:38.031Z |
5513471 | 5513471 | 20241110113519_HFIWT | NZ003E | 2024-11-11T14:04:41.595Z | 2024-11-19T14:21:34.619Z |
5500540 | 5500540 | 20241108160223_PJHcn | NZ003E | 2024-11-09T14:06:29.246Z | 2024-11-17T14:23:23.459Z |
5500294 | 5500294 | 20241108151442_PDX73 | NZ003E | 2024-11-09T14:06:04.563Z | 2024-11-17T14:23:21.176Z |
5500263 | 5500263 | 20241108150911_WzkNj | NZ003E | 2024-11-09T14:06:01.975Z | 2024-11-17T14:23:20.918Z |
5500258 | 5500258 | 20241108150911_LA7Lf | NZ003E | 2024-11-09T14:06:01.756Z | 2024-11-17T14:23:20.913Z |
5500240 | 5500240 | 20241108150700_b6BMP | NZ003E | 2024-11-09T14:06:00.530Z | 2024-11-17T14:23:20.273Z |
5500227 | 5500227 | 20241108150600_ROyn7 | NZ003E | 2024-11-09T14:05:59.655Z | 2024-11-17T14:23:20.231Z |
5500211 | 5500211 | 20241108150437_33TlA | NZ003E | 2024-11-09T14:05:58.983Z | 2024-11-17T14:23:20.140Z |
5500175 | 5500175 | 20241108150125_Aqhm8 | NZ003E | 2024-11-09T14:05:56.945Z | 2024-11-17T14:23:19.988Z |
5500061 | 5500061 | 20241108143552_aUqOr | NZ003E | 2024-11-09T14:05:38.103Z | 2024-11-17T14:23:18.444Z |
5499997 | 5499997 | 20241108142115_b3FiQ | NZ003E | 2024-11-09T14:05:28.362Z | 2024-11-17T14:23:17.917Z |
5499970 | 5499970 | 20241108141635_yI5IJ | NZ003E | 2024-11-09T14:05:24.939Z | 2024-11-17T14:23:17.725Z |
5499954 | 5499954 | 20241108141339_62tMf | NZ003E | 2024-11-09T14:05:23.849Z | 2024-11-17T14:23:17.584Z |
5499887 | 5499887 | 20241108135406_jZuok | NZ003E | 2024-11-09T14:05:08.427Z | 2024-11-17T14:23:16.703Z |
5499831 | 5499831 | 20241108134318_tmlUP | NZ003E | 2024-11-09T14:05:02.537Z | 2024-11-17T14:23:16.314Z |
5499810 | 5499810 | 20241108133821_BAy7C | NZ003E | 2024-11-09T14:04:59.764Z | 2024-11-17T14:23:16.218Z |
5499705 | 5499705 | 20241108130456_XhvTR | NZ003E | 2024-11-09T14:04:47.347Z | 2024-11-17T14:23:14.650Z |
5499394 | 5499394 | 20241108121108_NXSXC | NZ003E | 2024-11-09T14:03:59.740Z | 2024-11-17T14:23:10.837Z |
5498872 | 5498872 | 20241108101737_RI1Va | NZ003E | 2024-11-09T14:02:40.472Z | 2024-11-17T14:23:00.892Z |
5498729 | 5498729 | 20241108094348_9jjW5 | NZ003E | 2024-11-09T14:02:16.987Z | 2024-11-17T14:22:59.381Z |
5498423 | 5498423 | 20241108082916_Yg6he | NZ003E | 2024-11-09T14:01:27.601Z | 2024-11-17T14:22:54.580Z |
5494006 | 5494006 | 20241107150913_gQcNe | NZ003E | 2024-11-08T14:05:14.815Z | 2024-11-16T14:27:44.817Z |
5493412 | 5493412 | 20241107120632_1cMz1 | NZ003E | 2024-11-08T14:03:42.997Z | 2024-11-16T14:27:34.109Z |
5493404 | 5493404 | 20241107120514_BRvm3 | NZ003E | 2024-11-08T14:03:42.061Z | 2024-11-16T14:27:34.078Z |
5492799 | 5492799 | 20241107095653_3KCkj | NZ003E | 2024-11-08T14:02:06.912Z | 2024-11-16T14:27:28.992Z |
5492649 | 5492649 | 20241107092353_4iMMk | NZ003E | 2024-11-08T14:01:44.580Z | 2024-11-16T14:27:27.199Z |
5492540 | 5492540 | 20241107085801_iRP2K | NZ003E | 2024-11-08T14:01:23.009Z | 2024-11-16T14:27:26.663Z |
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);