participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,235 rows where station_code = "NZ002N" 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 |
---|---|---|---|---|---|
5461058 | 5461058 | 20241101154235_kwgxv | NZ002N | 2024-11-03T14:14:41.174Z | 2024-11-03T14:19:33.663Z |
5461020 | 5461020 | 20241101153516_AMKF1 | NZ002N | 2024-11-03T14:14:39.427Z | 2024-11-03T14:19:33.656Z |
5460639 | 5460639 | 20241101144105_DDqo8 | NZ002N | 2024-11-03T14:14:06.865Z | 2024-11-03T14:19:33.588Z |
5460579 | 5460579 | 20241101143257_Th3qn | NZ002N | 2024-11-03T14:14:00.140Z | 2024-11-03T14:19:33.579Z |
5460553 | 5460553 | 20241101142949_42xP2 | NZ002N | 2024-11-03T14:13:58.823Z | 2024-11-03T14:19:33.573Z |
5460497 | 5460497 | 20241101142342_2BV9V | NZ002N | 2024-11-03T14:13:51.758Z | 2024-11-03T14:19:33.562Z |
5460479 | 5460479 | 20241101141910_ClGYh | NZ002N | 2024-11-03T14:13:49.149Z | 2024-11-03T14:19:33.558Z |
5460345 | 5460345 | 20241101135315_xBtDg | NZ002N | 2024-11-03T14:13:37.412Z | 2024-11-03T14:19:33.527Z |
5460176 | 5460176 | 20241101130224_Ka0Xy | NZ002N | 2024-11-03T14:13:26.647Z | 2024-11-03T14:19:33.493Z |
5460133 | 5460133 | 20241101125235_l8Hh3 | NZ002N | 2024-11-03T14:13:23.594Z | 2024-11-03T14:19:33.484Z |
5460119 | 5460119 | 20241101124833_5yOb2 | NZ002N | 2024-11-03T14:13:22.245Z | 2024-11-03T14:19:33.480Z |
5459988 | 5459988 | 20241101122744_oOmN3 | NZ002N | 2024-11-03T14:13:03.524Z | 2024-11-03T14:19:33.459Z |
5459772 | 5459772 | 20241101114853_RJHle | NZ002N | 2024-11-03T14:12:34.949Z | 2024-11-03T14:19:33.416Z |
5459538 | 5459538 | 20241101111515_6yEIY | NZ002N | 2024-11-03T14:12:15.709Z | 2024-11-03T14:19:33.365Z |
5459388 | 5459388 | 20241101105253_ZJhon | NZ002N | 2024-11-03T14:11:47.333Z | 2024-11-03T14:19:33.332Z |
5459240 | 5459240 | 20241101102706_fxWzM | NZ002N | 2024-11-03T14:11:33.044Z | 2024-11-03T14:19:33.300Z |
5459175 | 5459175 | 20241101102050_DstMT | NZ002N | 2024-11-03T14:11:27.461Z | 2024-11-03T14:19:33.287Z |
5459062 | 5459062 | 20241101100354_WD33u | NZ002N | 2024-11-03T14:11:10.645Z | 2024-11-03T14:19:33.260Z |
5458883 | 5458883 | 20241101093502_8z4cb | NZ002N | 2024-11-03T14:10:46.245Z | 2024-11-03T14:19:33.221Z |
5458818 | 5458818 | 20241101092230_GxwoY | NZ002N | 2024-11-03T14:10:39.924Z | 2024-11-03T14:19:33.205Z |
5458470 | 5458470 | 20241101083101_UAXqs | NZ002N | 2024-11-03T14:09:48.614Z | 2024-11-03T14:19:33.131Z |
5457361 | 5457361 | 20241102141955_zCBOE | NZ002N | 2024-11-03T14:07:10.636Z | 2024-11-03T14:07:10.636Z |
5457345 | 5457345 | 20241102141834_vR2ba | NZ002N | 2024-11-03T14:07:09.707Z | 2024-11-03T14:07:09.707Z |
5457328 | 5457328 | 20241102141109_PcWvi | NZ002N | 2024-11-03T14:07:07.875Z | 2024-11-03T14:07:07.875Z |
5457205 | 5457205 | 20241102134802_tTUqQ | NZ002N | 2024-11-03T14:06:47.259Z | 2024-11-03T14:06:47.259Z |
5457160 | 5457160 | 20241102134101_j5O3t | NZ002N | 2024-11-03T14:06:40.466Z | 2024-11-03T14:06:40.466Z |
5457078 | 5457078 | 20241102132858_sf2QN | NZ002N | 2024-11-03T14:06:31.057Z | 2024-11-03T14:06:31.057Z |
5456784 | 5456784 | 20241102122301_o9v7P | NZ002N | 2024-11-03T14:05:40.743Z | 2024-11-03T14:05:40.743Z |
5456775 | 5456775 | 20241102122227_fI9nf | NZ002N | 2024-11-03T14:05:39.916Z | 2024-11-03T14:05:39.916Z |
5456678 | 5456678 | 20241102120248_ygzbq | NZ002N | 2024-11-03T14:05:21.833Z | 2024-11-03T14:05:21.833Z |
5456620 | 5456620 | 20241102115322_pEc3B | NZ002N | 2024-11-03T14:05:09.112Z | 2024-11-03T14:05:09.112Z |
5456595 | 5456595 | 20241102114906_QNwqy | NZ002N | 2024-11-03T14:05:04.405Z | 2024-11-03T14:05:04.405Z |
5456548 | 5456548 | 20241102114517_wOy26 | NZ002N | 2024-11-03T14:04:58.205Z | 2024-11-03T14:04:58.205Z |
5456489 | 5456489 | 20241102113345_LJ2rS | NZ002N | 2024-11-03T14:04:49.672Z | 2024-11-03T14:04:49.672Z |
5456431 | 5456431 | 20241102111955_DR9qm | NZ002N | 2024-11-03T14:04:32.524Z | 2024-11-03T14:04:32.524Z |
5456298 | 5456298 | 20241102105515_133Qo | NZ002N | 2024-11-03T14:04:08.402Z | 2024-11-03T14:04:08.402Z |
5360330 | 5360330 | 20241023155908_Vlalh | NZ002N | 2024-10-25T12:10:34.165Z | 2024-11-01T12:26:47.375Z |
5360284 | 5360284 | 20241023155346_DmzrH | NZ002N | 2024-10-25T12:10:27.911Z | 2024-11-01T12:26:47.328Z |
5360270 | 5360270 | 20241023155124_6Ob2U | NZ002N | 2024-10-25T12:10:26.970Z | 2024-11-01T12:26:47.320Z |
5360118 | 5360118 | 20241023153338_kq1G2 | NZ002N | 2024-10-25T12:10:13.000Z | 2024-11-01T12:26:47.186Z |
5360110 | 5360110 | 20241023153113_MQq6J | NZ002N | 2024-10-25T12:10:12.462Z | 2024-11-01T12:26:47.183Z |
5360048 | 5360048 | 20241023151938_6nxNj | NZ002N | 2024-10-25T12:10:05.359Z | 2024-11-01T12:26:47.021Z |
5360038 | 5360038 | 20241023151805_8jdPs | NZ002N | 2024-10-25T12:10:04.229Z | 2024-11-01T12:26:47.017Z |
5359988 | 5359988 | 20241023151015_BgJ73 | NZ002N | 2024-10-25T12:09:49.816Z | 2024-11-01T12:26:46.974Z |
5359963 | 5359963 | 20241023150754_hy4nw | NZ002N | 2024-10-25T12:09:44.120Z | 2024-11-01T12:26:46.961Z |
5359872 | 5359872 | 20241023145624_tIL2d | NZ002N | 2024-10-25T12:09:33.973Z | 2024-11-01T12:26:46.826Z |
5359758 | 5359758 | 20241023143720_3kwTh | NZ002N | 2024-10-25T12:09:23.637Z | 2024-11-01T12:26:46.597Z |
5359716 | 5359716 | 20241023143122_1b5KZ | NZ002N | 2024-10-25T12:09:18.670Z | 2024-11-01T12:26:46.551Z |
5359560 | 5359560 | 20241023135944_pcXqT | NZ002N | 2024-10-25T12:08:49.291Z | 2024-11-01T12:26:45.826Z |
5359554 | 5359554 | 20241023135848_ogLPc | NZ002N | 2024-10-25T12:08:47.839Z | 2024-11-01T12:26:45.822Z |
5359547 | 5359547 | 20241023135813_OpLir | NZ002N | 2024-10-25T12:08:46.868Z | 2024-11-01T12:26:45.819Z |
5359436 | 5359436 | 20241023133508_h28N5 | NZ002N | 2024-10-25T12:08:36.289Z | 2024-11-01T12:26:45.656Z |
5359231 | 5359231 | 20241023125133_f3HMJ | NZ002N | 2024-10-25T12:07:57.105Z | 2024-11-01T12:26:45.230Z |
5359174 | 5359174 | 20241023124038_jRTwX | NZ002N | 2024-10-25T12:07:50.000Z | 2024-11-01T12:26:45.125Z |
5358676 | 5358676 | 20241023115621_s4QWQ | NZ002N | 2024-10-25T12:06:42.024Z | 2024-11-01T12:26:43.843Z |
5358550 | 5358550 | 20241023114308_3RUiM | NZ002N | 2024-10-25T12:06:28.517Z | 2024-11-01T12:26:43.545Z |
5358312 | 5358312 | 20241023112124_Cm7mf | NZ002N | 2024-10-25T12:05:48.031Z | 2024-11-01T12:26:42.656Z |
5358174 | 5358174 | 20241023110759_WzOU4 | NZ002N | 2024-10-25T12:05:34.191Z | 2024-11-01T12:26:42.174Z |
5358035 | 5358035 | 20241023104811_lMylN | NZ002N | 2024-10-25T12:05:04.927Z | 2024-11-01T12:26:41.855Z |
5357816 | 5357816 | 20241023101756_hrI8Y | NZ002N | 2024-10-25T12:04:36.149Z | 2024-11-01T12:26:41.389Z |
5357780 | 5357780 | 20241023101301_pkuc4 | NZ002N | 2024-10-25T12:04:28.053Z | 2024-11-01T12:26:41.164Z |
5357771 | 5357771 | 20241023101108_uWWoR | NZ002N | 2024-10-25T12:04:26.961Z | 2024-11-01T12:26:41.160Z |
5357716 | 5357716 | 20241023100434_zt3e4 | NZ002N | 2024-10-25T12:04:19.650Z | 2024-11-01T12:26:41.036Z |
5357648 | 5357648 | 20241023095443_dUWob | NZ002N | 2024-10-25T12:04:11.087Z | 2024-11-01T12:26:40.897Z |
5357453 | 5357453 | 20241023093429_23Kvf | NZ002N | 2024-10-25T12:03:35.034Z | 2024-11-01T12:26:40.301Z |
5357334 | 5357334 | 20241023092024_grI1Q | NZ002N | 2024-10-25T12:03:20.749Z | 2024-11-01T12:26:39.780Z |
5357293 | 5357293 | 20241023091136_bRsPG | NZ002N | 2024-10-25T12:03:15.004Z | 2024-11-01T12:26:39.440Z |
5357209 | 5357209 | 20241023085901_FqaKA | NZ002N | 2024-10-25T12:02:57.022Z | 2024-11-01T12:26:39.248Z |
5357123 | 5357123 | 20241023084332_D7mUp | NZ002N | 2024-10-25T12:02:41.687Z | 2024-11-01T12:26:38.741Z |
5356867 | 5356867 | 20241023080833_SSzNx | NZ002N | 2024-10-25T12:01:55.831Z | 2024-11-01T12:26:37.385Z |
5347466 | 5347466 | 20241022152056_1aswg | NZ002N | 2024-10-24T12:08:13.987Z | 2024-10-31T12:29:50.524Z |
5347383 | 5347383 | 20241022150546_TRptg | NZ002N | 2024-10-24T12:07:51.765Z | 2024-10-31T12:29:50.415Z |
5347292 | 5347292 | 20241022145238_GLXZd | NZ002N | 2024-10-24T12:07:24.967Z | 2024-10-31T12:29:50.265Z |
5347211 | 5347211 | 20241022143632_iMDxm | NZ002N | 2024-10-24T12:07:13.813Z | 2024-10-31T12:29:49.528Z |
5347171 | 5347171 | 20241022142920_PrvGA | NZ002N | 2024-10-24T12:07:09.189Z | 2024-10-31T12:29:49.382Z |
5347011 | 5347011 | 20241022135434_DTQdp | NZ002N | 2024-10-24T12:06:34.631Z | 2024-10-31T12:29:48.961Z |
5346895 | 5346895 | 20241022131835_SOFMg | NZ002N | 2024-10-24T12:06:15.411Z | 2024-10-31T12:29:48.238Z |
5346869 | 5346869 | 20241022131348_5JM0q | NZ002N | 2024-10-24T12:06:09.571Z | 2024-10-31T12:29:48.174Z |
5346847 | 5346847 | 20241022130747_R5d4c | NZ002N | 2024-10-24T12:06:03.862Z | 2024-10-31T12:29:48.122Z |
5346787 | 5346787 | 20241022124651_XyLYw | NZ002N | 2024-10-24T12:05:44.139Z | 2024-10-31T12:29:47.968Z |
5346713 | 5346713 | 20241022123119_bF7nc | NZ002N | 2024-10-24T12:05:32.185Z | 2024-10-31T12:29:47.756Z |
5346705 | 5346705 | 20241022122926_dlhql | NZ002N | 2024-10-24T12:05:31.016Z | 2024-10-31T12:29:47.749Z |
5346593 | 5346593 | 20241022121443_CxMn8 | NZ002N | 2024-10-24T12:05:12.446Z | 2024-10-31T12:29:47.414Z |
5346489 | 5346489 | 20241022120707_IRM12 | NZ002N | 2024-10-24T12:04:50.540Z | 2024-10-31T12:29:47.074Z |
5346350 | 5346350 | 20241022115259_utQ3D | NZ002N | 2024-10-24T12:04:32.244Z | 2024-10-31T12:29:46.846Z |
5345921 | 5345921 | 20241022110853_M7Myh | NZ002N | 2024-10-24T12:03:08.983Z | 2024-10-31T12:29:45.632Z |
5345784 | 5345784 | 20241022105305_wqaPe | NZ002N | 2024-10-24T12:02:51.368Z | 2024-10-31T12:29:45.316Z |
5337599 | 5337599 | 20241022101741_Wvbe0 | NZ002N | 2024-10-23T12:05:25.031Z | 2024-10-31T12:29:44.754Z |
5337460 | 5337460 | 20241022100154_Ipw9f | NZ002N | 2024-10-23T12:04:59.197Z | 2024-10-31T12:29:44.481Z |
5337197 | 5337197 | 20241022094146_ydtPB | NZ002N | 2024-10-23T12:04:30.517Z | 2024-10-31T12:29:43.790Z |
5337155 | 5337155 | 20241022093629_R50a3 | NZ002N | 2024-10-23T12:04:26.093Z | 2024-10-31T12:29:43.689Z |
5336864 | 5336864 | 20241022090756_DLYJy | NZ002N | 2024-10-23T12:03:39.740Z | 2024-10-31T12:29:42.695Z |
5336674 | 5336674 | 20241022084643_JR7p3 | NZ002N | 2024-10-23T12:03:01.043Z | 2024-10-31T12:29:41.801Z |
5336358 | 5336358 | 20241022081407_g7lUq | NZ002N | 2024-10-23T12:02:12.474Z | 2024-10-31T12:29:39.810Z |
5336329 | 5336329 | 20241022081207_wlMtu | NZ002N | 2024-10-23T12:02:09.596Z | 2024-10-31T12:29:39.730Z |
5336132 | 5336132 | 20241022074216_rNEa8 | NZ002N | 2024-10-23T12:01:32.791Z | 2024-10-31T12:29:39.132Z |
5336108 | 5336108 | 20241022074028_rlQPN | NZ002N | 2024-10-23T12:01:29.213Z | 2024-10-31T12:29:39.041Z |
5331892 | 5331892 | 20241021153854_OlpNg | NZ002N | 2024-10-22T12:09:53.928Z | 2024-10-30T12:26:40.106Z |
5331788 | 5331788 | 20241021152613_bRH92 | NZ002N | 2024-10-22T12:09:44.315Z | 2024-10-30T12:26:40.030Z |
5331660 | 5331660 | 20241021150926_EeGho | NZ002N | 2024-10-22T12:09:25.721Z | 2024-10-30T12:26:39.873Z |
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);