participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,246 rows where station_code = "NZ0035" 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 |
---|---|---|---|---|---|
5560810 | 5560810 | 20241120143255_KSxAa | NZ0035 | 2024-11-21T14:09:47.239Z | 2024-11-21T14:09:47.239Z |
5560801 | 5560801 | 20241120142802_fMK0i | NZ0035 | 2024-11-21T14:09:46.625Z | 2024-11-21T14:09:46.625Z |
5560772 | 5560772 | 20241120142151_Unbc0 | NZ0035 | 2024-11-21T14:09:44.002Z | 2024-11-21T14:09:44.002Z |
5560629 | 5560629 | 20241120132837_oZ8v7 | NZ0035 | 2024-11-21T14:09:17.499Z | 2024-11-21T14:09:17.499Z |
5560613 | 5560613 | 20241120132504_Ls2A8 | NZ0035 | 2024-11-21T14:09:15.472Z | 2024-11-21T14:09:15.472Z |
5560536 | 5560536 | 20241120130756_Qh7BI | NZ0035 | 2024-11-21T14:09:03.520Z | 2024-11-21T14:09:03.520Z |
5560394 | 5560394 | 20241120124634_nUuNv | NZ0035 | 2024-11-21T14:08:47.018Z | 2024-11-21T14:08:47.018Z |
5560381 | 5560381 | 20241120124534_0bCW8 | NZ0035 | 2024-11-21T14:08:46.515Z | 2024-11-21T14:08:46.515Z |
5557240 | 5557240 | 20241117100955_ltobG | NZ0035 | 2024-11-20T14:13:21.544Z | 2024-11-21T14:21:15.692Z |
5551918 | 5551918 | 20241118154017_r3hMJ | NZ0035 | 2024-11-19T14:05:47.850Z | 2024-11-21T14:20:06.779Z |
5551432 | 5551432 | 20241118133530_ne43Q | NZ0035 | 2024-11-19T14:04:46.579Z | 2024-11-21T14:19:52.191Z |
5550378 | 5550378 | 20241118101108_sbY9L | NZ0035 | 2024-11-19T14:02:15.706Z | 2024-11-21T14:19:16.512Z |
5550246 | 5550246 | 20241118095213_1zNKT | NZ0035 | 2024-11-19T14:01:55.490Z | 2024-11-21T14:19:10.910Z |
5549928 | 5549928 | 20241118084559_7Y343 | NZ0035 | 2024-11-19T14:01:15.042Z | 2024-11-21T14:19:02.846Z |
5549900 | 5549900 | 20241118083631_rm2PU | NZ0035 | 2024-11-19T14:01:11.401Z | 2024-11-21T14:19:02.488Z |
5547274 | 5547274 | 20241117152439_FBbjL | NZ0035 | 2024-11-18T14:05:24.468Z | 2024-11-21T14:21:38.118Z |
5547265 | 5547265 | 20241117152153_2vS93 | NZ0035 | 2024-11-18T14:05:23.521Z | 2024-11-21T14:21:37.673Z |
5547260 | 5547260 | 20241117152059_g47M5 | NZ0035 | 2024-11-18T14:05:22.706Z | 2024-11-21T14:21:37.633Z |
5547252 | 5547252 | 20241117151603_2UdqK | NZ0035 | 2024-11-18T14:05:21.748Z | 2024-11-21T14:21:37.551Z |
5547210 | 5547210 | 20241117150606_vwE9P | NZ0035 | 2024-11-18T14:05:16.825Z | 2024-11-21T14:21:36.989Z |
5546989 | 5546989 | 20241117140226_Q4Qbh | NZ0035 | 2024-11-18T14:04:39.998Z | 2024-11-21T14:21:32.904Z |
5546976 | 5546976 | 20241117134939_kKDO3 | NZ0035 | 2024-11-18T14:04:36.392Z | 2024-11-21T14:21:31.687Z |
5546962 | 5546962 | 20241117134615_T7UGe | NZ0035 | 2024-11-18T14:04:33.900Z | 2024-11-21T14:21:31.450Z |
5546635 | 5546635 | 20241117120033_w4JgB | NZ0035 | 2024-11-18T14:03:42.102Z | 2024-11-21T14:21:21.707Z |
5546495 | 5546495 | 20241117111516_RwpVU | NZ0035 | 2024-11-18T14:03:13.442Z | 2024-11-21T14:21:19.179Z |
5546468 | 5546468 | 20241117110603_KuNDn | NZ0035 | 2024-11-18T14:03:10.991Z | 2024-11-21T14:21:18.901Z |
5546096 | 5546096 | 20241117090802_clrTL | NZ0035 | 2024-11-18T14:02:01.565Z | 2024-11-21T14:21:10.325Z |
5544772 | 5544772 | 20241116151501_hM9Ov | NZ0035 | 2024-11-17T14:02:03.694Z | 2024-11-21T14:22:40.266Z |
5544682 | 5544682 | 20241116142114_7ngEL | NZ0035 | 2024-11-17T14:01:50.706Z | 2024-11-21T14:22:38.927Z |
5544370 | 5544370 | 20241116102700_3r2NB | NZ0035 | 2024-11-17T14:00:57.680Z | 2024-11-21T14:22:32.432Z |
5544307 | 5544307 | 20241116094923_3wSKo | NZ0035 | 2024-11-17T14:00:49.407Z | 2024-11-21T14:22:30.819Z |
5544236 | 5544236 | 20241116090424_Pd4a0 | NZ0035 | 2024-11-17T14:00:32.885Z | 2024-11-21T14:22:29.121Z |
5542082 | 5542082 | 20241112153314_MWwq8 | NZ0035 | 2024-11-15T14:11:29.583Z | 2024-11-21T14:25:56.449Z |
5535973 | 5535973 | 20241112150814_ibpL8 | NZ0035 | 2024-11-14T14:09:03.203Z | 2024-11-21T14:25:55.669Z |
5535916 | 5535916 | 20241112145300_6BRlM | NZ0035 | 2024-11-14T14:08:58.800Z | 2024-11-21T14:25:54.582Z |
5535841 | 5535841 | 20241112143645_LI5lF | NZ0035 | 2024-11-14T14:08:53.934Z | 2024-11-21T14:25:53.792Z |
5535829 | 5535829 | 20241112143443_1CPV3 | NZ0035 | 2024-11-14T14:08:52.991Z | 2024-11-21T14:25:53.699Z |
5535779 | 5535779 | 20241112142019_pCsnN | NZ0035 | 2024-11-14T14:08:49.206Z | 2024-11-21T14:25:53.075Z |
5535765 | 5535765 | 20241112141452_tSxlf | NZ0035 | 2024-11-14T14:08:47.263Z | 2024-11-21T14:25:52.900Z |
5535731 | 5535731 | 20241112140158_ypJys | NZ0035 | 2024-11-14T14:08:37.704Z | 2024-11-21T14:25:52.749Z |
5535720 | 5535720 | 20241112135617_3sxNh | NZ0035 | 2024-11-14T14:08:34.483Z | 2024-11-21T14:25:51.896Z |
5535662 | 5535662 | 20241112133440_V2vp2 | NZ0035 | 2024-11-14T14:08:17.535Z | 2024-11-21T14:25:50.880Z |
5535544 | 5535544 | 20241112124725_B8ZBT | NZ0035 | 2024-11-14T14:08:03.744Z | 2024-11-21T14:25:49.597Z |
5535503 | 5535503 | 20241112123942_EZlet | NZ0035 | 2024-11-14T14:08:00.785Z | 2024-11-21T14:25:48.691Z |
5535453 | 5535453 | 20241112123154_iiuTH | NZ0035 | 2024-11-14T14:07:57.338Z | 2024-11-21T14:25:48.442Z |
5535439 | 5535439 | 20241112122616_h42am | NZ0035 | 2024-11-14T14:07:56.423Z | 2024-11-21T14:25:48.374Z |
5535142 | 5535142 | 20241112114411_NtXMB | NZ0035 | 2024-11-14T14:07:18.364Z | 2024-11-21T14:25:44.170Z |
5527004 | 5527004 | 20241112104451_bzPAV | NZ0035 | 2024-11-13T14:04:50.007Z | 2024-11-21T14:25:40.247Z |
5526453 | 5526453 | 20241112092214_P1I9V | NZ0035 | 2024-11-13T14:03:07.518Z | 2024-11-21T14:25:35.521Z |
5520019 | 5520019 | 20241111142049_ORcR4 | NZ0035 | 2024-11-12T14:05:28.648Z | 2024-11-20T14:25:02.202Z |
5514201 | 5514201 | 20241110150618_Nznfz | NZ0035 | 2024-11-11T14:06:20.092Z | 2024-11-19T14:21:44.792Z |
5514196 | 5514196 | 20241110150601_PIQaP | NZ0035 | 2024-11-11T14:06:19.918Z | 2024-11-19T14:21:44.757Z |
5514172 | 5514172 | 20241110145715_tyDwQ | NZ0035 | 2024-11-11T14:06:18.253Z | 2024-11-19T14:21:44.615Z |
5514109 | 5514109 | 20241110142948_B86h3 | NZ0035 | 2024-11-11T14:06:11.730Z | 2024-11-19T14:21:43.673Z |
5474129 | 5474129 | 20241103160053_HUdUG | NZ0035 | 2024-11-05T14:10:10.137Z | 2024-11-12T14:27:50.594Z |
5473814 | 5473814 | 20241103150749_SHv93 | NZ0035 | 2024-11-05T14:09:46.106Z | 2024-11-12T14:27:50.047Z |
5473660 | 5473660 | 20241103144623_olwgY | NZ0035 | 2024-11-05T14:09:20.397Z | 2024-11-12T14:27:49.867Z |
5473656 | 5473656 | 20241103144606_g5Ad3 | NZ0035 | 2024-11-05T14:09:19.795Z | 2024-11-12T14:27:49.852Z |
5473025 | 5473025 | 20241103131620_MjOqF | NZ0035 | 2024-11-05T14:08:04.048Z | 2024-11-12T14:27:47.582Z |
5472990 | 5472990 | 20241103131158_yKFHg | NZ0035 | 2024-11-05T14:08:00.201Z | 2024-11-12T14:27:47.558Z |
5472870 | 5472870 | 20241103125502_Id45z | NZ0035 | 2024-11-05T14:07:48.862Z | 2024-11-12T14:27:46.829Z |
5472732 | 5472732 | 20241103123104_OnT5N | NZ0035 | 2024-11-05T14:07:38.134Z | 2024-11-12T14:27:46.487Z |
5470278 | 5470278 | 20241031144646_m7nJq | NZ0035 | 2024-11-04T14:23:03.099Z | 2024-11-09T14:24:09.244Z |
5470270 | 5470270 | 20241031121100_7ioa5 | NZ0035 | 2024-11-04T14:22:38.354Z | 2024-11-09T14:24:01.378Z |
5465412 | 5465412 | 20241103115022_4Ls0m | NZ0035 | 2024-11-04T14:03:40.154Z | 2024-11-12T14:27:46.197Z |
5465229 | 5465229 | 20241103110440_WyGAc | NZ0035 | 2024-11-04T14:03:07.107Z | 2024-11-12T14:27:45.392Z |
5449551 | 5449551 | 20241031155242_8Ywfp | NZ0035 | 2024-11-02T12:13:05.515Z | 2024-11-09T14:24:11.148Z |
5449259 | 5449259 | 20241031151251_rVJRf | NZ0035 | 2024-11-02T12:12:20.797Z | 2024-11-09T14:24:10.024Z |
5449220 | 5449220 | 20241031150652_cOc9f | NZ0035 | 2024-11-02T12:12:18.576Z | 2024-11-09T14:24:09.903Z |
5449132 | 5449132 | 20241031145848_TuSTM | NZ0035 | 2024-11-02T12:12:08.728Z | 2024-11-09T14:24:09.543Z |
5449119 | 5449119 | 20241031145638_3NYZG | NZ0035 | 2024-11-02T12:12:07.284Z | 2024-11-09T14:24:09.491Z |
5448716 | 5448716 | 20241031141004_LQvDB | NZ0035 | 2024-11-02T12:11:21.699Z | 2024-11-09T14:24:07.148Z |
5448708 | 5448708 | 20241031140953_nG73L | NZ0035 | 2024-11-02T12:11:20.970Z | 2024-11-09T14:24:07.080Z |
5448602 | 5448602 | 20241031135138_VoqcQ | NZ0035 | 2024-11-02T12:11:10.255Z | 2024-11-09T14:24:06.636Z |
5448452 | 5448452 | 20241031133320_jp9uX | NZ0035 | 2024-11-02T12:10:47.520Z | 2024-11-09T14:24:05.915Z |
5448280 | 5448280 | 20241031130618_2ombI | NZ0035 | 2024-11-02T12:10:28.225Z | 2024-11-09T14:24:04.286Z |
5437901 | 5437901 | 20241030155853_DZynV | NZ0035 | 2024-11-01T12:10:40.805Z | 2024-11-08T14:22:58.359Z |
5437778 | 5437778 | 20241030154202_ULyY3 | NZ0035 | 2024-11-01T12:10:18.731Z | 2024-11-08T14:22:58.132Z |
5437297 | 5437297 | 20241030145049_d22M2 | NZ0035 | 2024-11-01T12:09:21.580Z | 2024-11-08T14:22:56.979Z |
5437109 | 5437109 | 20241030142853_442Xl | NZ0035 | 2024-11-01T12:08:55.651Z | 2024-11-08T14:22:56.663Z |
5436879 | 5436879 | 20241030140104_qJWpJ | NZ0035 | 2024-11-01T12:08:30.886Z | 2024-11-08T14:22:55.719Z |
5436663 | 5436663 | 20241030133322_cLSC2 | NZ0035 | 2024-11-01T12:08:01.943Z | 2024-11-08T14:22:54.570Z |
5436648 | 5436648 | 20241030133058_yE1v3 | NZ0035 | 2024-11-01T12:08:01.063Z | 2024-11-08T14:22:54.566Z |
5436473 | 5436473 | 20241030131052_zOCOT | NZ0035 | 2024-11-01T12:07:44.146Z | 2024-11-08T14:22:54.081Z |
5436440 | 5436440 | 20241030130750_7wlqR | NZ0035 | 2024-11-01T12:07:37.324Z | 2024-11-08T14:22:54.066Z |
5436404 | 5436404 | 20241030130200_9zRTQ | NZ0035 | 2024-11-01T12:07:29.156Z | 2024-11-08T14:22:54.028Z |
5436255 | 5436255 | 20241030124207_u3eLk | NZ0035 | 2024-11-01T12:07:10.888Z | 2024-11-08T14:22:53.623Z |
5435953 | 5435953 | 20241030121314_zcPFi | NZ0035 | 2024-11-01T12:06:26.083Z | 2024-11-08T14:22:52.186Z |
5435812 | 5435812 | 20241030115901_YoPJJ | NZ0035 | 2024-11-01T12:05:57.794Z | 2024-11-08T14:22:51.752Z |
5435776 | 5435776 | 20241030115553_X1R0q | NZ0035 | 2024-11-01T12:05:52.678Z | 2024-11-08T14:22:51.697Z |
5435639 | 5435639 | 20241030114603_XBvrg | NZ0035 | 2024-11-01T12:05:41.892Z | 2024-11-08T14:22:51.328Z |
5435536 | 5435536 | 20241030114017_sirLS | NZ0035 | 2024-11-01T12:05:23.321Z | 2024-11-08T14:22:50.973Z |
5435059 | 5435059 | 20241030104633_C62Od | NZ0035 | 2024-11-01T12:04:05.069Z | 2024-11-08T14:22:49.021Z |
5434992 | 5434992 | 20241030103313_G5MpB | NZ0035 | 2024-11-01T12:03:54.639Z | 2024-11-08T14:22:48.918Z |
5434981 | 5434981 | 20241030103229_IxMP2 | NZ0035 | 2024-11-01T12:03:53.339Z | 2024-11-08T14:22:48.896Z |
5434787 | 5434787 | 20241030101356_KWFj8 | NZ0035 | 2024-11-01T12:03:23.473Z | 2024-11-08T14:22:47.891Z |
5434784 | 5434784 | 20241030101353_LipKZ | NZ0035 | 2024-11-01T12:03:22.646Z | 2024-11-08T14:22:47.888Z |
5426605 | 5426605 | 20241028133311_UJS3y | NZ0035 | 2024-10-31T12:12:16.360Z | 2024-11-06T14:27:10.446Z |
5425232 | 5425232 | 20241029161201_wfEpK | NZ0035 | 2024-10-31T12:07:18.540Z | 2024-11-07T14:26:33.949Z |
5424810 | 5424810 | 20241029151630_I3KNY | NZ0035 | 2024-10-31T12:06:04.573Z | 2024-11-07T14:26:32.910Z |
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);