participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,325 rows where station_code = "NZ000G" 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 |
---|---|---|---|---|---|
5464674 | 5464674 | 20241103084635_FvNwS | NZ000G | 2024-11-04T14:01:18.677Z | 2024-11-04T14:01:18.677Z |
5460940 | 5460940 | 20241101152311_DvKiw | NZ000G | 2024-11-03T14:14:35.339Z | 2024-11-04T14:19:48.682Z |
5460921 | 5460921 | 20241101152022_54f3m | NZ000G | 2024-11-03T14:14:34.357Z | 2024-11-04T14:19:47.972Z |
5460896 | 5460896 | 20241101151808_ZcBNC | NZ000G | 2024-11-03T14:14:33.375Z | 2024-11-04T14:19:47.377Z |
5460723 | 5460723 | 20241101145603_4BjVT | NZ000G | 2024-11-03T14:14:17.299Z | 2024-11-04T14:19:42.722Z |
5460684 | 5460684 | 20241101144854_9wguA | NZ000G | 2024-11-03T14:14:13.758Z | 2024-11-04T14:19:41.868Z |
5460384 | 5460384 | 20241101140145_SPyWH | NZ000G | 2024-11-03T14:13:41.049Z | 2024-11-04T14:19:33.114Z |
5460235 | 5460235 | 20241101132036_B5mW3 | NZ000G | 2024-11-03T14:13:30.485Z | 2024-11-04T14:19:27.565Z |
5458012 | 5458012 | 20241102155751_usACH | NZ000G | 2024-11-03T14:08:32.878Z | 2024-11-04T14:17:59.539Z |
5457902 | 5457902 | 20241102153818_aXX27 | NZ000G | 2024-11-03T14:08:19.861Z | 2024-11-04T14:17:59.442Z |
5457570 | 5457570 | 20241102144751_INIwE | NZ000G | 2024-11-03T14:07:40.661Z | 2024-11-04T14:17:59.040Z |
5457464 | 5457464 | 20241102143351_TrhXp | NZ000G | 2024-11-03T14:07:23.224Z | 2024-11-04T14:17:58.976Z |
5457452 | 5457452 | 20241102143318_Rid4v | NZ000G | 2024-11-03T14:07:21.400Z | 2024-11-04T14:17:58.971Z |
5457313 | 5457313 | 20241102140914_Gwmzb | NZ000G | 2024-11-03T14:07:06.331Z | 2024-11-04T14:17:58.805Z |
5457134 | 5457134 | 20241102133601_5qDdT | NZ000G | 2024-11-03T14:06:37.501Z | 2024-11-04T14:17:58.672Z |
5457033 | 5457033 | 20241102131543_728Wl | NZ000G | 2024-11-03T14:06:24.810Z | 2024-11-04T14:17:58.553Z |
5456978 | 5456978 | 20241102130441_15j4W | NZ000G | 2024-11-03T14:06:17.855Z | 2024-11-04T14:17:58.517Z |
5456829 | 5456829 | 20241102123414_VIqWg | NZ000G | 2024-11-03T14:05:46.196Z | 2024-11-04T14:17:58.357Z |
5456709 | 5456709 | 20241102120726_YGt3T | NZ000G | 2024-11-03T14:05:32.017Z | 2024-11-04T14:17:58.286Z |
5456587 | 5456587 | 20241102114726_dYRbH | NZ000G | 2024-11-03T14:05:03.156Z | 2024-11-04T14:17:58.172Z |
5456568 | 5456568 | 20241102114546_m3mXe | NZ000G | 2024-11-03T14:05:00.676Z | 2024-11-04T14:17:58.164Z |
5456392 | 5456392 | 20241102111214_S7LO3 | NZ000G | 2024-11-03T14:04:23.304Z | 2024-11-04T14:17:58.046Z |
5456375 | 5456375 | 20241102110831_as0pB | NZ000G | 2024-11-03T14:04:19.893Z | 2024-11-04T14:17:58.038Z |
5436422 | 5436422 | 20241030130522_h75Vy | NZ000G | 2024-11-01T12:07:32.478Z | 2024-11-04T14:24:21.424Z |
5435996 | 5435996 | 20241030121731_rgYSk | NZ000G | 2024-11-01T12:06:30.148Z | 2024-11-04T14:24:16.312Z |
5435836 | 5435836 | 20241030120158_AEP09 | NZ000G | 2024-11-01T12:06:02.529Z | 2024-11-04T14:24:14.996Z |
5427315 | 5427315 | 20241028145650_8g3n0 | NZ000G | 2024-10-31T12:13:25.961Z | 2024-11-04T14:26:54.098Z |
5427289 | 5427289 | 20241028145429_yqXI8 | NZ000G | 2024-10-31T12:13:24.286Z | 2024-11-04T14:26:54.024Z |
5427148 | 5427148 | 20241028143719_RuuKp | NZ000G | 2024-10-31T12:13:16.128Z | 2024-11-04T14:26:53.596Z |
5426915 | 5426915 | 20241028141024_m6Zs8 | NZ000G | 2024-10-31T12:12:37.966Z | 2024-11-04T14:26:52.411Z |
5426840 | 5426840 | 20241028140332_rfc0X | NZ000G | 2024-10-31T12:12:32.664Z | 2024-11-04T14:26:51.948Z |
5426814 | 5426814 | 20241028140037_TBd3h | NZ000G | 2024-10-31T12:12:30.031Z | 2024-11-04T14:26:51.889Z |
5426801 | 5426801 | 20241028135906_B8N7r | NZ000G | 2024-10-31T12:12:29.423Z | 2024-11-04T14:26:51.775Z |
5426598 | 5426598 | 20241028133120_89zbM | NZ000G | 2024-10-31T12:12:16.142Z | 2024-11-04T14:26:51.003Z |
5426592 | 5426592 | 20241028133010_bTXT4 | NZ000G | 2024-10-31T12:12:15.491Z | 2024-11-04T14:26:50.989Z |
5425101 | 5425101 | 20241029155523_SyocJ | NZ000G | 2024-10-31T12:06:51.575Z | 2024-11-04T14:26:01.324Z |
5425034 | 5425034 | 20241029154313_1eG1P | NZ000G | 2024-10-31T12:06:42.201Z | 2024-11-04T14:26:01.150Z |
5424956 | 5424956 | 20241029153533_STgQX | NZ000G | 2024-10-31T12:06:34.114Z | 2024-11-04T14:26:00.835Z |
5424884 | 5424884 | 20241029152759_ZN3e2 | NZ000G | 2024-10-31T12:06:18.816Z | 2024-11-04T14:25:59.774Z |
5424549 | 5424549 | 20241029144331_NLxdc | NZ000G | 2024-10-31T12:05:22.317Z | 2024-11-04T14:25:57.757Z |
5416577 | 5416577 | 20241027161025_VI2vI | NZ000G | 2024-10-30T12:11:47.943Z | 2024-11-04T14:27:53.391Z |
5416552 | 5416552 | 20241027160656_cvDgF | NZ000G | 2024-10-30T12:11:45.342Z | 2024-11-04T14:27:53.334Z |
5416536 | 5416536 | 20241027160555_YsydF | NZ000G | 2024-10-30T12:11:43.826Z | 2024-11-04T14:27:53.296Z |
5416389 | 5416389 | 20241027154716_NWebx | NZ000G | 2024-10-30T12:11:32.310Z | 2024-11-04T14:27:52.988Z |
5416372 | 5416372 | 20241027154539_FYXJc | NZ000G | 2024-10-30T12:11:31.055Z | 2024-11-04T14:27:52.923Z |
5415826 | 5415826 | 20241027144129_F62Jh | NZ000G | 2024-10-30T12:10:32.112Z | 2024-11-04T14:27:50.786Z |
5415665 | 5415665 | 20241027142239_t4oNX | NZ000G | 2024-10-30T12:10:17.749Z | 2024-11-04T14:27:50.402Z |
5415352 | 5415352 | 20241027134334_QL70C | NZ000G | 2024-10-30T12:09:36.717Z | 2024-11-04T14:27:49.162Z |
5415261 | 5415261 | 20241027132830_sylGk | NZ000G | 2024-10-30T12:09:28.608Z | 2024-11-04T14:27:48.933Z |
5415239 | 5415239 | 20241027132702_Y1jIc | NZ000G | 2024-10-30T12:09:23.969Z | 2024-11-04T14:27:48.909Z |
5415205 | 5415205 | 20241027131921_309Oz | NZ000G | 2024-10-30T12:09:13.528Z | 2024-11-04T14:27:48.871Z |
5382044 | 5382044 | 20241024155924_As6Kf | NZ000G | 2024-10-27T12:13:09.747Z | 2024-11-02T12:28:23.380Z |
5382002 | 5382002 | 20241024155618_8M2yf | NZ000G | 2024-10-27T12:13:07.199Z | 2024-11-02T12:28:23.360Z |
5381976 | 5381976 | 20241024155411_r0oS1 | NZ000G | 2024-10-27T12:13:05.393Z | 2024-11-02T12:28:23.342Z |
5381832 | 5381832 | 20241024154234_JzwfZ | NZ000G | 2024-10-27T12:12:50.597Z | 2024-11-02T12:28:23.207Z |
5371860 | 5371860 | 20241024152706_XXEoI | NZ000G | 2024-10-26T12:12:49.197Z | 2024-11-02T12:28:23.033Z |
5371836 | 5371836 | 20241024152446_XCLXm | NZ000G | 2024-10-26T12:12:47.750Z | 2024-11-02T12:28:23.013Z |
5371795 | 5371795 | 20241024152209_9taqd | NZ000G | 2024-10-26T12:12:43.726Z | 2024-11-02T12:28:22.828Z |
5371789 | 5371789 | 20241024152151_1pnzg | NZ000G | 2024-10-26T12:12:42.374Z | 2024-11-02T12:28:22.824Z |
5371393 | 5371393 | 20241024145007_SfNW3 | NZ000G | 2024-10-26T12:11:54.939Z | 2024-11-02T12:28:22.158Z |
5371348 | 5371348 | 20241024144427_jzH2t | NZ000G | 2024-10-26T12:11:43.672Z | 2024-11-02T12:28:21.962Z |
5371197 | 5371197 | 20241024143047_3JJE6 | NZ000G | 2024-10-26T12:11:20.921Z | 2024-11-02T12:28:21.861Z |
5371068 | 5371068 | 20241024142211_yCwvy | NZ000G | 2024-10-26T12:11:09.018Z | 2024-11-02T12:28:21.789Z |
5370990 | 5370990 | 20241024141116_3bWR8 | NZ000G | 2024-10-26T12:10:50.023Z | 2024-11-02T12:28:21.646Z |
5370865 | 5370865 | 20241024140145_4zgUU | NZ000G | 2024-10-26T12:10:34.061Z | 2024-11-02T12:28:21.519Z |
5370789 | 5370789 | 20241024135349_QwsXn | NZ000G | 2024-10-26T12:10:28.341Z | 2024-11-02T12:28:21.383Z |
5194218 | 5194218 | 20240929153542_0KWTt | NZ000G | 2024-09-30T12:19:35.304Z | 2024-10-07T12:21:29.401Z |
5194212 | 5194212 | 20240929153515_VuvPO | NZ000G | 2024-09-30T12:19:35.273Z | 2024-10-07T12:21:29.393Z |
5194167 | 5194167 | 20240929152314_PzYbo | NZ000G | 2024-09-30T12:19:34.939Z | 2024-10-07T12:21:29.318Z |
5194152 | 5194152 | 20240929152057_869LY | NZ000G | 2024-09-30T12:19:34.565Z | 2024-10-07T12:21:29.287Z |
5193813 | 5193813 | 20240929134913_cr1Qc | NZ000G | 2024-09-30T12:19:27.017Z | 2024-10-07T12:21:27.402Z |
5193638 | 5193638 | 20240929130104_uciDl | NZ000G | 2024-09-30T12:19:22.414Z | 2024-10-07T12:21:26.836Z |
5193477 | 5193477 | 20240929121337_z2ZVJ | NZ000G | 2024-09-30T12:19:18.991Z | 2024-10-07T12:21:26.063Z |
5193164 | 5193164 | 20240929110015_6yK2u | NZ000G | 2024-09-30T12:19:09.401Z | 2024-10-07T12:21:24.770Z |
5190356 | 5190356 | 20240928165122_VCUVc | NZ000G | 2024-09-30T12:16:46.553Z | 2024-10-06T12:28:19.344Z |
5190305 | 5190305 | 20240928163754_1H6vu | NZ000G | 2024-09-30T12:16:41.863Z | 2024-10-06T12:28:19.263Z |
5190199 | 5190199 | 20240928161514_Q2BlD | NZ000G | 2024-09-30T12:16:36.477Z | 2024-10-06T12:28:19.092Z |
5190091 | 5190091 | 20240928160343_T8Hvp | NZ000G | 2024-09-30T12:16:29.422Z | 2024-10-06T12:28:18.936Z |
5189773 | 5189773 | 20240928144840_PPm4n | NZ000G | 2024-09-30T12:16:06.723Z | 2024-10-06T12:28:18.291Z |
5189239 | 5189239 | 20240928124754_bJf9d | NZ000G | 2024-09-30T12:15:21.605Z | 2024-10-06T12:28:17.192Z |
5189192 | 5189192 | 20240928123525_FeMUo | NZ000G | 2024-09-30T12:15:17.593Z | 2024-10-06T12:28:17.101Z |
5188522 | 5188522 | 20240928105455_2KuOb | NZ000G | 2024-09-30T12:14:12.393Z | 2024-10-06T12:28:15.365Z |
5188352 | 5188352 | 20240928103517_yPuX8 | NZ000G | 2024-09-30T12:13:59.330Z | 2024-10-06T12:28:14.921Z |
5188019 | 5188019 | 20240928094319_H4ViF | NZ000G | 2024-09-30T12:13:31.709Z | 2024-10-06T12:28:14.041Z |
5187236 | 5187236 | 20240929084640_lb5Pq | NZ000G | 2024-09-30T12:09:03.331Z | 2024-10-07T12:21:23.505Z |
5187129 | 5187129 | 20240929080703_2Uhjb | NZ000G | 2024-09-30T12:08:43.003Z | 2024-10-07T12:21:23.200Z |
5183822 | 5183822 | 20240928083738_2sPoA | NZ000G | 2024-09-29T12:17:22.372Z | 2024-10-06T12:28:12.499Z |
5180099 | 5180099 | 20240927131306_ps0r6 | NZ000G | 2024-09-29T12:11:55.294Z | 2024-10-05T12:28:53.230Z |
5175528 | 5175528 | 20240924162906_Vkj7K | NZ000G | 2024-09-28T12:20:24.164Z | 2024-10-02T12:19:01.090Z |
5173594 | 5173594 | 20240927151341_BH57o | NZ000G | 2024-09-28T12:12:39.325Z | 2024-10-05T12:28:55.766Z |
5173085 | 5173085 | 20240927141529_irAGK | NZ000G | 2024-09-28T12:11:56.964Z | 2024-10-05T12:28:54.761Z |
5172993 | 5172993 | 20240927140528_MiI7B | NZ000G | 2024-09-28T12:11:41.187Z | 2024-10-05T12:28:54.522Z |
5172977 | 5172977 | 20240927140413_MXuaB | NZ000G | 2024-09-28T12:11:38.179Z | 2024-10-05T12:28:54.461Z |
5172640 | 5172640 | 20240927131058_icoGs | NZ000G | 2024-09-28T12:11:13.005Z | 2024-10-05T12:28:53.132Z |
5172624 | 5172624 | 20240927130647_72aVV | NZ000G | 2024-09-28T12:11:12.147Z | 2024-10-05T12:28:53.099Z |
5172579 | 5172579 | 20240927130028_7Hz7e | NZ000G | 2024-09-28T12:11:09.331Z | 2024-10-05T12:28:52.783Z |
5172246 | 5172246 | 20240927120236_30lQm | NZ000G | 2024-09-28T12:10:26.819Z | 2024-10-05T12:28:50.928Z |
5172221 | 5172221 | 20240927115731_suEor | NZ000G | 2024-09-28T12:10:18.048Z | 2024-10-05T12:28:50.841Z |
5171800 | 5171800 | 20240927110908_dAtIS | NZ000G | 2024-09-28T12:09:32.968Z | 2024-10-05T12:28:48.289Z |
5171418 | 5171418 | 20240927100249_99BDf | NZ000G | 2024-09-28T12:08:30.525Z | 2024-10-05T12:28:45.797Z |
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);