participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,436 rows where station_code = "NZ0015" 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 |
---|---|---|---|---|---|
5460866 | 5460866 | 20241101151353_N5Wqr | NZ0015 | 2024-11-03T14:14:32.054Z | 2024-11-03T14:19:33.627Z |
5460693 | 5460693 | 20241101145249_cw2b2 | NZ0015 | 2024-11-03T14:14:14.755Z | 2024-11-03T14:19:33.598Z |
5460626 | 5460626 | 20241101143950_lvSOX | NZ0015 | 2024-11-03T14:14:05.303Z | 2024-11-03T14:19:33.586Z |
5460508 | 5460508 | 20241101142407_ngqfX | NZ0015 | 2024-11-03T14:13:53.567Z | 2024-11-03T14:19:33.563Z |
5460456 | 5460456 | 20241101141301_GUO3D | NZ0015 | 2024-11-03T14:13:46.075Z | 2024-11-03T14:19:33.551Z |
5460325 | 5460325 | 20241101134828_DYXWV | NZ0015 | 2024-11-03T14:13:36.131Z | 2024-11-03T14:19:33.524Z |
5460245 | 5460245 | 20241101132125_qXYBq | NZ0015 | 2024-11-03T14:13:30.925Z | 2024-11-03T14:19:33.507Z |
5460236 | 5460236 | 20241101132036_B5mW3 | NZ0015 | 2024-11-03T14:13:30.485Z | 2024-11-03T14:19:33.505Z |
5460210 | 5460210 | 20241101131052_8rnJ9 | NZ0015 | 2024-11-03T14:13:28.149Z | 2024-11-03T14:19:33.499Z |
5460151 | 5460151 | 20241101125837_l3XNi | NZ0015 | 2024-11-03T14:13:24.949Z | 2024-11-03T14:19:33.488Z |
5460053 | 5460053 | 20241101123625_MUmj2 | NZ0015 | 2024-11-03T14:13:15.379Z | 2024-11-03T14:19:33.468Z |
5460048 | 5460048 | 20241101123555_LTuSz | NZ0015 | 2024-11-03T14:13:14.810Z | 2024-11-03T14:19:33.468Z |
5459983 | 5459983 | 20241101122743_NFtKg | NZ0015 | 2024-11-03T14:13:03.068Z | 2024-11-03T14:19:33.458Z |
5458916 | 5458916 | 20241101094123_Q6QNQ | NZ0015 | 2024-11-03T14:10:48.985Z | 2024-11-03T14:19:33.228Z |
5457367 | 5457367 | 20241102142005_i1Taw | NZ0015 | 2024-11-03T14:07:11.013Z | 2024-11-03T14:07:11.013Z |
5457256 | 5457256 | 20241102135848_W4cnV | NZ0015 | 2024-11-03T14:06:59.823Z | 2024-11-03T14:06:59.823Z |
5456822 | 5456822 | 20241102123345_P4Olu | NZ0015 | 2024-11-03T14:05:45.347Z | 2024-11-03T14:05:45.347Z |
5449487 | 5449487 | 20241031154316_d3b2v | NZ0015 | 2024-11-02T12:13:00.461Z | 2024-11-03T14:20:53.651Z |
5449294 | 5449294 | 20241031151738_Kp2mG | NZ0015 | 2024-11-02T12:12:27.283Z | 2024-11-03T14:20:50.923Z |
5448525 | 5448525 | 20241031134337_cIA5i | NZ0015 | 2024-11-02T12:11:00.769Z | 2024-11-03T14:20:39.127Z |
5448450 | 5448450 | 20241031133320_jp9uX | NZ0015 | 2024-11-02T12:10:47.520Z | 2024-11-03T14:20:37.922Z |
5448386 | 5448386 | 20241031132342_DQ5TO | NZ0015 | 2024-11-02T12:10:40.421Z | 2024-11-03T14:20:36.647Z |
5448272 | 5448272 | 20241031130530_DZoKo | NZ0015 | 2024-11-02T12:10:27.439Z | 2024-11-03T14:20:34.987Z |
5448188 | 5448188 | 20241031125808_SPUu3 | NZ0015 | 2024-11-02T12:10:12.584Z | 2024-11-03T14:20:34.035Z |
5447795 | 5447795 | 20241031121129_CJ02X | NZ0015 | 2024-11-02T12:09:06.844Z | 2024-11-03T14:20:28.255Z |
5437941 | 5437941 | 20241030160434_EFj9t | NZ0015 | 2024-11-01T12:10:44.821Z | 2024-11-03T14:22:41.018Z |
5437701 | 5437701 | 20241030153717_QRTrv | NZ0015 | 2024-11-01T12:10:13.094Z | 2024-11-03T14:22:40.331Z |
5437488 | 5437488 | 20241030151321_khwUs | NZ0015 | 2024-11-01T12:09:52.613Z | 2024-11-03T14:22:39.727Z |
5437466 | 5437466 | 20241030151021_20RQe | NZ0015 | 2024-11-01T12:09:42.474Z | 2024-11-03T14:22:39.663Z |
5437205 | 5437205 | 20241030144231_yst8D | NZ0015 | 2024-11-01T12:09:14.396Z | 2024-11-03T14:22:38.879Z |
5436369 | 5436369 | 20241030125818_eFAc0 | NZ0015 | 2024-11-01T12:07:24.271Z | 2024-11-03T14:22:36.383Z |
5427957 | 5427957 | 20241028160556_MuvUg | NZ0015 | 2024-10-31T12:14:18.397Z | 2024-11-03T14:24:49.381Z |
5427728 | 5427728 | 20241028153807_rpsfv | NZ0015 | 2024-10-31T12:13:53.143Z | 2024-11-03T14:24:48.488Z |
5427444 | 5427444 | 20241028150745_EBhWA | NZ0015 | 2024-10-31T12:13:32.533Z | 2024-11-03T14:24:47.713Z |
5427300 | 5427300 | 20241028145535_CvRNc | NZ0015 | 2024-10-31T12:13:25.100Z | 2024-11-03T14:24:46.549Z |
5427119 | 5427119 | 20241028143203_JRYu6 | NZ0015 | 2024-10-31T12:13:10.448Z | 2024-11-03T14:24:45.830Z |
5427046 | 5427046 | 20241028142543_wNBXi | NZ0015 | 2024-10-31T12:13:01.093Z | 2024-11-03T14:24:45.716Z |
5427007 | 5427007 | 20241028142035_E4vyp | NZ0015 | 2024-10-31T12:12:50.948Z | 2024-11-03T14:24:45.644Z |
5424350 | 5424350 | 20241029140616_BGsNC | NZ0015 | 2024-10-31T12:04:40.018Z | 2024-11-03T14:23:36.130Z |
5424223 | 5424223 | 20241029134105_mEljU | NZ0015 | 2024-10-31T12:04:19.340Z | 2024-11-03T14:23:35.536Z |
5424220 | 5424220 | 20241029134033_2ugcF | NZ0015 | 2024-10-31T12:04:18.991Z | 2024-11-03T14:23:35.533Z |
5424174 | 5424174 | 20241029133023_UmlAO | NZ0015 | 2024-10-31T12:04:03.758Z | 2024-11-03T14:23:34.946Z |
5423253 | 5423253 | 20241029085326_BVZjR | NZ0015 | 2024-10-31T12:00:47.760Z | 2024-11-03T14:23:25.794Z |
5422450 | 5422450 | 20241028130445_LHxcJ | NZ0015 | 2024-10-30T12:20:26.911Z | 2024-11-03T14:24:42.368Z |
5422399 | 5422399 | 20241028125940_1PoFK | NZ0015 | 2024-10-30T12:20:26.367Z | 2024-11-03T14:24:42.049Z |
5422297 | 5422297 | 20241028124526_O5WzY | NZ0015 | 2024-10-30T12:20:25.222Z | 2024-11-03T14:24:41.820Z |
5422122 | 5422122 | 20241028121811_h3sb0 | NZ0015 | 2024-10-30T12:20:22.567Z | 2024-11-03T14:24:41.097Z |
5382171 | 5382171 | 20241024160745_ZxO7n | NZ0015 | 2024-10-27T12:13:16.101Z | 2024-11-02T12:28:23.490Z |
5381932 | 5381932 | 20241024154944_XObIS | NZ0015 | 2024-10-27T12:13:02.598Z | 2024-11-02T12:28:23.279Z |
5381675 | 5381675 | 20241024153023_G2cqg | NZ0015 | 2024-10-27T12:12:25.796Z | 2024-11-02T12:28:23.053Z |
5371863 | 5371863 | 20241024152706_XXEoI | NZ0015 | 2024-10-26T12:12:49.197Z | 2024-11-02T12:28:23.033Z |
5371830 | 5371830 | 20241024152434_heiLN | NZ0015 | 2024-10-26T12:12:47.598Z | 2024-11-02T12:28:22.952Z |
5371761 | 5371761 | 20241024151854_Rx532 | NZ0015 | 2024-10-26T12:12:34.986Z | 2024-11-02T12:28:22.765Z |
5371726 | 5371726 | 20241024151534_2U3lR | NZ0015 | 2024-10-26T12:12:29.123Z | 2024-11-02T12:28:22.722Z |
5371615 | 5371615 | 20241024150746_3zQlV | NZ0015 | 2024-10-26T12:12:15.273Z | 2024-11-02T12:28:22.431Z |
5371580 | 5371580 | 20241024150502_vw6Ju | NZ0015 | 2024-10-26T12:12:12.599Z | 2024-11-02T12:28:22.405Z |
5371446 | 5371446 | 20241024145410_4C7jy | NZ0015 | 2024-10-26T12:12:00.284Z | 2024-11-02T12:28:22.248Z |
5371200 | 5371200 | 20241024143047_3JJE6 | NZ0015 | 2024-10-26T12:11:20.921Z | 2024-11-02T12:28:21.861Z |
5371159 | 5371159 | 20241024142753_kWvk8 | NZ0015 | 2024-10-26T12:11:17.139Z | 2024-11-02T12:28:21.838Z |
5370256 | 5370256 | 20241024124442_53XXT | NZ0015 | 2024-10-26T12:09:08.425Z | 2024-11-02T12:28:20.422Z |
5321995 | 5321995 | 20241019081353_P032p | NZ0015 | 2024-10-20T12:00:38.911Z | 2024-10-28T12:26:39.504Z |
5319566 | 5319566 | 20241018163340_0AdW5 | NZ0015 | 2024-10-19T12:02:37.032Z | 2024-10-27T12:28:48.814Z |
5319497 | 5319497 | 20241018145011_W36jm | NZ0015 | 2024-10-19T12:02:25.522Z | 2024-10-27T12:28:48.346Z |
5319483 | 5319483 | 20241018144139_nNVSI | NZ0015 | 2024-10-19T12:02:23.280Z | 2024-10-27T12:28:48.322Z |
5318000 | 5318000 | 20241016160348_tNFeb | NZ0015 | 2024-10-18T12:02:25.505Z | 2024-10-25T12:24:32.455Z |
5316078 | 5316078 | 20241015162256_DriJl | NZ0015 | 2024-10-17T12:05:44.849Z | 2024-10-24T12:27:55.301Z |
5316054 | 5316054 | 20241015162013_WuJf0 | NZ0015 | 2024-10-17T12:05:43.276Z | 2024-10-24T12:27:55.242Z |
5315916 | 5315916 | 20241015155334_TBqh1 | NZ0015 | 2024-10-17T12:05:33.268Z | 2024-10-24T12:27:54.896Z |
5315829 | 5315829 | 20241015153014_Z5ygr | NZ0015 | 2024-10-17T12:05:28.654Z | 2024-10-24T12:27:54.705Z |
5315779 | 5315779 | 20241015150924_2w3br | NZ0015 | 2024-10-17T12:05:25.077Z | 2024-10-24T12:27:54.513Z |
5315749 | 5315749 | 20241015145914_PbDqz | NZ0015 | 2024-10-17T12:05:23.228Z | 2024-10-24T12:27:54.304Z |
5315682 | 5315682 | 20241015144324_L9PVc | NZ0015 | 2024-10-17T12:05:19.705Z | 2024-10-24T12:27:54.025Z |
5315645 | 5315645 | 20241015143204_BnmTR | NZ0015 | 2024-10-17T12:05:14.062Z | 2024-10-24T12:27:53.807Z |
5315599 | 5315599 | 20241015142010_XBDCi | NZ0015 | 2024-10-17T12:05:06.387Z | 2024-10-24T12:27:53.638Z |
5315569 | 5315569 | 20241015140946_pey22 | NZ0015 | 2024-10-17T12:05:02.843Z | 2024-10-24T12:27:53.416Z |
5314813 | 5314813 | 20241016160348_evRpT | NZ0015 | 2024-10-17T12:02:55.532Z | 2024-10-25T12:24:32.450Z |
5314787 | 5314787 | 20241016155105_2Oaye | NZ0015 | 2024-10-17T12:02:49.723Z | 2024-10-25T12:24:32.343Z |
5314733 | 5314733 | 20241016152236_ZmhHn | NZ0015 | 2024-10-17T12:02:44.552Z | 2024-10-25T12:24:31.730Z |
5314680 | 5314680 | 20241016150144_Xbih5 | NZ0015 | 2024-10-17T12:02:40.427Z | 2024-10-25T12:24:31.655Z |
5314675 | 5314675 | 20241016150142_wSeBi | NZ0015 | 2024-10-17T12:02:40.080Z | 2024-10-25T12:24:31.617Z |
5314635 | 5314635 | 20241016144237_HKnjc | NZ0015 | 2024-10-17T12:02:37.316Z | 2024-10-25T12:24:31.466Z |
5314510 | 5314510 | 20241016133550_KAXon | NZ0015 | 2024-10-17T12:02:29.957Z | 2024-10-25T12:24:31.046Z |
5314437 | 5314437 | 20241016125845_r3x7e | NZ0015 | 2024-10-17T12:02:23.841Z | 2024-10-25T12:24:30.401Z |
5310151 | 5310151 | 20241014155318_QgV8t | NZ0015 | 2024-10-16T12:06:30.324Z | 2024-10-23T12:24:31.128Z |
5310093 | 5310093 | 20241014154304_yPq2W | NZ0015 | 2024-10-16T12:06:26.585Z | 2024-10-23T12:24:30.593Z |
5310036 | 5310036 | 20241014152941_KW5M0 | NZ0015 | 2024-10-16T12:06:23.965Z | 2024-10-23T12:24:30.407Z |
5309747 | 5309747 | 20241014140820_wa90D | NZ0015 | 2024-10-16T12:05:50.642Z | 2024-10-23T12:24:27.520Z |
5305745 | 5305745 | 20241013164233_WtA22 | NZ0015 | 2024-10-15T12:05:14.978Z | 2024-10-22T12:24:27.912Z |
5305680 | 5305680 | 20241013163153_PviFg | NZ0015 | 2024-10-15T12:05:04.769Z | 2024-10-22T12:24:27.649Z |
5305672 | 5305672 | 20241013162951_31TFt | NZ0015 | 2024-10-15T12:05:03.783Z | 2024-10-22T12:24:27.646Z |
5305653 | 5305653 | 20241013162500_xr2bw | NZ0015 | 2024-10-15T12:05:00.107Z | 2024-10-22T12:24:27.541Z |
5305644 | 5305644 | 20241013162441_lBLf2 | NZ0015 | 2024-10-15T12:04:59.430Z | 2024-10-22T12:24:27.514Z |
5305530 | 5305530 | 20241013154922_f2qIH | NZ0015 | 2024-10-15T12:04:45.641Z | 2024-10-22T12:24:26.681Z |
5305462 | 5305462 | 20241013152105_wFLwU | NZ0015 | 2024-10-15T12:04:39.243Z | 2024-10-22T12:24:26.244Z |
5305405 | 5305405 | 20241013150821_w88Il | NZ0015 | 2024-10-15T12:04:33.617Z | 2024-10-22T12:24:25.878Z |
5305402 | 5305402 | 20241013150813_Dnycp | NZ0015 | 2024-10-15T12:04:33.062Z | 2024-10-22T12:24:25.877Z |
5305262 | 5305262 | 20241013131028_IQrRM | NZ0015 | 2024-10-15T12:04:04.497Z | 2024-10-22T12:24:24.551Z |
5305210 | 5305210 | 20241013124306_5VnPQ | NZ0015 | 2024-10-15T12:03:58.672Z | 2024-10-22T12:24:23.996Z |
5305147 | 5305147 | 20241013121719_fhKyg | NZ0015 | 2024-10-15T12:03:46.625Z | 2024-10-22T12:24:23.555Z |
5298613 | 5298613 | 20241012164637_VTdje | NZ0015 | 2024-10-14T12:10:55.414Z | 2024-10-21T12:23:28.722Z |
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);