participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,990 rows where station_code = "NZ0016" 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 |
---|---|---|---|---|---|
5096338 | 5096338 | 20240912103601_RRmZd | NZ0016 | 2024-09-16T12:16:20.956Z | 2024-09-18T12:14:09.978Z |
5083684 | 5083684 | 20240911141056_cY5lM | NZ0016 | 2024-09-15T12:18:45.495Z | 2024-09-18T12:15:04.521Z |
5083614 | 5083614 | 20240911135800_LulOC | NZ0016 | 2024-09-15T12:18:44.619Z | 2024-09-18T12:15:04.313Z |
5083576 | 5083576 | 20240911135339_Vcuut | NZ0016 | 2024-09-15T12:18:44.241Z | 2024-09-18T12:15:04.146Z |
5083334 | 5083334 | 20240911125741_p8knK | NZ0016 | 2024-09-15T12:18:39.594Z | 2024-09-18T12:15:03.428Z |
5083259 | 5083259 | 20240911123858_nD0pP | NZ0016 | 2024-09-15T12:18:37.714Z | 2024-09-18T12:15:02.979Z |
5082478 | 5082478 | 20240911101449_NQ26a | NZ0016 | 2024-09-15T12:18:16.108Z | 2024-09-18T12:14:59.241Z |
5082455 | 5082455 | 20240911101110_dcnsN | NZ0016 | 2024-09-15T12:18:15.494Z | 2024-09-18T12:14:59.201Z |
5082369 | 5082369 | 20240911100027_Rmjco | NZ0016 | 2024-09-15T12:18:12.930Z | 2024-09-18T12:14:58.876Z |
5082143 | 5082143 | 20240911092824_iE3mt | NZ0016 | 2024-09-15T12:18:04.546Z | 2024-09-18T12:14:57.796Z |
5081373 | 5081373 | 20240911073223_oix7j | NZ0016 | 2024-09-15T12:17:31.764Z | 2024-09-18T12:14:53.582Z |
5070814 | 5070814 | 20240911151221_7BjeF | NZ0016 | 2024-09-15T12:00:55.876Z | 2024-09-18T12:13:36.238Z |
5070758 | 5070758 | 20240911150745_HZ24e | NZ0016 | 2024-09-15T12:00:46.815Z | 2024-09-18T12:13:36.181Z |
5070595 | 5070595 | 20240911143723_PBWSR | NZ0016 | 2024-09-15T12:00:22.893Z | 2024-09-18T12:13:35.654Z |
5068960 | 5068960 | 20240910131323_DeQfp | NZ0016 | 2024-09-14T12:19:23.295Z | 2024-09-18T12:15:26.897Z |
5068916 | 5068916 | 20240910125924_hOAk2 | NZ0016 | 2024-09-14T12:19:22.900Z | 2024-09-18T12:15:26.846Z |
5068906 | 5068906 | 20240910125759_2E384 | NZ0016 | 2024-09-14T12:19:22.800Z | 2024-09-18T12:15:26.813Z |
5068800 | 5068800 | 20240910122827_7SlRE | NZ0016 | 2024-09-14T12:19:21.634Z | 2024-09-18T12:15:26.698Z |
5068320 | 5068320 | 20240910112024_j01eG | NZ0016 | 2024-09-14T12:19:12.077Z | 2024-09-18T12:15:25.917Z |
5058894 | 5058894 | 20240910165543_Nzi6i | NZ0016 | 2024-09-14T12:04:46.767Z | 2024-09-18T12:14:30.722Z |
5058779 | 5058779 | 20240910164612_nSsX2 | NZ0016 | 2024-09-14T12:04:31.436Z | 2024-09-18T12:14:30.235Z |
5058467 | 5058467 | 20240910161435_EZjSy | NZ0016 | 2024-09-14T12:03:45.296Z | 2024-09-18T12:14:29.341Z |
5058413 | 5058413 | 20240910161127_Ry7Wu | NZ0016 | 2024-09-14T12:03:40.065Z | 2024-09-18T12:14:29.202Z |
5058347 | 5058347 | 20240910160606_K5gE2 | NZ0016 | 2024-09-14T12:03:34.130Z | 2024-09-18T12:14:28.861Z |
5058006 | 5058006 | 20240910153511_WZXdx | NZ0016 | 2024-09-14T12:02:36.313Z | 2024-09-18T12:14:27.037Z |
5058001 | 5058001 | 20240910153511_BSIjA | NZ0016 | 2024-09-14T12:02:36.113Z | 2024-09-18T12:14:27.036Z |
5057685 | 5057685 | 20240910150430_r4edx | NZ0016 | 2024-09-14T12:01:44.240Z | 2024-09-18T12:14:24.503Z |
5056385 | 5056385 | 20240908102113_nub2f | NZ0016 | 2024-09-13T12:17:31.173Z | 2024-09-16T12:21:24.829Z |
5056242 | 5056242 | 20240908100006_HgJ8e | NZ0016 | 2024-09-13T12:17:28.856Z | 2024-09-16T12:21:24.029Z |
5056081 | 5056081 | 20240908093828_Dl9wl | NZ0016 | 2024-09-13T12:17:27.406Z | 2024-09-16T12:21:23.272Z |
5055886 | 5055886 | 20240908091406_a2u7e | NZ0016 | 2024-09-13T12:17:24.889Z | 2024-09-16T12:21:22.485Z |
5055825 | 5055825 | 20240908090809_WK0Zg | NZ0016 | 2024-09-13T12:17:23.643Z | 2024-09-16T12:21:22.159Z |
5042106 | 5042106 | 20240906095558_wJrkb | NZ0016 | 2024-09-12T12:16:55.510Z | 2024-09-14T12:23:16.021Z |
5042062 | 5042062 | 20240906094648_B3Lju | NZ0016 | 2024-09-12T12:16:54.689Z | 2024-09-14T12:23:15.894Z |
5041487 | 5041487 | 20240906082440_25fFz | NZ0016 | 2024-09-12T12:16:43.062Z | 2024-09-14T12:23:13.752Z |
5037954 | 5037954 | 20240905170841_EtCYw | NZ0016 | 2024-09-12T12:14:17.992Z | 2024-09-14T12:22:54.841Z |
5037888 | 5037888 | 20240905165939_MCXHi | NZ0016 | 2024-09-12T12:14:16.817Z | 2024-09-14T12:22:54.759Z |
5037850 | 5037850 | 20240905165721_20ZSV | NZ0016 | 2024-09-12T12:14:16.256Z | 2024-09-14T12:22:54.743Z |
5037846 | 5037846 | 20240905165721_AFtNL | NZ0016 | 2024-09-12T12:14:16.196Z | 2024-09-14T12:22:54.742Z |
5037341 | 5037341 | 20240905154002_f8BiJ | NZ0016 | 2024-09-12T12:14:05.337Z | 2024-09-14T12:22:54.125Z |
5037300 | 5037300 | 20240905153455_JohYb | NZ0016 | 2024-09-12T12:14:04.546Z | 2024-09-14T12:22:54.085Z |
5037040 | 5037040 | 20240905145754_RJtQL | NZ0016 | 2024-09-12T12:13:59.614Z | 2024-09-14T12:22:53.645Z |
5036854 | 5036854 | 20240905143549_6W2qY | NZ0016 | 2024-09-12T12:13:56.139Z | 2024-09-14T12:22:53.302Z |
5036532 | 5036532 | 20240905134523_hstE6 | NZ0016 | 2024-09-12T12:13:46.330Z | 2024-09-14T12:22:52.539Z |
5028738 | 5028738 | 20240905104445_e3fgC | NZ0016 | 2024-09-11T12:15:47.213Z | 2024-09-14T12:22:49.283Z |
5027579 | 5027579 | 20240905075605_bYRTn | NZ0016 | 2024-09-11T12:14:18.194Z | 2024-09-13T12:20:03.831Z |
5023799 | 5023799 | 20240905170841_GkuDL | NZ0016 | 2024-09-10T12:16:50.326Z | 2024-09-14T12:22:54.839Z |
5023731 | 5023731 | 20240905165939_tmDPx | NZ0016 | 2024-09-10T12:16:49.699Z | 2024-09-11T12:16:31.759Z |
5023695 | 5023695 | 20240905165721_D2CqD | NZ0016 | 2024-09-10T12:16:49.333Z | 2024-09-11T12:16:31.749Z |
5023691 | 5023691 | 20240905165721_f0L0v | NZ0016 | 2024-09-10T12:16:49.330Z | 2024-09-11T12:16:31.748Z |
5023220 | 5023220 | 20240905154002_8ZYZW | NZ0016 | 2024-09-10T12:16:40.884Z | 2024-09-11T12:16:31.587Z |
5023181 | 5023181 | 20240905153455_wD5cH | NZ0016 | 2024-09-10T12:16:40.215Z | 2024-09-11T12:16:31.567Z |
5022021 | 5022021 | 20240905075606_iufgh | NZ0016 | 2024-09-10T12:16:01.815Z | 2024-09-13T12:20:03.832Z |
5018372 | 5018372 | 20240904175007_0WIar | NZ0016 | 2024-09-10T12:10:31.816Z | 2024-09-13T12:19:47.659Z |
5017543 | 5017543 | 20240904161734_mIM0p | NZ0016 | 2024-09-10T12:09:14.735Z | 2024-09-13T12:19:46.918Z |
5017478 | 5017478 | 20240904161139_FQi1U | NZ0016 | 2024-09-10T12:09:12.015Z | 2024-09-13T12:19:46.892Z |
5017389 | 5017389 | 20240904160420_TXmUD | NZ0016 | 2024-09-10T12:09:07.473Z | 2024-09-13T12:19:46.842Z |
5017175 | 5017175 | 20240904153822_QUN3Z | NZ0016 | 2024-09-10T12:08:54.277Z | 2024-09-13T12:19:46.628Z |
5017020 | 5017020 | 20240904152324_tZP4C | NZ0016 | 2024-09-10T12:08:40.106Z | 2024-09-13T12:19:46.501Z |
5016994 | 5016994 | 20240904152046_I1ds3 | NZ0016 | 2024-09-10T12:08:37.960Z | 2024-09-13T12:19:46.491Z |
5016692 | 5016692 | 20240904144227_5uA2q | NZ0016 | 2024-09-10T12:08:09.264Z | 2024-09-13T12:19:46.010Z |
5016582 | 5016582 | 20240904142929_sq8Wu | NZ0016 | 2024-09-10T12:07:58.762Z | 2024-09-13T12:19:45.865Z |
5016212 | 5016212 | 20240904134421_n2T69 | NZ0016 | 2024-09-10T12:07:34.287Z | 2024-09-13T12:19:45.347Z |
5016126 | 5016126 | 20240904133438_ysDM3 | NZ0016 | 2024-09-10T12:07:28.295Z | 2024-09-13T12:19:45.272Z |
5016058 | 5016058 | 20240904132546_4LTjF | NZ0016 | 2024-09-10T12:07:17.969Z | 2024-09-13T12:19:45.172Z |
5016038 | 5016038 | 20240904132400_hDhA0 | NZ0016 | 2024-09-10T12:07:15.293Z | 2024-09-13T12:19:45.143Z |
5015955 | 5015955 | 20240904130702_GG4S2 | NZ0016 | 2024-09-10T12:07:04.612Z | 2024-09-13T12:19:45.067Z |
5015913 | 5015913 | 20240904130100_xv6iJ | NZ0016 | 2024-09-10T12:06:58.897Z | 2024-09-13T12:19:44.928Z |
5015831 | 5015831 | 20240904124231_W6RPY | NZ0016 | 2024-09-10T12:06:49.779Z | 2024-09-13T12:19:44.727Z |
5015788 | 5015788 | 20240904123340_SFGXj | NZ0016 | 2024-09-10T12:06:46.691Z | 2024-09-13T12:19:44.658Z |
5015781 | 5015781 | 20240904123005_nvqdY | NZ0016 | 2024-09-10T12:06:46.153Z | 2024-09-13T12:19:44.656Z |
5015718 | 5015718 | 20240904122017_SQ345 | NZ0016 | 2024-09-10T12:06:41.566Z | 2024-09-13T12:19:44.624Z |
5015579 | 5015579 | 20240904115543_qVplN | NZ0016 | 2024-09-10T12:06:28.357Z | 2024-09-13T12:19:44.357Z |
5015360 | 5015360 | 20240905150347_jLfFK | NZ0016 | 2024-09-10T12:05:09.957Z | 2024-09-14T12:22:53.683Z |
5015327 | 5015327 | 20240905145754_7eqFA | NZ0016 | 2024-09-10T12:05:00.087Z | 2024-09-11T12:16:31.455Z |
5015149 | 5015149 | 20240905143550_ZLS4u | NZ0016 | 2024-09-10T12:04:34.781Z | 2024-09-14T12:22:53.302Z |
5014847 | 5014847 | 20240905134523_n1S2L | NZ0016 | 2024-09-10T12:04:02.159Z | 2024-09-11T12:16:31.302Z |
5013548 | 5013548 | 20240905104445_vEMUu | NZ0016 | 2024-09-10T12:00:56.897Z | 2024-09-14T12:22:49.284Z |
5006236 | 5006236 | 20240903170811_ciWWU | NZ0016 | 2024-09-09T12:04:26.114Z | 2024-09-12T12:19:08.012Z |
5005813 | 5005813 | 20240903161535_ZckZV | NZ0016 | 2024-09-09T12:04:08.205Z | 2024-09-12T12:19:06.938Z |
5005383 | 5005383 | 20240903150421_Y1VYm | NZ0016 | 2024-09-09T12:03:39.782Z | 2024-09-12T12:19:05.848Z |
5005220 | 5005220 | 20240903143321_aW0jr | NZ0016 | 2024-09-09T12:03:27.367Z | 2024-09-12T12:19:05.488Z |
5005045 | 5005045 | 20240903135106_1Zx2Z | NZ0016 | 2024-09-09T12:03:17.488Z | 2024-09-12T12:19:05.175Z |
4995070 | 4995070 | 20240902160928_CvHcg | NZ0016 | 2024-09-08T12:03:14.176Z | 2024-09-11T12:20:41.678Z |
4994992 | 4994992 | 20240902155454_wYS3W | NZ0016 | 2024-09-08T12:03:09.900Z | 2024-09-11T12:20:40.927Z |
4994972 | 4994972 | 20240902154934_GXk3o | NZ0016 | 2024-09-08T12:03:08.811Z | 2024-09-11T12:20:40.711Z |
4994854 | 4994854 | 20240902152606_biYpC | NZ0016 | 2024-09-08T12:03:02.740Z | 2024-09-11T12:20:39.852Z |
4994767 | 4994767 | 20240902151011_80gJ5 | NZ0016 | 2024-09-08T12:02:57.123Z | 2024-09-11T12:20:38.782Z |
4994651 | 4994651 | 20240902145153_BKIYf | NZ0016 | 2024-09-08T12:02:49.750Z | 2024-09-11T12:20:36.264Z |
4994588 | 4994588 | 20240902143623_xxAoA | NZ0016 | 2024-09-08T12:02:44.336Z | 2024-09-11T12:20:35.435Z |
4994401 | 4994401 | 20240902135301_ChQmV | NZ0016 | 2024-09-08T12:02:33.043Z | 2024-09-11T12:20:33.555Z |
4985516 | 4985516 | 20240901124043_ccZnl | NZ0016 | 2024-09-07T12:03:23.671Z | 2024-09-10T12:19:07.979Z |
4985164 | 4985164 | 20240901114016_xPT5P | NZ0016 | 2024-09-07T12:02:55.798Z | 2024-09-10T12:19:07.082Z |
4985061 | 4985061 | 20240901112525_Srl43 | NZ0016 | 2024-09-07T12:02:47.564Z | 2024-09-10T12:19:06.878Z |
4985031 | 4985031 | 20240901112135_0PzQz | NZ0016 | 2024-09-07T12:02:45.181Z | 2024-09-10T12:19:06.811Z |
4984653 | 4984653 | 20240901103518_OpLmx | NZ0016 | 2024-09-07T12:02:12.823Z | 2024-09-10T12:19:05.726Z |
4984647 | 4984647 | 20240901103515_oOoG0 | NZ0016 | 2024-09-07T12:02:12.566Z | 2024-09-10T12:19:05.724Z |
4984330 | 4984330 | 20240901094600_kfO3N | NZ0016 | 2024-09-07T12:01:45.383Z | 2024-09-10T12:19:05.120Z |
4984050 | 4984050 | 20240901085400_q6xCN | NZ0016 | 2024-09-07T12:01:17.170Z | 2024-09-10T12:19:04.340Z |
4961437 | 4961437 | 20240811174107_of4EZ | NZ0016 | 2024-09-04T12:03:39.552Z | 2024-09-06T12:02:59.075Z |
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);