participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
185 rows where station_code = "NZ004R" 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 |
---|---|---|---|---|---|
5314859 | 5314859 | 20241016161836_gl0h7 | NZ004R | 2024-10-17T12:03:02.343Z | 2024-10-18T12:04:36.371Z |
5314843 | 5314843 | 20241016161414_yrd5m | NZ004R | 2024-10-17T12:03:00.248Z | 2024-10-18T12:04:36.368Z |
5314839 | 5314839 | 20241016161326_a3ton | NZ004R | 2024-10-17T12:02:59.783Z | 2024-10-18T12:04:36.368Z |
5314816 | 5314816 | 20241016160348_evRpT | NZ004R | 2024-10-17T12:02:55.532Z | 2024-10-18T12:04:36.364Z |
5314812 | 5314812 | 20241016160324_1V3EY | NZ004R | 2024-10-17T12:02:55.013Z | 2024-10-18T12:04:36.363Z |
5314810 | 5314810 | 20241016160118_b2YcX | NZ004R | 2024-10-17T12:02:54.035Z | 2024-10-18T12:04:36.363Z |
5314791 | 5314791 | 20241016155105_2Oaye | NZ004R | 2024-10-17T12:02:49.723Z | 2024-10-18T12:04:36.360Z |
5314715 | 5314715 | 20241016151547_vYVRS | NZ004R | 2024-10-17T12:02:43.571Z | 2024-10-18T12:04:36.349Z |
5314702 | 5314702 | 20241016151316_mLs9e | NZ004R | 2024-10-17T12:02:42.030Z | 2024-10-18T12:04:36.346Z |
5314682 | 5314682 | 20241016150144_Xbih5 | NZ004R | 2024-10-17T12:02:40.427Z | 2024-10-18T12:04:36.343Z |
5314679 | 5314679 | 20241016150142_wSeBi | NZ004R | 2024-10-17T12:02:40.080Z | 2024-10-18T12:04:36.343Z |
5314654 | 5314654 | 20241016144756_72lD6 | NZ004R | 2024-10-17T12:02:38.755Z | 2024-10-18T12:04:36.339Z |
5314638 | 5314638 | 20241016144237_HKnjc | NZ004R | 2024-10-17T12:02:37.322Z | 2024-10-18T12:04:36.336Z |
5314466 | 5314466 | 20241016131121_21m3q | NZ004R | 2024-10-17T12:02:26.950Z | 2024-10-18T12:04:36.311Z |
5314455 | 5314455 | 20241016130533_QPtQf | NZ004R | 2024-10-17T12:02:25.434Z | 2024-10-18T12:04:36.309Z |
5314440 | 5314440 | 20241016125845_r3x7e | NZ004R | 2024-10-17T12:02:23.841Z | 2024-10-18T12:04:36.307Z |
5314417 | 5314417 | 20241016125253_BUe4Z | NZ004R | 2024-10-17T12:02:19.262Z | 2024-10-18T12:04:36.304Z |
5314249 | 5314249 | 20241016120517_NmToV | NZ004R | 2024-10-17T12:01:54.299Z | 2024-10-18T12:04:36.281Z |
5314121 | 5314121 | 20241016113831_pELZx | NZ004R | 2024-10-17T12:01:43.844Z | 2024-10-18T12:04:36.259Z |
5313385 | 5313385 | 20241009145442_nmQ2l | NZ004R | 2024-10-16T12:19:56.851Z | 2024-10-18T12:21:57.475Z |
5313383 | 5313383 | 20241009141243_EXJXn | NZ004R | 2024-10-16T12:19:55.302Z | 2024-10-18T12:21:55.949Z |
5310319 | 5310319 | 20241014162003_LXDup | NZ004R | 2024-10-16T12:06:40.853Z | 2024-10-18T12:09:31.124Z |
5310096 | 5310096 | 20241014154304_yPq2W | NZ004R | 2024-10-16T12:06:26.585Z | 2024-10-18T12:09:22.059Z |
5310038 | 5310038 | 20241014152941_KW5M0 | NZ004R | 2024-10-16T12:06:23.966Z | 2024-10-18T12:09:20.107Z |
5307162 | 5307162 | 20241015081711_9PbZw | NZ004R | 2024-10-16T12:00:50.111Z | 2024-10-18T12:04:49.264Z |
5305642 | 5305642 | 20241013162412_xJT7B | NZ004R | 2024-10-15T12:04:59.117Z | 2024-10-18T12:12:33.099Z |
5305562 | 5305562 | 20241013155354_dWVEx | NZ004R | 2024-10-15T12:04:48.556Z | 2024-10-18T12:12:27.319Z |
5305548 | 5305548 | 20241013155122_7e2er | NZ004R | 2024-10-15T12:04:47.300Z | 2024-10-18T12:12:26.944Z |
5305481 | 5305481 | 20241013152357_1ndpH | NZ004R | 2024-10-15T12:04:40.828Z | 2024-10-18T12:12:23.752Z |
5305453 | 5305453 | 20241013152000_TugSk | NZ004R | 2024-10-15T12:04:38.594Z | 2024-10-18T12:12:23.202Z |
5305408 | 5305408 | 20241013150821_w88Il | NZ004R | 2024-10-15T12:04:33.617Z | 2024-10-18T12:12:20.693Z |
5305380 | 5305380 | 20241013145258_P27bG | NZ004R | 2024-10-15T12:04:25.472Z | 2024-10-18T12:12:18.923Z |
5305374 | 5305374 | 20241013145157_BWO7M | NZ004R | 2024-10-15T12:04:25.197Z | 2024-10-18T12:12:18.845Z |
5305361 | 5305361 | 20241013144443_mGnY3 | NZ004R | 2024-10-15T12:04:18.658Z | 2024-10-18T12:12:17.788Z |
5305355 | 5305355 | 20241013144400_U2ifX | NZ004R | 2024-10-15T12:04:18.102Z | 2024-10-18T12:12:17.705Z |
5305338 | 5305338 | 20241013143038_FLUEZ | NZ004R | 2024-10-15T12:04:15.472Z | 2024-10-18T12:12:17.301Z |
5305308 | 5305308 | 20241013135411_u7QVo | NZ004R | 2024-10-15T12:04:10.520Z | 2024-10-18T12:12:16.447Z |
5305285 | 5305285 | 20241013133950_WmCQf | NZ004R | 2024-10-15T12:04:07.498Z | 2024-10-18T12:12:15.729Z |
5305265 | 5305265 | 20241013131028_IQrRM | NZ004R | 2024-10-15T12:04:04.497Z | 2024-10-18T12:12:15.214Z |
5305261 | 5305261 | 20241013130919_C5vNr | NZ004R | 2024-10-15T12:04:04.128Z | 2024-10-18T12:12:15.172Z |
5305253 | 5305253 | 20241013130916_CcQlY | NZ004R | 2024-10-15T12:04:03.844Z | 2024-10-18T12:12:15.143Z |
5305248 | 5305248 | 20241013130819_A2oo0 | NZ004R | 2024-10-15T12:04:03.581Z | 2024-10-18T12:12:15.135Z |
5305235 | 5305235 | 20241013130157_3qWld | NZ004R | 2024-10-15T12:04:01.809Z | 2024-10-18T12:12:14.794Z |
5305229 | 5305229 | 20241013125155_EssJ5 | NZ004R | 2024-10-15T12:04:00.741Z | 2024-10-18T12:12:14.617Z |
5305222 | 5305222 | 20241013124834_7cUFq | NZ004R | 2024-10-15T12:03:59.634Z | 2024-10-18T12:12:14.458Z |
5305150 | 5305150 | 20241013121719_fhKyg | NZ004R | 2024-10-15T12:03:46.626Z | 2024-10-18T12:12:13.287Z |
5305137 | 5305137 | 20241013121637_0P92I | NZ004R | 2024-10-15T12:03:41.624Z | 2024-10-18T12:12:13.137Z |
5305101 | 5305101 | 20241013121126_HVVy4 | NZ004R | 2024-10-15T12:03:31.127Z | 2024-10-18T12:12:12.553Z |
5305027 | 5305027 | 20241013115333_PcLbm | NZ004R | 2024-10-15T12:03:16.567Z | 2024-10-18T12:12:11.225Z |
5304977 | 5304977 | 20241013114151_xPmIP | NZ004R | 2024-10-15T12:03:11.501Z | 2024-10-18T12:12:09.949Z |
5304654 | 5304654 | 20241013105955_ltbEm | NZ004R | 2024-10-15T12:02:23.112Z | 2024-10-18T12:12:00.543Z |
5298185 | 5298185 | 20241012154303_pDrHh | NZ004R | 2024-10-14T12:10:01.331Z | 2024-10-18T12:15:09.207Z |
5298170 | 5298170 | 20241012154128_5BPH3 | NZ004R | 2024-10-14T12:10:00.297Z | 2024-10-18T12:15:08.991Z |
5298126 | 5298126 | 20241012153258_J1q3k | NZ004R | 2024-10-14T12:09:56.198Z | 2024-10-18T12:15:08.526Z |
5298054 | 5298054 | 20241012152200_lcswQ | NZ004R | 2024-10-14T12:09:49.747Z | 2024-10-18T12:15:07.472Z |
5297962 | 5297962 | 20241012150323_ulPHH | NZ004R | 2024-10-14T12:09:30.962Z | 2024-10-18T12:15:05.839Z |
5297945 | 5297945 | 20241012150006_XwtxT | NZ004R | 2024-10-14T12:09:28.412Z | 2024-10-18T12:15:05.638Z |
5297920 | 5297920 | 20241012145449_s8jyC | NZ004R | 2024-10-14T12:09:24.467Z | 2024-10-18T12:15:05.347Z |
5297865 | 5297865 | 20241012144831_jwzmO | NZ004R | 2024-10-14T12:09:15.868Z | 2024-10-18T12:15:04.700Z |
5297800 | 5297800 | 20241012143802_FGKdh | NZ004R | 2024-10-14T12:09:09.810Z | 2024-10-18T12:15:04.182Z |
5297773 | 5297773 | 20241012143418_B9Fmm | NZ004R | 2024-10-14T12:09:07.811Z | 2024-10-18T12:15:03.874Z |
5297262 | 5297262 | 20241012122806_2sNJQ | NZ004R | 2024-10-14T12:08:02.168Z | 2024-10-18T12:14:56.943Z |
5296942 | 5296942 | 20241012113109_KbfLg | NZ004R | 2024-10-14T12:07:10.809Z | 2024-10-18T12:14:52.412Z |
5296213 | 5296213 | 20241012094115_f3fpW | NZ004R | 2024-10-14T12:05:31.730Z | 2024-10-18T12:14:31.552Z |
5295964 | 5295964 | 20241013093214_Erbq0 | NZ004R | 2024-10-14T12:03:52.977Z | 2024-10-18T12:11:53.518Z |
5295861 | 5295861 | 20241013091303_LL8d1 | NZ004R | 2024-10-14T12:03:39.001Z | 2024-10-18T12:11:52.018Z |
5287354 | 5287354 | 20241011112650_Cg4N3 | NZ004R | 2024-10-13T12:07:04.341Z | 2024-10-18T12:18:37.066Z |
5286980 | 5286980 | 20241011104430_3qiE5 | NZ004R | 2024-10-13T12:06:08.666Z | 2024-10-18T12:18:29.797Z |
5286667 | 5286667 | 20241012090937_MWJeX | NZ004R | 2024-10-13T12:03:13.741Z | 2024-10-18T12:14:25.639Z |
5286609 | 5286609 | 20241012090026_PtyAK | NZ004R | 2024-10-13T12:03:03.665Z | 2024-10-18T12:14:23.923Z |
5286571 | 5286571 | 20241012085517_nuhcP | NZ004R | 2024-10-13T12:02:49.867Z | 2024-10-18T12:14:22.996Z |
5286507 | 5286507 | 20241012084701_2pm07 | NZ004R | 2024-10-13T12:02:37.575Z | 2024-10-18T12:14:20.898Z |
5280742 | 5280742 | 20241010163342_UhHqZ | NZ004R | 2024-10-12T12:12:48.702Z | 2024-10-18T12:20:53.454Z |
5280680 | 5280680 | 20241010162849_zINTG | NZ004R | 2024-10-12T12:12:42.093Z | 2024-10-18T12:20:52.532Z |
5280522 | 5280522 | 20241010161558_z150G | NZ004R | 2024-10-12T12:12:33.447Z | 2024-10-18T12:20:51.543Z |
5280381 | 5280381 | 20241010160348_1nDSv | NZ004R | 2024-10-12T12:12:25.504Z | 2024-10-18T12:20:50.673Z |
5280224 | 5280224 | 20241010155111_rwUFZ | NZ004R | 2024-10-12T12:12:04.953Z | 2024-10-18T12:20:49.991Z |
5280146 | 5280146 | 20241010154438_u4Nj7 | NZ004R | 2024-10-12T12:11:57.038Z | 2024-10-18T12:20:49.427Z |
5280102 | 5280102 | 20241010154147_n1DvW | NZ004R | 2024-10-12T12:11:53.082Z | 2024-10-18T12:20:48.975Z |
5280092 | 5280092 | 20241010154132_2R0sv | NZ004R | 2024-10-12T12:11:52.412Z | 2024-10-18T12:20:48.934Z |
5280075 | 5280075 | 20241010153835_yyyer | NZ004R | 2024-10-12T12:11:51.599Z | 2024-10-18T12:20:48.776Z |
5279915 | 5279915 | 20241010152932_yOGh4 | NZ004R | 2024-10-12T12:11:33.657Z | 2024-10-18T12:20:48.115Z |
5279899 | 5279899 | 20241010152827_GmX7A | NZ004R | 2024-10-12T12:11:32.060Z | 2024-10-18T12:20:47.944Z |
5279853 | 5279853 | 20241010152340_h0Bwm | NZ004R | 2024-10-12T12:11:25.155Z | 2024-10-18T12:20:47.702Z |
5279844 | 5279844 | 20241010152330_t8jGv | NZ004R | 2024-10-12T12:11:23.757Z | 2024-10-18T12:20:47.688Z |
5279836 | 5279836 | 20241010152316_DDnWT | NZ004R | 2024-10-12T12:11:23.560Z | 2024-10-18T12:20:47.688Z |
5279832 | 5279832 | 20241010152246_f7ptv | NZ004R | 2024-10-12T12:11:22.516Z | 2024-10-18T12:20:47.643Z |
5279790 | 5279790 | 20241010151838_G8SOc | NZ004R | 2024-10-12T12:11:19.783Z | 2024-10-18T12:20:47.262Z |
5279529 | 5279529 | 20241010144918_IPxVu | NZ004R | 2024-10-12T12:11:01.051Z | 2024-10-18T12:20:44.493Z |
5279437 | 5279437 | 20241010144004_RoekF | NZ004R | 2024-10-12T12:10:53.755Z | 2024-10-18T12:20:42.779Z |
5279352 | 5279352 | 20241010142938_q8yW3 | NZ004R | 2024-10-12T12:10:41.433Z | 2024-10-18T12:20:41.726Z |
5279335 | 5279335 | 20241010142823_PPFK6 | NZ004R | 2024-10-12T12:10:37.059Z | 2024-10-18T12:20:41.678Z |
5279171 | 5279171 | 20241010140617_ffo1w | NZ004R | 2024-10-12T12:10:15.380Z | 2024-10-18T12:20:40.748Z |
5279137 | 5279137 | 20241010140324_xiEWs | NZ004R | 2024-10-12T12:10:12.489Z | 2024-10-18T12:20:40.224Z |
5279069 | 5279069 | 20241010135913_PNRfW | NZ004R | 2024-10-12T12:10:07.967Z | 2024-10-18T12:20:39.619Z |
5279035 | 5279035 | 20241010135647_DwEr4 | NZ004R | 2024-10-12T12:10:06.157Z | 2024-10-18T12:20:39.481Z |
5278986 | 5278986 | 20241010135031_L6HGI | NZ004R | 2024-10-12T12:10:02.330Z | 2024-10-18T12:20:39.006Z |
5278911 | 5278911 | 20241010134043_Ps39H | NZ004R | 2024-10-12T12:09:56.330Z | 2024-10-18T12:20:37.299Z |
5278808 | 5278808 | 20241010132452_7XP3k | NZ004R | 2024-10-12T12:09:41.701Z | 2024-10-18T12:20:35.598Z |
5278731 | 5278731 | 20241010131729_wYenR | NZ004R | 2024-10-12T12:09:28.787Z | 2024-10-18T12:20:35.186Z |
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);