participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,125 rows where station_code = "NZ0012" 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 |
---|---|---|---|---|---|
5494075 | 5494075 | 20241107152906_k1NBr | NZ0012 | 2024-11-08T14:05:20.593Z | 2024-11-09T14:16:27.835Z |
5493986 | 5493986 | 20241107150452_huW9q | NZ0012 | 2024-11-08T14:05:12.659Z | 2024-11-09T14:16:27.803Z |
5493931 | 5493931 | 20241107144055_IyYwj | NZ0012 | 2024-11-08T14:04:58.401Z | 2024-11-09T14:16:27.779Z |
5493910 | 5493910 | 20241107143253_aZWzn | NZ0012 | 2024-11-08T14:04:52.508Z | 2024-11-09T14:16:27.771Z |
5493902 | 5493902 | 20241107143110_nDiJL | NZ0012 | 2024-11-08T14:04:50.990Z | 2024-11-09T14:16:27.769Z |
5493866 | 5493866 | 20241107142256_bGd0I | NZ0012 | 2024-11-08T14:04:47.895Z | 2024-11-09T14:16:27.761Z |
5493859 | 5493859 | 20241107142135_CuYhC | NZ0012 | 2024-11-08T14:04:46.995Z | 2024-11-09T14:16:27.759Z |
5493836 | 5493836 | 20241107140238_YqDuP | NZ0012 | 2024-11-08T14:04:42.919Z | 2024-11-09T14:16:27.748Z |
5493831 | 5493831 | 20241107140135_abRvW | NZ0012 | 2024-11-08T14:04:42.769Z | 2024-11-09T14:16:27.747Z |
5493702 | 5493702 | 20241107130628_7K3V3 | NZ0012 | 2024-11-08T14:04:30.713Z | 2024-11-09T14:16:27.699Z |
5493696 | 5493696 | 20241107130501_hu0rS | NZ0012 | 2024-11-08T14:04:30.490Z | 2024-11-09T14:16:27.697Z |
5493679 | 5493679 | 20241107130036_tI8Sw | NZ0012 | 2024-11-08T14:04:28.995Z | 2024-11-09T14:16:27.693Z |
5493667 | 5493667 | 20241107125812_wPnzL | NZ0012 | 2024-11-08T14:04:27.793Z | 2024-11-09T14:16:27.688Z |
5493602 | 5493602 | 20241107124452_66mDI | NZ0012 | 2024-11-08T14:04:15.663Z | 2024-11-09T14:16:27.671Z |
5493568 | 5493568 | 20241107123722_35ui5 | NZ0012 | 2024-11-08T14:04:06.445Z | 2024-11-09T14:16:27.659Z |
5493543 | 5493543 | 20241107123139_VfRW2 | NZ0012 | 2024-11-08T14:04:01.912Z | 2024-11-09T14:16:27.651Z |
5493510 | 5493510 | 20241107122339_LlJxb | NZ0012 | 2024-11-08T14:03:55.254Z | 2024-11-09T14:16:27.643Z |
5493495 | 5493495 | 20241107122300_fCJpK | NZ0012 | 2024-11-08T14:03:53.269Z | 2024-11-09T14:16:27.641Z |
5493375 | 5493375 | 20241107115932_2nz24 | NZ0012 | 2024-11-08T14:03:38.816Z | 2024-11-09T14:16:27.604Z |
5493300 | 5493300 | 20241107114508_ssPuR | NZ0012 | 2024-11-08T14:03:30.551Z | 2024-11-09T14:16:27.582Z |
5493295 | 5493295 | 20241107114351_UrkxL | NZ0012 | 2024-11-08T14:03:30.218Z | 2024-11-09T14:16:27.581Z |
5493277 | 5493277 | 20241107113319_7hzkB | NZ0012 | 2024-11-08T14:03:27.591Z | 2024-11-09T14:16:27.575Z |
5493231 | 5493231 | 20241107112107_FkH4e | NZ0012 | 2024-11-08T14:03:14.702Z | 2024-11-09T14:16:27.564Z |
5493216 | 5493216 | 20241107111904_I0ruc | NZ0012 | 2024-11-08T14:03:11.428Z | 2024-11-09T14:16:27.562Z |
5493169 | 5493169 | 20241107111220_coJui | NZ0012 | 2024-11-08T14:03:01.387Z | 2024-11-09T14:16:27.552Z |
5493130 | 5493130 | 20241107110132_3r7bN | NZ0012 | 2024-11-08T14:02:56.242Z | 2024-11-09T14:16:27.541Z |
5493075 | 5493075 | 20241107104948_bMyA0 | NZ0012 | 2024-11-08T14:02:49.057Z | 2024-11-09T14:16:27.526Z |
5493017 | 5493017 | 20241107103735_jk0cP | NZ0012 | 2024-11-08T14:02:43.631Z | 2024-11-09T14:16:27.509Z |
5492988 | 5492988 | 20241107103118_Ewhme | NZ0012 | 2024-11-08T14:02:40.678Z | 2024-11-09T14:16:27.503Z |
5492963 | 5492963 | 20241107102647_LAiPS | NZ0012 | 2024-11-08T14:02:38.774Z | 2024-11-09T14:16:27.498Z |
5492939 | 5492939 | 20241107102256_8V8Nn | NZ0012 | 2024-11-08T14:02:36.552Z | 2024-11-09T14:16:27.493Z |
5492880 | 5492880 | 20241107101432_bhf3U | NZ0012 | 2024-11-08T14:02:23.243Z | 2024-11-09T14:16:27.478Z |
5492791 | 5492791 | 20241107095645_dtYz1 | NZ0012 | 2024-11-08T14:02:06.068Z | 2024-11-09T14:16:27.455Z |
5473761 | 5473761 | 20241103150021_dLPNY | NZ0012 | 2024-11-05T14:09:42.288Z | 2024-11-09T14:21:40.901Z |
5473685 | 5473685 | 20241103144908_8mAZP | NZ0012 | 2024-11-05T14:09:24.495Z | 2024-11-09T14:21:40.380Z |
5473676 | 5473676 | 20241103144853_J8lxx | NZ0012 | 2024-11-05T14:09:23.398Z | 2024-11-09T14:21:40.377Z |
5473651 | 5473651 | 20241103144606_g5Ad3 | NZ0012 | 2024-11-05T14:09:19.795Z | 2024-11-09T14:21:40.277Z |
5473641 | 5473641 | 20241103144444_yUSuA | NZ0012 | 2024-11-05T14:09:18.823Z | 2024-11-09T14:21:40.271Z |
5473507 | 5473507 | 20241103142736_w2EYq | NZ0012 | 2024-11-05T14:09:02.141Z | 2024-11-09T14:21:39.274Z |
5473483 | 5473483 | 20241103142305_3BzvG | NZ0012 | 2024-11-05T14:08:59.302Z | 2024-11-09T14:21:39.018Z |
5473433 | 5473433 | 20241103141602_h4F03 | NZ0012 | 2024-11-05T14:08:55.918Z | 2024-11-09T14:21:38.833Z |
5473355 | 5473355 | 20241103140511_eEII8 | NZ0012 | 2024-11-05T14:08:50.320Z | 2024-11-09T14:21:37.967Z |
5473253 | 5473253 | 20241103134958_232kb | NZ0012 | 2024-11-05T14:08:42.348Z | 2024-11-09T14:21:37.364Z |
5473190 | 5473190 | 20241103133810_5j0Jj | NZ0012 | 2024-11-05T14:08:30.624Z | 2024-11-09T14:21:37.197Z |
5473172 | 5473172 | 20241103133648_xMX38 | NZ0012 | 2024-11-05T14:08:28.617Z | 2024-11-09T14:21:37.184Z |
5473118 | 5473118 | 20241103132957_EtBe9 | NZ0012 | 2024-11-05T14:08:19.394Z | 2024-11-09T14:21:37.021Z |
5473110 | 5473110 | 20241103132944_yAy3T | NZ0012 | 2024-11-05T14:08:17.886Z | 2024-11-09T14:21:37.004Z |
5473096 | 5473096 | 20241103132758_iwYgR | NZ0012 | 2024-11-05T14:08:14.813Z | 2024-11-09T14:21:36.972Z |
5473038 | 5473038 | 20241103131755_t6BMh | NZ0012 | 2024-11-05T14:08:05.708Z | 2024-11-09T14:21:36.749Z |
5472957 | 5472957 | 20241103130451_1H0iY | NZ0012 | 2024-11-05T14:07:54.943Z | 2024-11-09T14:21:36.143Z |
5472721 | 5472721 | 20241103122811_7uoDk | NZ0012 | 2024-11-05T14:07:37.000Z | 2024-11-09T14:21:34.275Z |
5472698 | 5472698 | 20241103122451_rwg02 | NZ0012 | 2024-11-05T14:07:32.972Z | 2024-11-09T14:21:34.198Z |
5465488 | 5465488 | 20241103121247_38GzB | NZ0012 | 2024-11-04T14:03:48.658Z | 2024-11-09T14:21:33.571Z |
5465461 | 5465461 | 20241103120938_74qb2 | NZ0012 | 2024-11-04T14:03:46.510Z | 2024-11-09T14:21:33.496Z |
5465410 | 5465410 | 20241103115022_4Ls0m | NZ0012 | 2024-11-04T14:03:40.154Z | 2024-11-09T14:21:33.131Z |
5465401 | 5465401 | 20241103114535_7H722 | NZ0012 | 2024-11-04T14:03:38.614Z | 2024-11-09T14:21:33.013Z |
5465361 | 5465361 | 20241103113629_pgtgq | NZ0012 | 2024-11-04T14:03:34.508Z | 2024-11-09T14:21:32.600Z |
5465315 | 5465315 | 20241103112308_B4iBm | NZ0012 | 2024-11-04T14:03:18.846Z | 2024-11-09T14:21:32.027Z |
5465254 | 5465254 | 20241103111217_yL9X5 | NZ0012 | 2024-11-04T14:03:11.140Z | 2024-11-09T14:21:31.680Z |
5465209 | 5465209 | 20241103110242_Bq22x | NZ0012 | 2024-11-04T14:03:04.531Z | 2024-11-09T14:21:31.367Z |
5465134 | 5465134 | 20241103104539_mjiGY | NZ0012 | 2024-11-04T14:02:54.935Z | 2024-11-09T14:21:31.021Z |
5465007 | 5465007 | 20241103102041_UFG92 | NZ0012 | 2024-11-04T14:02:27.917Z | 2024-11-09T14:21:30.156Z |
5464940 | 5464940 | 20241103095739_1nJB1 | NZ0012 | 2024-11-04T14:02:15.393Z | 2024-11-09T14:21:29.773Z |
5464738 | 5464738 | 20241103090502_4Y9km | NZ0012 | 2024-11-04T14:01:32.081Z | 2024-11-09T14:21:28.498Z |
5464634 | 5464634 | 20241103083948_2sCdH | NZ0012 | 2024-11-04T14:01:11.099Z | 2024-11-09T14:21:27.371Z |
5461135 | 5461135 | 20241101160827_ihXAP | NZ0012 | 2024-11-03T14:14:45.325Z | 2024-11-09T14:23:27.126Z |
5461078 | 5461078 | 20241101155018_Z9PMu | NZ0012 | 2024-11-03T14:14:42.304Z | 2024-11-09T14:23:26.896Z |
5461075 | 5461075 | 20241101154834_8ET0C | NZ0012 | 2024-11-03T14:14:42.106Z | 2024-11-09T14:23:26.894Z |
5461043 | 5461043 | 20241101153944_OZJqU | NZ0012 | 2024-11-03T14:14:40.640Z | 2024-11-09T14:23:26.798Z |
5460945 | 5460945 | 20241101152415_y7xVv | NZ0012 | 2024-11-03T14:14:35.516Z | 2024-11-09T14:23:25.905Z |
5460906 | 5460906 | 20241101151839_Nrqif | NZ0012 | 2024-11-03T14:14:33.607Z | 2024-11-09T14:23:25.822Z |
5460846 | 5460846 | 20241101151243_jnBuj | NZ0012 | 2024-11-03T14:14:31.485Z | 2024-11-09T14:23:25.723Z |
5460797 | 5460797 | 20241101150508_9BWZ2 | NZ0012 | 2024-11-03T14:14:26.600Z | 2024-11-09T14:23:25.535Z |
5460709 | 5460709 | 20241101145547_IFU2T | NZ0012 | 2024-11-03T14:14:16.745Z | 2024-11-09T14:23:24.855Z |
5460620 | 5460620 | 20241101143906_PXT9b | NZ0012 | 2024-11-03T14:14:04.590Z | 2024-11-09T14:23:24.663Z |
5460603 | 5460603 | 20241101143747_i0Gvx | NZ0012 | 2024-11-03T14:14:02.734Z | 2024-11-09T14:23:24.652Z |
5458811 | 5458811 | 20241101092040_ODRqF | NZ0012 | 2024-11-03T14:10:39.217Z | 2024-11-09T14:23:14.594Z |
5458556 | 5458556 | 20241101084249_t3bNy | NZ0012 | 2024-11-03T14:09:58.495Z | 2024-11-09T14:23:12.851Z |
5458001 | 5458001 | 20241102155654_Kpy2Q | NZ0012 | 2024-11-03T14:08:31.975Z | 2024-11-09T14:22:49.356Z |
5457948 | 5457948 | 20241102154543_mK3Ai | NZ0012 | 2024-11-03T14:08:23.368Z | 2024-11-09T14:22:49.134Z |
5457937 | 5457937 | 20241102154406_DEzCf | NZ0012 | 2024-11-03T14:08:22.386Z | 2024-11-09T14:22:49.109Z |
5457886 | 5457886 | 20241102153459_BEpYC | NZ0012 | 2024-11-03T14:08:18.548Z | 2024-11-09T14:22:49.029Z |
5457710 | 5457710 | 20241102151456_yUaxz | NZ0012 | 2024-11-03T14:07:53.958Z | 2024-11-09T14:22:48.566Z |
5457691 | 5457691 | 20241102151010_P5MuQ | NZ0012 | 2024-11-03T14:07:51.839Z | 2024-11-09T14:22:48.445Z |
5457660 | 5457660 | 20241102150407_EqPcI | NZ0012 | 2024-11-03T14:07:47.802Z | 2024-11-09T14:22:48.364Z |
5457572 | 5457572 | 20241102144758_IWJzX | NZ0012 | 2024-11-03T14:07:41.078Z | 2024-11-09T14:22:48.203Z |
5457550 | 5457550 | 20241102144530_eHbZ4 | NZ0012 | 2024-11-03T14:07:38.670Z | 2024-11-09T14:22:48.145Z |
5457532 | 5457532 | 20241102144028_M3LV4 | NZ0012 | 2024-11-03T14:07:36.542Z | 2024-11-09T14:22:48.113Z |
5457495 | 5457495 | 20241102143842_xw2hV | NZ0012 | 2024-11-03T14:07:34.368Z | 2024-11-09T14:22:48.041Z |
5457422 | 5457422 | 20241102142849_1njXB | NZ0012 | 2024-11-03T14:07:17.474Z | 2024-11-09T14:22:47.702Z |
5457350 | 5457350 | 20241102141844_w0QUi | NZ0012 | 2024-11-03T14:07:10.090Z | 2024-11-09T14:22:47.535Z |
5457280 | 5457280 | 20241102140338_KTXIh | NZ0012 | 2024-11-03T14:07:02.729Z | 2024-11-09T14:22:47.258Z |
5457258 | 5457258 | 20241102135944_mzdSF | NZ0012 | 2024-11-03T14:07:00.096Z | 2024-11-09T14:22:47.203Z |
5457222 | 5457222 | 20241102135352_hy7vN | NZ0012 | 2024-11-03T14:06:57.321Z | 2024-11-09T14:22:47.168Z |
5457212 | 5457212 | 20241102135102_PpNf4 | NZ0012 | 2024-11-03T14:06:54.461Z | 2024-11-09T14:22:47.128Z |
5457200 | 5457200 | 20241102134615_AgDp9 | NZ0012 | 2024-11-03T14:06:45.025Z | 2024-11-09T14:22:47.040Z |
5457139 | 5457139 | 20241102133705_pgj14 | NZ0012 | 2024-11-03T14:06:38.303Z | 2024-11-09T14:22:46.829Z |
5457092 | 5457092 | 20241102132958_2NIaB | NZ0012 | 2024-11-03T14:06:33.038Z | 2024-11-09T14:22:46.658Z |
5457087 | 5457087 | 20241102132907_q5IRF | NZ0012 | 2024-11-03T14:06:32.005Z | 2024-11-09T14:22:46.648Z |
5457084 | 5457084 | 20241102132901_Ovdqn | NZ0012 | 2024-11-03T14:06:31.631Z | 2024-11-09T14:22:46.596Z |
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);