participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,472 rows where station_code = "NZ002T" 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 |
---|---|---|---|---|---|
5594399 | 5594399 | 20241124102441_z1MLd | NZ002T | 2024-11-25T14:05:36.156Z | 2024-11-26T14:18:44.075Z |
5594305 | 5594305 | 20241124101342_7ExEa | NZ002T | 2024-11-25T14:05:25.171Z | 2024-11-26T14:18:44.058Z |
5594299 | 5594299 | 20241124101331_t3SBG | NZ002T | 2024-11-25T14:05:24.865Z | 2024-11-26T14:18:44.057Z |
5594274 | 5594274 | 20241124100920_firzI | NZ002T | 2024-11-25T14:05:22.094Z | 2024-11-26T14:18:44.053Z |
5594270 | 5594270 | 20241124100916_wm6nm | NZ002T | 2024-11-25T14:05:21.731Z | 2024-11-26T14:18:44.052Z |
5594264 | 5594264 | 20241124100817_0G339 | NZ002T | 2024-11-25T14:05:21.063Z | 2024-11-26T14:18:44.051Z |
5594225 | 5594225 | 20241124100109_6na2E | NZ002T | 2024-11-25T14:05:08.706Z | 2024-11-26T14:18:44.044Z |
5594129 | 5594129 | 20241124094450_3XrXK | NZ002T | 2024-11-25T14:04:45.762Z | 2024-11-26T14:18:44.026Z |
5583047 | 5583047 | 20241120135935_9qQYd | NZ002T | 2024-11-23T14:22:42.733Z | 2024-11-26T14:26:07.615Z |
5583035 | 5583035 | 20241120132234_eJjUJ | NZ002T | 2024-11-23T14:22:40.276Z | 2024-11-26T14:26:07.250Z |
5576971 | 5576971 | 20241122145924_oItqg | NZ002T | 2024-11-23T14:11:01.000Z | 2024-11-26T14:22:54.851Z |
5576958 | 5576958 | 20241122145055_fTe2x | NZ002T | 2024-11-23T14:10:59.750Z | 2024-11-26T14:22:54.599Z |
5576864 | 5576864 | 20241122140943_UHR4b | NZ002T | 2024-11-23T14:10:45.606Z | 2024-11-26T14:22:53.459Z |
5568211 | 5568211 | 20241121120616_zUTk9 | NZ002T | 2024-11-22T14:08:27.772Z | 2024-11-26T14:24:25.542Z |
5567229 | 5567229 | 20241121094600_tcJ24 | NZ002T | 2024-11-22T14:05:38.110Z | 2024-11-26T14:24:14.139Z |
5560820 | 5560820 | 20241120143556_kni4e | NZ002T | 2024-11-21T14:09:48.380Z | 2024-11-26T14:26:07.915Z |
5560804 | 5560804 | 20241120142816_gN1Oy | NZ002T | 2024-11-21T14:09:46.873Z | 2024-11-26T14:26:07.849Z |
5560744 | 5560744 | 20241120141206_2gUqG | NZ002T | 2024-11-21T14:09:41.616Z | 2024-11-26T14:26:07.691Z |
5560715 | 5560715 | 20241120140233_jHreh | NZ002T | 2024-11-21T14:09:34.938Z | 2024-11-26T14:26:07.654Z |
5560542 | 5560542 | 20241120130803_NhfUG | NZ002T | 2024-11-21T14:09:04.008Z | 2024-11-26T14:26:06.990Z |
5560189 | 5560189 | 20241120121533_eQBCb | NZ002T | 2024-11-21T14:08:13.213Z | 2024-11-26T14:26:03.846Z |
5560185 | 5560185 | 20241120121524_CN29V | NZ002T | 2024-11-21T14:08:12.840Z | 2024-11-26T14:26:03.846Z |
5560033 | 5560033 | 20241120114853_LzrF4 | NZ002T | 2024-11-21T14:07:54.172Z | 2024-11-26T14:26:02.842Z |
5559844 | 5559844 | 20241120112341_3eVE9 | NZ002T | 2024-11-21T14:07:19.148Z | 2024-11-26T14:26:01.580Z |
5559771 | 5559771 | 20241120111628_AUkLc | NZ002T | 2024-11-21T14:07:09.796Z | 2024-11-26T14:26:00.266Z |
5559765 | 5559765 | 20241120111415_oYeeb | NZ002T | 2024-11-21T14:07:08.504Z | 2024-11-26T14:26:00.205Z |
5559709 | 5559709 | 20241120110324_25rkI | NZ002T | 2024-11-21T14:07:01.237Z | 2024-11-26T14:25:59.162Z |
5559506 | 5559506 | 20241120103502_wolHt | NZ002T | 2024-11-21T14:06:28.686Z | 2024-11-26T14:25:57.312Z |
5559453 | 5559453 | 20241120102525_gxgIa | NZ002T | 2024-11-21T14:06:21.893Z | 2024-11-26T14:25:57.081Z |
5559435 | 5559435 | 20241120102225_NmqYC | NZ002T | 2024-11-21T14:06:19.344Z | 2024-11-26T14:25:57.014Z |
5551544 | 5551544 | 20241118141121_UPKrd | NZ002T | 2024-11-19T14:04:58.364Z | 2024-11-26T14:28:08.237Z |
5551335 | 5551335 | 20241118130938_KuaCe | NZ002T | 2024-11-19T14:04:27.639Z | 2024-11-26T14:28:07.784Z |
5551320 | 5551320 | 20241118130626_bNAYR | NZ002T | 2024-11-19T14:04:24.415Z | 2024-11-26T14:28:07.609Z |
5551071 | 5551071 | 20241118121954_rDhtF | NZ002T | 2024-11-19T14:03:52.395Z | 2024-11-26T14:28:05.547Z |
5550984 | 5550984 | 20241118120649_YuYZW | NZ002T | 2024-11-19T14:03:44.078Z | 2024-11-26T14:28:05.386Z |
5550653 | 5550653 | 20241118110322_I0l5K | NZ002T | 2024-11-19T14:02:52.373Z | 2024-11-26T14:28:03.241Z |
5550376 | 5550376 | 20241118101031_LDejS | NZ002T | 2024-11-19T14:02:15.313Z | 2024-11-26T14:28:01.463Z |
5550110 | 5550110 | 20241118093102_kyLN5 | NZ002T | 2024-11-19T14:01:35.280Z | 2024-11-26T14:28:00.861Z |
5550083 | 5550083 | 20241118092850_yH3bY | NZ002T | 2024-11-19T14:01:33.109Z | 2024-11-26T14:28:00.815Z |
5547236 | 5547236 | 20241117151207_GZExJ | NZ002T | 2024-11-18T14:05:19.302Z | 2024-11-26T14:28:37.760Z |
5547194 | 5547194 | 20241117150421_KKJA3 | NZ002T | 2024-11-18T14:05:15.751Z | 2024-11-26T14:28:37.657Z |
5547014 | 5547014 | 20241117141335_fAyJ4 | NZ002T | 2024-11-18T14:04:42.393Z | 2024-11-26T14:28:35.217Z |
5547005 | 5547005 | 20241117141131_RjgKZ | NZ002T | 2024-11-18T14:04:41.582Z | 2024-11-26T14:28:35.209Z |
5546985 | 5546985 | 20241117135847_pgPZq | NZ002T | 2024-11-18T14:04:39.313Z | 2024-11-26T14:28:34.913Z |
5546960 | 5546960 | 20241117134600_mBUfn | NZ002T | 2024-11-18T14:04:33.624Z | 2024-11-26T14:28:34.818Z |
5546934 | 5546934 | 20241117132631_bP1gN | NZ002T | 2024-11-18T14:04:29.843Z | 2024-11-26T14:28:34.635Z |
5546870 | 5546870 | 20241117130912_NM2XL | NZ002T | 2024-11-18T14:04:23.056Z | 2024-11-26T14:28:34.193Z |
5546857 | 5546857 | 20241117130245_eWAmN | NZ002T | 2024-11-18T14:04:21.694Z | 2024-11-26T14:28:34.059Z |
5546550 | 5546550 | 20241117113254_WHneh | NZ002T | 2024-11-18T14:03:28.340Z | 2024-11-26T14:28:30.587Z |
5546360 | 5546360 | 20241117103126_YIhrN | NZ002T | 2024-11-18T14:02:55.373Z | 2024-11-26T14:28:27.200Z |
5546285 | 5546285 | 20241117101220_6Z2kK | NZ002T | 2024-11-18T14:02:41.401Z | 2024-11-26T14:28:26.711Z |
5546255 | 5546255 | 20241117100613_jdZq5 | NZ002T | 2024-11-18T14:02:35.354Z | 2024-11-26T14:28:26.142Z |
5546241 | 5546241 | 20241117100406_wCqgI | NZ002T | 2024-11-18T14:02:33.022Z | 2024-11-26T14:28:26.035Z |
5546122 | 5546122 | 20241117091931_rGDso | NZ002T | 2024-11-18T14:02:09.609Z | 2024-11-26T14:28:25.560Z |
5544763 | 5544763 | 20241116150918_Da4p4 | NZ002T | 2024-11-17T14:02:01.839Z | 2024-11-25T14:22:40.291Z |
5544746 | 5544746 | 20241116145725_YJff3 | NZ002T | 2024-11-17T14:01:59.774Z | 2024-11-25T14:22:40.248Z |
5544725 | 5544725 | 20241116144845_zAb2C | NZ002T | 2024-11-17T14:01:55.989Z | 2024-11-25T14:22:40.242Z |
5536146 | 5536146 | 20241112154913_6PChT | NZ002T | 2024-11-14T14:09:14.993Z | 2024-11-21T14:25:56.990Z |
5536079 | 5536079 | 20241112153352_C1Ch7 | NZ002T | 2024-11-14T14:09:10.491Z | 2024-11-21T14:25:56.488Z |
5536070 | 5536070 | 20241112153329_sAw56 | NZ002T | 2024-11-14T14:09:09.908Z | 2024-11-21T14:25:56.453Z |
5535996 | 5535996 | 20241112151445_zNZa9 | NZ002T | 2024-11-14T14:09:05.076Z | 2024-11-21T14:25:56.038Z |
5535992 | 5535992 | 20241112151229_L3x70 | NZ002T | 2024-11-14T14:09:04.720Z | 2024-11-21T14:25:56.002Z |
5535912 | 5535912 | 20241112145120_UJBDE | NZ002T | 2024-11-14T14:08:58.561Z | 2024-11-21T14:25:54.581Z |
5535909 | 5535909 | 20241112145035_E2WeP | NZ002T | 2024-11-14T14:08:58.422Z | 2024-11-21T14:25:54.579Z |
5535839 | 5535839 | 20241112143643_xhDuU | NZ002T | 2024-11-14T14:08:53.760Z | 2024-11-21T14:25:53.759Z |
5535761 | 5535761 | 20241112141318_3c7SJ | NZ002T | 2024-11-14T14:08:45.608Z | 2024-11-21T14:25:52.866Z |
5535744 | 5535744 | 20241112140418_3MtN3 | NZ002T | 2024-11-14T14:08:39.819Z | 2024-11-21T14:25:52.780Z |
5535742 | 5535742 | 20241112140323_Rm16b | NZ002T | 2024-11-14T14:08:39.028Z | 2024-11-21T14:25:52.764Z |
5535739 | 5535739 | 20241112140258_77VzH | NZ002T | 2024-11-14T14:08:38.209Z | 2024-11-21T14:25:52.761Z |
5535590 | 5535590 | 20241112125405_AtIYw | NZ002T | 2024-11-14T14:08:08.970Z | 2024-11-21T14:25:50.335Z |
5535436 | 5535436 | 20241112122614_cSjNl | NZ002T | 2024-11-14T14:07:56.162Z | 2024-11-21T14:25:48.244Z |
5534680 | 5534680 | 20241113152152_f7TfT | NZ002T | 2024-11-14T14:04:54.541Z | 2024-11-22T14:24:15.290Z |
5534675 | 5534675 | 20241113151809_3NMhZ | NZ002T | 2024-11-14T14:04:53.567Z | 2024-11-22T14:24:15.239Z |
5534673 | 5534673 | 20241113151759_BYSsM | NZ002T | 2024-11-14T14:04:52.946Z | 2024-11-22T14:24:15.238Z |
5534651 | 5534651 | 20241113145859_Xp8UI | NZ002T | 2024-11-14T14:04:47.955Z | 2024-11-22T14:24:14.965Z |
5534642 | 5534642 | 20241113141511_9vvrm | NZ002T | 2024-11-14T14:04:45.762Z | 2024-11-22T14:24:14.896Z |
5534618 | 5534618 | 20241113132057_yQjzV | NZ002T | 2024-11-14T14:04:43.177Z | 2024-11-22T14:24:14.794Z |
5534498 | 5534498 | 20241113122542_T3QFO | NZ002T | 2024-11-14T14:04:29.476Z | 2024-11-22T14:24:14.187Z |
5533731 | 5533731 | 20241113095741_FElVm | NZ002T | 2024-11-14T14:02:43.324Z | 2024-11-22T14:24:10.989Z |
5514151 | 5514151 | 20241110145125_lYqbH | NZ002T | 2024-11-11T14:06:16.351Z | 2024-11-19T14:21:44.318Z |
5514142 | 5514142 | 20241110144758_tQftc | NZ002T | 2024-11-11T14:06:15.776Z | 2024-11-19T14:21:44.213Z |
5514117 | 5514117 | 20241110143338_N9xUp | NZ002T | 2024-11-11T14:06:13.761Z | 2024-11-19T14:21:43.789Z |
5514061 | 5514061 | 20241110140629_rPjUJ | NZ002T | 2024-11-11T14:05:58.895Z | 2024-11-19T14:21:42.840Z |
5513428 | 5513428 | 20241110113136_T7Hyf | NZ002T | 2024-11-11T14:04:38.511Z | 2024-11-19T14:21:34.169Z |
5513228 | 5513228 | 20241110110119_EKOPQ | NZ002T | 2024-11-11T14:04:11.739Z | 2024-11-19T14:21:32.101Z |
5513072 | 5513072 | 20241110103242_JpJWC | NZ002T | 2024-11-11T14:03:50.509Z | 2024-11-19T14:21:30.858Z |
5513041 | 5513041 | 20241110102603_F9w3p | NZ002T | 2024-11-11T14:03:47.454Z | 2024-11-19T14:21:30.571Z |
5513012 | 5513012 | 20241110102206_4X8f7 | NZ002T | 2024-11-11T14:03:44.560Z | 2024-11-19T14:21:30.273Z |
5512944 | 5512944 | 20241110101442_4ZSZR | NZ002T | 2024-11-11T14:03:38.738Z | 2024-11-19T14:21:29.905Z |
5512768 | 5512768 | 20241110094630_xuC3y | NZ002T | 2024-11-11T14:03:07.127Z | 2024-11-19T14:21:27.929Z |
5512668 | 5512668 | 20241110092655_Info5 | NZ002T | 2024-11-11T14:02:55.844Z | 2024-11-19T14:21:27.192Z |
5508268 | 5508268 | 20241109154051_3qtwu | NZ002T | 2024-11-10T14:07:21.600Z | 2024-11-18T14:26:20.632Z |
5508173 | 5508173 | 20241109145544_A24eU | NZ002T | 2024-11-10T14:07:12.033Z | 2024-11-18T14:26:19.725Z |
5508154 | 5508154 | 20241109144751_m2HtA | NZ002T | 2024-11-10T14:07:10.496Z | 2024-11-18T14:26:19.571Z |
5508120 | 5508120 | 20241109143435_j6ce1 | NZ002T | 2024-11-10T14:07:06.064Z | 2024-11-18T14:26:19.007Z |
5508101 | 5508101 | 20241109142551_43op4 | NZ002T | 2024-11-10T14:07:01.580Z | 2024-11-18T14:26:18.917Z |
5508088 | 5508088 | 20241109141857_RnGwF | NZ002T | 2024-11-10T14:06:54.602Z | 2024-11-18T14:26:18.738Z |
5508084 | 5508084 | 20241109141704_FtKn5 | NZ002T | 2024-11-10T14:06:53.875Z | 2024-11-18T14:26:18.737Z |
5508055 | 5508055 | 20241109135318_l9IPT | NZ002T | 2024-11-10T14:06:45.866Z | 2024-11-18T14:26:18.129Z |
5508050 | 5508050 | 20241109135220_C9ezd | NZ002T | 2024-11-10T14:06:44.475Z | 2024-11-18T14:26:18.105Z |
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);