participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,358 rows where station_code = "NZ0007" 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 |
---|---|---|---|---|---|
5460233 | 5460233 | 20241101132032_b9Hwn | NZ0007 | 2024-11-03T14:13:30.201Z | 2024-11-03T14:19:33.504Z |
5460225 | 5460225 | 20241101131511_mRcAl | NZ0007 | 2024-11-03T14:13:29.297Z | 2024-11-03T14:19:33.502Z |
5460216 | 5460216 | 20241101131137_2Yfp2 | NZ0007 | 2024-11-03T14:13:28.341Z | 2024-11-03T14:19:33.499Z |
5460203 | 5460203 | 20241101130959_o2TSl | NZ0007 | 2024-11-03T14:13:27.922Z | 2024-11-03T14:19:33.497Z |
5460130 | 5460130 | 20241101125210_oPNAh | NZ0007 | 2024-11-03T14:13:23.351Z | 2024-11-03T14:19:33.483Z |
5460052 | 5460052 | 20241101123625_MUmj2 | NZ0007 | 2024-11-03T14:13:15.379Z | 2024-11-03T14:19:33.468Z |
5460047 | 5460047 | 20241101123555_LTuSz | NZ0007 | 2024-11-03T14:13:14.810Z | 2024-11-03T14:19:33.468Z |
5459982 | 5459982 | 20241101122743_NFtKg | NZ0007 | 2024-11-03T14:13:03.068Z | 2024-11-03T14:19:33.458Z |
5459513 | 5459513 | 20241101111058_lLUMb | NZ0007 | 2024-11-03T14:12:06.172Z | 2024-11-03T14:19:33.358Z |
5459494 | 5459494 | 20241101110801_NXzTH | NZ0007 | 2024-11-03T14:12:01.403Z | 2024-11-03T14:19:33.354Z |
5459456 | 5459456 | 20241101110209_ZhjzZ | NZ0007 | 2024-11-03T14:11:57.813Z | 2024-11-03T14:19:33.346Z |
5459284 | 5459284 | 20241101103838_CoL0q | NZ0007 | 2024-11-03T14:11:37.903Z | 2024-11-03T14:19:33.313Z |
5458730 | 5458730 | 20241101090646_Zkrwf | NZ0007 | 2024-11-03T14:10:31.803Z | 2024-11-03T14:19:33.184Z |
5457860 | 5457860 | 20241102153046_9GZ3r | NZ0007 | 2024-11-03T14:08:16.646Z | 2024-11-03T14:08:16.646Z |
5457463 | 5457463 | 20241102143351_TrhXp | NZ0007 | 2024-11-03T14:07:23.224Z | 2024-11-03T14:07:23.224Z |
5457315 | 5457315 | 20241102140935_RGwWO | NZ0007 | 2024-11-03T14:07:06.648Z | 2024-11-03T14:07:06.648Z |
5457240 | 5457240 | 20241102135553_rryZT | NZ0007 | 2024-11-03T14:06:58.508Z | 2024-11-03T14:06:58.508Z |
5456973 | 5456973 | 20241102130303_iQPmA | NZ0007 | 2024-11-03T14:06:15.640Z | 2024-11-03T14:06:15.640Z |
5456921 | 5456921 | 20241102125315_hw8DT | NZ0007 | 2024-11-03T14:06:02.036Z | 2024-11-03T14:06:02.036Z |
5449574 | 5449574 | 20241031155626_a254H | NZ0007 | 2024-11-02T12:13:08.271Z | 2024-11-03T14:20:55.142Z |
5448905 | 5448905 | 20241031142957_vtzk5 | NZ0007 | 2024-11-02T12:11:43.316Z | 2024-11-03T14:20:44.621Z |
5448892 | 5448892 | 20241031142817_65dwv | NZ0007 | 2024-11-02T12:11:40.091Z | 2024-11-03T14:20:44.056Z |
5448665 | 5448665 | 20241031140254_gA9fX | NZ0007 | 2024-11-02T12:11:16.512Z | 2024-11-03T14:20:41.042Z |
5448522 | 5448522 | 20241031134310_PviZH | NZ0007 | 2024-11-02T12:10:59.801Z | 2024-11-03T14:20:39.110Z |
5448509 | 5448509 | 20241031134037_8M9lx | NZ0007 | 2024-11-02T12:10:57.481Z | 2024-11-03T14:20:38.939Z |
5448464 | 5448464 | 20241031133359_l2PAw | NZ0007 | 2024-11-02T12:10:48.652Z | 2024-11-03T14:20:38.295Z |
5448455 | 5448455 | 20241031133343_DPg1w | NZ0007 | 2024-11-02T12:10:47.814Z | 2024-11-03T14:20:37.968Z |
5448446 | 5448446 | 20241031133248_rj4HE | NZ0007 | 2024-11-02T12:10:47.270Z | 2024-11-03T14:20:37.921Z |
5448443 | 5448443 | 20241031133239_rcr3w | NZ0007 | 2024-11-02T12:10:46.922Z | 2024-11-03T14:20:37.915Z |
5448416 | 5448416 | 20241031133054_TbLJy | NZ0007 | 2024-11-02T12:10:44.293Z | 2024-11-03T14:20:37.656Z |
5448407 | 5448407 | 20241031132812_av4zn | NZ0007 | 2024-11-02T12:10:42.668Z | 2024-11-03T14:20:36.816Z |
5448403 | 5448403 | 20241031132502_FCZEX | NZ0007 | 2024-11-02T12:10:41.537Z | 2024-11-03T14:20:36.746Z |
5448379 | 5448379 | 20241031132238_JXnqx | NZ0007 | 2024-11-02T12:10:39.798Z | 2024-11-03T14:20:36.607Z |
5448333 | 5448333 | 20241031131637_sHvN3 | NZ0007 | 2024-11-02T12:10:34.025Z | 2024-11-03T14:20:35.715Z |
5448304 | 5448304 | 20241031131101_e2o8N | NZ0007 | 2024-11-02T12:10:31.041Z | 2024-11-03T14:20:35.173Z |
5448158 | 5448158 | 20241031124951_6zNDB | NZ0007 | 2024-11-02T12:10:07.945Z | 2024-11-03T14:20:33.617Z |
5448133 | 5448133 | 20241031124751_eaU2Z | NZ0007 | 2024-11-02T12:10:02.846Z | 2024-11-03T14:20:33.241Z |
5447962 | 5447962 | 20241031122654_g915t | NZ0007 | 2024-11-02T12:09:31.785Z | 2024-11-03T14:20:30.843Z |
5447794 | 5447794 | 20241031121129_CJ02X | NZ0007 | 2024-11-02T12:09:06.844Z | 2024-11-03T14:20:28.255Z |
5447693 | 5447693 | 20241031120251_msXlc | NZ0007 | 2024-11-02T12:08:50.037Z | 2024-11-03T14:20:26.384Z |
5447594 | 5447594 | 20241031115454_uwFrD | NZ0007 | 2024-11-02T12:08:33.424Z | 2024-11-03T14:20:24.964Z |
5447308 | 5447308 | 20241031112946_iO15q | NZ0007 | 2024-11-02T12:07:44.865Z | 2024-11-03T14:20:20.666Z |
5447157 | 5447157 | 20241031111409_W4bjh | NZ0007 | 2024-11-02T12:07:24.335Z | 2024-11-03T14:20:16.906Z |
5447055 | 5447055 | 20241031110245_dKl2V | NZ0007 | 2024-11-02T12:07:02.638Z | 2024-11-03T14:20:15.180Z |
5446850 | 5446850 | 20241031103911_bjnuF | NZ0007 | 2024-11-02T12:06:32.011Z | 2024-11-03T14:20:10.182Z |
5446125 | 5446125 | 20241031092945_PB52A | NZ0007 | 2024-11-02T12:04:18.915Z | 2024-11-03T14:19:55.787Z |
5444660 | 5444660 | 20241028141436_js7Lr | NZ0007 | 2024-11-01T12:22:06.485Z | 2024-11-03T14:24:45.471Z |
5436730 | 5436730 | 20241030134223_r3COI | NZ0007 | 2024-11-01T12:08:08.793Z | 2024-11-03T14:22:37.596Z |
5436723 | 5436723 | 20241030134134_b5swd | NZ0007 | 2024-11-01T12:08:08.099Z | 2024-11-03T14:22:37.591Z |
5435533 | 5435533 | 20241030114006_I1pZJ | NZ0007 | 2024-11-01T12:05:22.822Z | 2024-11-03T14:22:33.105Z |
5427845 | 5427845 | 20241028155122_4kVh6 | NZ0007 | 2024-10-31T12:14:05.500Z | 2024-11-03T14:24:49.041Z |
5427554 | 5427554 | 20241028151631_wQwfm | NZ0007 | 2024-10-31T12:13:37.688Z | 2024-11-03T14:24:48.004Z |
5427547 | 5427547 | 20241028151549_uMtic | NZ0007 | 2024-10-31T12:13:37.419Z | 2024-11-03T14:24:47.998Z |
5427442 | 5427442 | 20241028150745_EBhWA | NZ0007 | 2024-10-31T12:13:32.533Z | 2024-11-03T14:24:47.713Z |
5427406 | 5427406 | 20241028150319_3RQAc | NZ0007 | 2024-10-31T12:13:30.746Z | 2024-11-03T14:24:47.636Z |
5427357 | 5427357 | 20241028145958_getnI | NZ0007 | 2024-10-31T12:13:28.536Z | 2024-11-03T14:24:47.579Z |
5427288 | 5427288 | 20241028145429_yqXI8 | NZ0007 | 2024-10-31T12:13:24.286Z | 2024-11-03T14:24:46.519Z |
5427220 | 5427220 | 20241028144601_flHm6 | NZ0007 | 2024-10-31T12:13:20.816Z | 2024-11-03T14:24:46.366Z |
5427150 | 5427150 | 20241028143801_MLHdZ | NZ0007 | 2024-10-31T12:13:16.513Z | 2024-11-03T14:24:46.289Z |
5427064 | 5427064 | 20241028142802_hnVEF | NZ0007 | 2024-10-31T12:13:02.775Z | 2024-11-03T14:24:45.729Z |
5426972 | 5426972 | 20241028141733_rMttQ | NZ0007 | 2024-10-31T12:12:45.719Z | 2024-11-03T14:24:45.569Z |
5424987 | 5424987 | 20241029153801_ESD9V | NZ0007 | 2024-10-31T12:06:37.950Z | 2024-11-03T14:23:40.194Z |
5424924 | 5424924 | 20241029153240_92gPs | NZ0007 | 2024-10-31T12:06:30.150Z | 2024-11-03T14:23:39.781Z |
5424694 | 5424694 | 20241029150053_vuBz4 | NZ0007 | 2024-10-31T12:05:51.460Z | 2024-11-03T14:23:38.554Z |
5424561 | 5424561 | 20241029144551_yvvk9 | NZ0007 | 2024-10-31T12:05:24.959Z | 2024-11-03T14:23:38.112Z |
5424500 | 5424500 | 20241029143815_EQO7U | NZ0007 | 2024-10-31T12:05:14.548Z | 2024-11-03T14:23:37.915Z |
5424233 | 5424233 | 20241029134218_Q3Yer | NZ0007 | 2024-10-31T12:04:20.936Z | 2024-11-03T14:23:35.548Z |
5424205 | 5424205 | 20241029133829_jW3Zz | NZ0007 | 2024-10-31T12:04:17.246Z | 2024-11-03T14:23:35.428Z |
5424108 | 5424108 | 20241029130839_rbDio | NZ0007 | 2024-10-31T12:03:48.309Z | 2024-11-03T14:23:34.382Z |
5422562 | 5422562 | 20241028131541_gDwX1 | NZ0007 | 2024-10-30T12:20:27.825Z | 2024-11-03T14:24:42.700Z |
5422421 | 5422421 | 20241028130105_JNuNu | NZ0007 | 2024-10-30T12:20:26.532Z | 2024-11-03T14:24:42.086Z |
5422156 | 5422156 | 20241028122314_qgd6I | NZ0007 | 2024-10-30T12:20:23.098Z | 2024-11-03T14:24:41.173Z |
5416426 | 5416426 | 20241027155238_UWZF5 | NZ0007 | 2024-10-30T12:11:34.924Z | 2024-11-03T14:25:42.187Z |
5416317 | 5416317 | 20241027154259_Ki1o0 | NZ0007 | 2024-10-30T12:11:27.839Z | 2024-11-03T14:25:42.096Z |
5382051 | 5382051 | 20241024155954_gTavT | NZ0007 | 2024-10-27T12:13:10.269Z | 2024-11-02T12:28:23.400Z |
5382046 | 5382046 | 20241024155945_yD7dg | NZ0007 | 2024-10-27T12:13:09.916Z | 2024-11-02T12:28:23.397Z |
5381971 | 5381971 | 20241024155403_ESQsa | NZ0007 | 2024-10-27T12:13:05.250Z | 2024-11-02T12:28:23.339Z |
5381930 | 5381930 | 20241024154944_XObIS | NZ0007 | 2024-10-27T12:13:02.598Z | 2024-11-02T12:28:23.279Z |
5381852 | 5381852 | 20241024154322_1k4Op | NZ0007 | 2024-10-27T12:12:52.830Z | 2024-11-02T12:28:23.221Z |
5371723 | 5371723 | 20241024151534_2U3lR | NZ0007 | 2024-10-26T12:12:29.123Z | 2024-11-02T12:28:22.722Z |
5371666 | 5371666 | 20241024151233_GImMC | NZ0007 | 2024-10-26T12:12:20.417Z | 2024-11-02T12:28:22.565Z |
5371660 | 5371660 | 20241024151210_7Pitq | NZ0007 | 2024-10-26T12:12:20.257Z | 2024-11-02T12:28:22.561Z |
5371653 | 5371653 | 20241024151114_1Ol36 | NZ0007 | 2024-10-26T12:12:19.242Z | 2024-11-02T12:28:22.538Z |
5371643 | 5371643 | 20241024151041_FqweZ | NZ0007 | 2024-10-26T12:12:18.798Z | 2024-11-02T12:28:22.495Z |
5371632 | 5371632 | 20241024151004_Ze4YG | NZ0007 | 2024-10-26T12:12:18.321Z | 2024-11-02T12:28:22.444Z |
5371518 | 5371518 | 20241024145925_B2BgP | NZ0007 | 2024-10-26T12:12:05.297Z | 2024-11-02T12:28:22.345Z |
5371503 | 5371503 | 20241024145729_69dNN | NZ0007 | 2024-10-26T12:12:04.434Z | 2024-11-02T12:28:22.329Z |
5371473 | 5371473 | 20241024145545_GwHW9 | NZ0007 | 2024-10-26T12:12:02.515Z | 2024-11-02T12:28:22.285Z |
5371430 | 5371430 | 20241024145324_zqHnt | NZ0007 | 2024-10-26T12:11:58.432Z | 2024-11-02T12:28:22.234Z |
5371425 | 5371425 | 20241024145249_tTPq2 | NZ0007 | 2024-10-26T12:11:57.624Z | 2024-11-02T12:28:22.222Z |
5371227 | 5371227 | 20241024143400_NFpPt | NZ0007 | 2024-10-26T12:11:26.218Z | 2024-11-02T12:28:21.875Z |
5371182 | 5371182 | 20241024142949_6wdc1 | NZ0007 | 2024-10-26T12:11:19.824Z | 2024-11-02T12:28:21.854Z |
5371051 | 5371051 | 20241024142108_6ozTd | NZ0007 | 2024-10-26T12:11:07.936Z | 2024-11-02T12:28:21.746Z |
5371015 | 5371015 | 20241024141629_NXrqw | NZ0007 | 2024-10-26T12:10:55.194Z | 2024-11-02T12:28:21.693Z |
5371005 | 5371005 | 20241024141402_pRp4r | NZ0007 | 2024-10-26T12:10:51.936Z | 2024-11-02T12:28:21.655Z |
5370901 | 5370901 | 20241024140409_cPwm7 | NZ0007 | 2024-10-26T12:10:37.278Z | 2024-11-02T12:28:21.571Z |
5370864 | 5370864 | 20241024140145_4zgUU | NZ0007 | 2024-10-26T12:10:34.061Z | 2024-11-02T12:28:21.519Z |
5370813 | 5370813 | 20241024135641_sBwFy | NZ0007 | 2024-10-26T12:10:30.056Z | 2024-11-02T12:28:21.393Z |
5370655 | 5370655 | 20241024133447_HfxDc | NZ0007 | 2024-10-26T12:10:07.511Z | 2024-11-02T12:28:21.031Z |
5370626 | 5370626 | 20241024133225_2nChe | NZ0007 | 2024-10-26T12:10:04.103Z | 2024-11-02T12:28:20.989Z |
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);