participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,830 rows where station_code = "NZ004E" 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 |
---|---|---|---|---|---|
5460017 | 5460017 | 20241101123023_1PsXT | NZ004E | 2024-11-03T14:13:07.945Z | 2024-11-03T14:19:33.463Z |
5459741 | 5459741 | 20241101114648_6O7A3 | NZ004E | 2024-11-03T14:12:32.381Z | 2024-11-03T14:19:33.410Z |
5457571 | 5457571 | 20241102144751_INIwE | NZ004E | 2024-11-03T14:07:40.661Z | 2024-11-03T14:07:40.661Z |
5457453 | 5457453 | 20241102143318_Rid4v | NZ004E | 2024-11-03T14:07:21.400Z | 2024-11-03T14:07:21.400Z |
5457314 | 5457314 | 20241102140914_Gwmzb | NZ004E | 2024-11-03T14:07:06.331Z | 2024-11-03T14:07:06.331Z |
5457290 | 5457290 | 20241102140355_1Txgd | NZ004E | 2024-11-03T14:07:03.376Z | 2024-11-03T14:07:03.376Z |
5457196 | 5457196 | 20241102134554_TyAwV | NZ004E | 2024-11-03T14:06:44.508Z | 2024-11-03T14:06:44.508Z |
5457090 | 5457090 | 20241102132942_T3inI | NZ004E | 2024-11-03T14:06:32.529Z | 2024-11-03T14:06:32.529Z |
5457027 | 5457027 | 20241102131504_YV0W4 | NZ004E | 2024-11-03T14:06:23.451Z | 2024-11-03T14:06:23.451Z |
5457000 | 5457000 | 20241102131239_2i1ty | NZ004E | 2024-11-03T14:06:20.387Z | 2024-11-03T14:06:20.387Z |
5456979 | 5456979 | 20241102130441_15j4W | NZ004E | 2024-11-03T14:06:17.855Z | 2024-11-03T14:06:17.855Z |
5456831 | 5456831 | 20241102123414_VIqWg | NZ004E | 2024-11-03T14:05:46.196Z | 2024-11-03T14:05:46.196Z |
5456710 | 5456710 | 20241102120726_YGt3T | NZ004E | 2024-11-03T14:05:32.017Z | 2024-11-03T14:05:32.017Z |
5456649 | 5456649 | 20241102115751_REK0D | NZ004E | 2024-11-03T14:05:13.305Z | 2024-11-03T14:05:13.305Z |
5456588 | 5456588 | 20241102114726_dYRbH | NZ004E | 2024-11-03T14:05:03.156Z | 2024-11-03T14:05:03.156Z |
5456394 | 5456394 | 20241102111214_S7LO3 | NZ004E | 2024-11-03T14:04:23.304Z | 2024-11-03T14:04:23.304Z |
5449263 | 5449263 | 20241031151257_Jt3sa | NZ004E | 2024-11-02T12:12:21.462Z | 2024-11-03T14:20:50.063Z |
5449039 | 5449039 | 20241031144633_1y8OF | NZ004E | 2024-11-02T12:12:00.076Z | 2024-11-03T14:20:47.644Z |
5449036 | 5449036 | 20241031144553_lDTWk | NZ004E | 2024-11-02T12:11:59.720Z | 2024-11-03T14:20:47.637Z |
5448977 | 5448977 | 20241031143701_kyNcj | NZ004E | 2024-11-02T12:11:55.092Z | 2024-11-03T14:20:45.981Z |
5437936 | 5437936 | 20241030160400_pGTaU | NZ004E | 2024-11-01T12:10:44.461Z | 2024-11-03T14:22:40.999Z |
5437655 | 5437655 | 20241030153222_PTpzY | NZ004E | 2024-11-01T12:10:09.360Z | 2024-11-03T14:22:40.224Z |
5437612 | 5437612 | 20241030152745_PrYS5 | NZ004E | 2024-11-01T12:10:05.298Z | 2024-11-03T14:22:40.116Z |
5437194 | 5437194 | 20241030143958_n2g2p | NZ004E | 2024-11-01T12:09:13.311Z | 2024-11-03T14:22:38.857Z |
5437177 | 5437177 | 20241030143636_AKvTU | NZ004E | 2024-11-01T12:09:12.012Z | 2024-11-03T14:22:38.813Z |
5436650 | 5436650 | 20241030133058_yE1v3 | NZ004E | 2024-11-01T12:08:01.063Z | 2024-11-03T14:22:37.394Z |
5436608 | 5436608 | 20241030132752_T7qHd | NZ004E | 2024-11-01T12:07:57.412Z | 2024-11-03T14:22:37.246Z |
5436256 | 5436256 | 20241030124207_u3eLk | NZ004E | 2024-11-01T12:07:10.888Z | 2024-11-03T14:22:36.019Z |
5436238 | 5436238 | 20241030124129_VDROF | NZ004E | 2024-11-01T12:07:09.651Z | 2024-11-03T14:22:35.973Z |
5435673 | 5435673 | 20241030114908_BWKAm | NZ004E | 2024-11-01T12:05:44.954Z | 2024-11-03T14:22:33.492Z |
5435335 | 5435335 | 20241030111851_Becwl | NZ004E | 2024-11-01T12:04:56.043Z | 2024-11-03T14:22:32.110Z |
5435031 | 5435031 | 20241030104035_I8T2t | NZ004E | 2024-11-01T12:04:00.991Z | 2024-11-03T14:22:28.696Z |
5427816 | 5427816 | 20241028154853_Exu1T | NZ004E | 2024-10-31T12:14:02.465Z | 2024-11-03T14:24:48.920Z |
5427601 | 5427601 | 20241028152133_9krbc | NZ004E | 2024-10-31T12:13:40.501Z | 2024-11-03T14:24:48.090Z |
5427318 | 5427318 | 20241028145650_8g3n0 | NZ004E | 2024-10-31T12:13:25.961Z | 2024-11-03T14:24:46.574Z |
5427235 | 5427235 | 20241028144817_AItiK | NZ004E | 2024-10-31T12:13:21.622Z | 2024-11-03T14:24:46.388Z |
5427181 | 5427181 | 20241028144104_hXbeO | NZ004E | 2024-10-31T12:13:18.632Z | 2024-11-03T14:24:46.324Z |
5426933 | 5426933 | 20241028141121_oifVD | NZ004E | 2024-10-31T12:12:40.214Z | 2024-11-03T14:24:45.458Z |
5426918 | 5426918 | 20241028141029_WvNQv | NZ004E | 2024-10-31T12:12:38.161Z | 2024-11-03T14:24:45.447Z |
5426916 | 5426916 | 20241028141024_m6Zs8 | NZ004E | 2024-10-31T12:12:37.967Z | 2024-11-03T14:24:45.446Z |
5426869 | 5426869 | 20241028140440_lXzw8 | NZ004E | 2024-10-31T12:12:34.848Z | 2024-11-03T14:24:45.349Z |
5426841 | 5426841 | 20241028140332_rfc0X | NZ004E | 2024-10-31T12:12:32.664Z | 2024-11-03T14:24:45.268Z |
5426816 | 5426816 | 20241028140037_TBd3h | NZ004E | 2024-10-31T12:12:30.031Z | 2024-11-03T14:24:45.062Z |
5426802 | 5426802 | 20241028135906_B8N7r | NZ004E | 2024-10-31T12:12:29.423Z | 2024-11-03T14:24:45.048Z |
5426734 | 5426734 | 20241028135041_DMNs2 | NZ004E | 2024-10-31T12:12:25.095Z | 2024-11-03T14:24:44.936Z |
5425103 | 5425103 | 20241029155523_SyocJ | NZ004E | 2024-10-31T12:06:51.575Z | 2024-11-03T14:23:40.853Z |
5425087 | 5425087 | 20241029155049_Fjme1 | NZ004E | 2024-10-31T12:06:48.475Z | 2024-11-03T14:23:40.807Z |
5425035 | 5425035 | 20241029154313_1eG1P | NZ004E | 2024-10-31T12:06:42.201Z | 2024-11-03T14:23:40.380Z |
5425017 | 5425017 | 20241029154049_bMVdK | NZ004E | 2024-10-31T12:06:40.678Z | 2024-11-03T14:23:40.256Z |
5424957 | 5424957 | 20241029153533_STgQX | NZ004E | 2024-10-31T12:06:34.114Z | 2024-11-03T14:23:39.991Z |
5424885 | 5424885 | 20241029152759_ZN3e2 | NZ004E | 2024-10-31T12:06:18.816Z | 2024-11-03T14:23:39.632Z |
5422507 | 5422507 | 20241028130917_lztZ3 | NZ004E | 2024-10-30T12:20:27.333Z | 2024-11-03T14:24:42.532Z |
5422453 | 5422453 | 20241028130445_LHxcJ | NZ004E | 2024-10-30T12:20:26.911Z | 2024-11-03T14:24:42.369Z |
5421857 | 5421857 | 20241028115013_3N52c | NZ004E | 2024-10-30T12:20:16.421Z | 2024-11-03T14:24:39.542Z |
5421722 | 5421722 | 20241028112622_uD5HK | NZ004E | 2024-10-30T12:20:13.486Z | 2024-11-03T14:24:39.080Z |
5421667 | 5421667 | 20241028111831_SCRzu | NZ004E | 2024-10-30T12:20:11.636Z | 2024-11-03T14:24:38.989Z |
5421640 | 5421640 | 20241028111650_a0Jp2 | NZ004E | 2024-10-30T12:20:10.548Z | 2024-11-03T14:24:38.815Z |
5416538 | 5416538 | 20241027160555_YsydF | NZ004E | 2024-10-30T12:11:43.829Z | 2024-11-03T14:25:42.392Z |
5416373 | 5416373 | 20241027154539_FYXJc | NZ004E | 2024-10-30T12:11:31.056Z | 2024-11-03T14:25:42.142Z |
5415728 | 5415728 | 20241027143032_jqKbL | NZ004E | 2024-10-30T12:10:24.866Z | 2024-11-03T14:25:40.556Z |
5415262 | 5415262 | 20241027132830_sylGk | NZ004E | 2024-10-30T12:09:28.608Z | 2024-11-03T14:25:39.383Z |
5415207 | 5415207 | 20241027131921_309Oz | NZ004E | 2024-10-30T12:09:13.549Z | 2024-11-03T14:25:39.327Z |
5413441 | 5413441 | 20241028100029_XWNMc | NZ004E | 2024-10-30T12:03:03.192Z | 2024-11-03T14:24:35.430Z |
5413431 | 5413431 | 20241028095949_RC2Ui | NZ004E | 2024-10-30T12:03:00.882Z | 2024-11-03T14:24:35.418Z |
5413354 | 5413354 | 20241028094223_eQ6x3 | NZ004E | 2024-10-30T12:02:48.127Z | 2024-11-03T14:24:34.432Z |
5392288 | 5392288 | 20241026154735_9aEo9 | NZ004E | 2024-10-28T12:07:40.300Z | 2024-11-03T14:26:17.981Z |
5392182 | 5392182 | 20241026152640_F5cFj | NZ004E | 2024-10-28T12:07:18.457Z | 2024-11-03T14:26:16.821Z |
5391996 | 5391996 | 20241026143225_8VTu3 | NZ004E | 2024-10-28T12:07:00.767Z | 2024-11-03T14:26:16.324Z |
5391873 | 5391873 | 20241026135537_IyAB6 | NZ004E | 2024-10-28T12:06:40.902Z | 2024-11-03T14:26:16.021Z |
5391461 | 5391461 | 20241026115903_C4lvE | NZ004E | 2024-10-28T12:05:38.103Z | 2024-11-03T14:26:14.385Z |
5391186 | 5391186 | 20241026112119_L11qx | NZ004E | 2024-10-28T12:04:51.488Z | 2024-11-03T14:26:13.915Z |
5390041 | 5390041 | 20241026084147_jijWS | NZ004E | 2024-10-28T12:01:58.196Z | 2024-11-03T14:26:10.291Z |
5390020 | 5390020 | 20241026083719_QsDMm | NZ004E | 2024-10-28T12:01:50.751Z | 2024-11-03T14:26:10.256Z |
5382125 | 5382125 | 20241024160458_VUcDD | NZ004E | 2024-10-27T12:13:14.091Z | 2024-11-02T12:28:23.470Z |
5382045 | 5382045 | 20241024155924_As6Kf | NZ004E | 2024-10-27T12:13:09.747Z | 2024-11-02T12:28:23.380Z |
5382003 | 5382003 | 20241024155618_8M2yf | NZ004E | 2024-10-27T12:13:07.200Z | 2024-11-02T12:28:23.360Z |
5381982 | 5381982 | 20241024155425_O52BB | NZ004E | 2024-10-27T12:13:05.751Z | 2024-11-02T12:28:23.343Z |
5381979 | 5381979 | 20241024155411_r0oS1 | NZ004E | 2024-10-27T12:13:05.393Z | 2024-11-02T12:28:23.342Z |
5381835 | 5381835 | 20241024154234_JzwfZ | NZ004E | 2024-10-27T12:12:50.669Z | 2024-11-02T12:28:23.207Z |
5381703 | 5381703 | 20241024153142_E1B1R | NZ004E | 2024-10-27T12:12:28.001Z | 2024-11-02T12:28:23.066Z |
5371864 | 5371864 | 20241024152706_XXEoI | NZ004E | 2024-10-26T12:12:49.197Z | 2024-11-02T12:28:23.033Z |
5371859 | 5371859 | 20241024152654_wwtsn | NZ004E | 2024-10-26T12:12:49.128Z | 2024-11-02T12:28:23.032Z |
5371839 | 5371839 | 20241024152446_XCLXm | NZ004E | 2024-10-26T12:12:47.750Z | 2024-11-02T12:28:23.014Z |
5371797 | 5371797 | 20241024152209_9taqd | NZ004E | 2024-10-26T12:12:43.726Z | 2024-11-02T12:28:22.828Z |
5371794 | 5371794 | 20241024152208_H6N3K | NZ004E | 2024-10-26T12:12:43.370Z | 2024-11-02T12:28:22.827Z |
5371791 | 5371791 | 20241024152151_1pnzg | NZ004E | 2024-10-26T12:12:42.374Z | 2024-11-02T12:28:22.824Z |
5371491 | 5371491 | 20241024145629_aL1ms | NZ004E | 2024-10-26T12:12:03.542Z | 2024-11-02T12:28:22.309Z |
5371422 | 5371422 | 20241024145245_EdNfB | NZ004E | 2024-10-26T12:11:57.139Z | 2024-11-02T12:28:22.216Z |
5371394 | 5371394 | 20241024145007_SfNW3 | NZ004E | 2024-10-26T12:11:54.939Z | 2024-11-02T12:28:22.158Z |
5371372 | 5371372 | 20241024144621_MNzeR | NZ004E | 2024-10-26T12:11:48.617Z | 2024-11-02T12:28:22.102Z |
5371349 | 5371349 | 20241024144427_jzH2t | NZ004E | 2024-10-26T12:11:43.672Z | 2024-11-02T12:28:21.962Z |
5371070 | 5371070 | 20241024142211_yCwvy | NZ004E | 2024-10-26T12:11:09.018Z | 2024-11-02T12:28:21.789Z |
5370993 | 5370993 | 20241024141116_3bWR8 | NZ004E | 2024-10-26T12:10:50.023Z | 2024-11-02T12:28:21.646Z |
5370954 | 5370954 | 20241024140847_5T1bv | NZ004E | 2024-10-26T12:10:47.468Z | 2024-11-02T12:28:21.629Z |
5370791 | 5370791 | 20241024135349_QwsXn | NZ004E | 2024-10-26T12:10:28.357Z | 2024-11-02T12:28:21.383Z |
5370654 | 5370654 | 20241024133444_qPlbj | NZ004E | 2024-10-26T12:10:07.224Z | 2024-11-02T12:28:21.007Z |
5370602 | 5370602 | 20241024132928_XSpoA | NZ004E | 2024-10-26T12:09:59.634Z | 2024-11-02T12:28:20.952Z |
5369491 | 5369491 | 20241024113409_RizNG | NZ004E | 2024-10-26T12:07:02.604Z | 2024-11-02T12:28:18.634Z |
5369392 | 5369392 | 20241024112428_1V9gB | NZ004E | 2024-10-26T12:06:51.096Z | 2024-11-02T12:28:18.470Z |
5330013 | 5330013 | 20241021111543_WJrIa | NZ004E | 2024-10-22T12:05:48.029Z | 2024-10-30T12:26:35.982Z |
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);