participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,931 rows where station_code = "NZ004E" 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 |
---|---|---|---|---|---|
5560674 | 5560674 | 20241120135128_MvJOY | NZ004E | 2024-11-21T14:09:24.243Z | 2024-11-22T14:19:21.710Z |
5560453 | 5560453 | 20241120125320_q93QS | NZ004E | 2024-11-21T14:08:53.524Z | 2024-11-22T14:19:21.662Z |
5560291 | 5560291 | 20241120123011_Lu6mk | NZ004E | 2024-11-21T14:08:32.016Z | 2024-11-22T14:19:21.629Z |
5559841 | 5559841 | 20241120112301_zyiMG | NZ004E | 2024-11-21T14:07:18.700Z | 2024-11-22T14:19:21.534Z |
5559826 | 5559826 | 20241120112200_d5g1h | NZ004E | 2024-11-21T14:07:16.881Z | 2024-11-22T14:19:21.532Z |
5559278 | 5559278 | 20241120095423_vD22c | NZ004E | 2024-11-21T14:05:48.475Z | 2024-11-22T14:19:21.404Z |
5559043 | 5559043 | 20241120090746_M2P84 | NZ004E | 2024-11-21T14:05:08.270Z | 2024-11-22T14:19:21.352Z |
5555742 | 5555742 | 20241119152309_PurUp | NZ004E | 2024-11-20T14:06:31.055Z | 2024-11-22T14:20:13.300Z |
5555732 | 5555732 | 20241119151727_VVLNH | NZ004E | 2024-11-20T14:06:29.985Z | 2024-11-22T14:20:13.247Z |
5555721 | 5555721 | 20241119150104_wSYUx | NZ004E | 2024-11-20T14:06:28.554Z | 2024-11-22T14:20:12.876Z |
5555674 | 5555674 | 20241119143307_vPBwG | NZ004E | 2024-11-20T14:06:22.927Z | 2024-11-22T14:20:12.206Z |
5555631 | 5555631 | 20241119141155_4iaMJ | NZ004E | 2024-11-20T14:06:10.539Z | 2024-11-22T14:20:11.327Z |
5555621 | 5555621 | 20241119140902_6lt0Q | NZ004E | 2024-11-20T14:06:08.811Z | 2024-11-22T14:20:10.999Z |
5555608 | 5555608 | 20241119140505_8FTr2 | NZ004E | 2024-11-20T14:06:05.828Z | 2024-11-22T14:20:10.833Z |
5555605 | 5555605 | 20241119140341_vYooS | NZ004E | 2024-11-20T14:06:05.093Z | 2024-11-22T14:20:10.767Z |
5555517 | 5555517 | 20241119134024_2VUSO | NZ004E | 2024-11-20T14:05:54.532Z | 2024-11-22T14:20:08.966Z |
5555501 | 5555501 | 20241119133504_bLIRR | NZ004E | 2024-11-20T14:05:52.028Z | 2024-11-22T14:20:07.625Z |
5555407 | 5555407 | 20241119130451_vr3LW | NZ004E | 2024-11-20T14:05:32.057Z | 2024-11-22T14:20:05.510Z |
5555389 | 5555389 | 20241119130228_T76o6 | NZ004E | 2024-11-20T14:05:25.188Z | 2024-11-22T14:20:05.027Z |
5551734 | 5551734 | 20241118145835_nY4To | NZ004E | 2024-11-19T14:05:22.058Z | 2024-11-22T14:22:12.329Z |
5551525 | 5551525 | 20241118140721_Fr2vV | NZ004E | 2024-11-19T14:04:56.716Z | 2024-11-22T14:22:11.242Z |
5551498 | 5551498 | 20241118135805_fQLSu | NZ004E | 2024-11-19T14:04:53.837Z | 2024-11-22T14:22:11.038Z |
5551188 | 5551188 | 20241118124212_iK1k2 | NZ004E | 2024-11-19T14:04:04.936Z | 2024-11-22T14:22:09.019Z |
5550949 | 5550949 | 20241118115940_HgTxW | NZ004E | 2024-11-19T14:03:34.481Z | 2024-11-22T14:22:07.042Z |
5550905 | 5550905 | 20241118114710_p1EaY | NZ004E | 2024-11-19T14:03:23.506Z | 2024-11-22T14:22:06.699Z |
5550825 | 5550825 | 20241118113210_QA9Ym | NZ004E | 2024-11-19T14:03:10.121Z | 2024-11-22T14:22:05.949Z |
5550548 | 5550548 | 20241118104414_2DXHa | NZ004E | 2024-11-19T14:02:33.613Z | 2024-11-22T14:22:03.832Z |
5550422 | 5550422 | 20241118101818_F38mG | NZ004E | 2024-11-19T14:02:18.946Z | 2024-11-22T14:22:02.820Z |
5550292 | 5550292 | 20241118100018_U20N0 | NZ004E | 2024-11-19T14:02:05.686Z | 2024-11-22T14:22:00.855Z |
5547305 | 5547305 | 20241117153406_4HgMt | NZ004E | 2024-11-18T14:05:26.982Z | 2024-11-22T14:22:38.899Z |
5547276 | 5547276 | 20241117152439_FBbjL | NZ004E | 2024-11-18T14:05:24.468Z | 2024-11-22T14:22:38.310Z |
5547141 | 5547141 | 20241117145842_EoWLd | NZ004E | 2024-11-18T14:05:10.231Z | 2024-11-22T14:22:37.607Z |
5547044 | 5547044 | 20241117142724_jhWJH | NZ004E | 2024-11-18T14:04:46.584Z | 2024-11-22T14:22:36.563Z |
5546997 | 5546997 | 20241117140631_oCPmx | NZ004E | 2024-11-18T14:04:40.789Z | 2024-11-22T14:22:36.294Z |
5546872 | 5546872 | 20241117130912_NM2XL | NZ004E | 2024-11-18T14:04:23.056Z | 2024-11-22T14:22:35.231Z |
5546825 | 5546825 | 20241117125104_Ac25m | NZ004E | 2024-11-18T14:04:17.513Z | 2024-11-22T14:22:34.793Z |
5546573 | 5546573 | 20241117114322_eMHUS | NZ004E | 2024-11-18T14:03:32.295Z | 2024-11-22T14:22:33.090Z |
5546308 | 5546308 | 20241117101857_7u8xB | NZ004E | 2024-11-18T14:02:47.501Z | 2024-11-22T14:22:31.003Z |
5546212 | 5546212 | 20241117094802_kJdtR | NZ004E | 2024-11-18T14:02:28.078Z | 2024-11-22T14:22:30.113Z |
5546038 | 5546038 | 20241117085549_d05P9 | NZ004E | 2024-11-18T14:01:47.767Z | 2024-11-22T14:22:28.306Z |
5544774 | 5544774 | 20241116151501_hM9Ov | NZ004E | 2024-11-17T14:02:03.694Z | 2024-11-22T14:23:06.225Z |
5544689 | 5544689 | 20241116142318_8Gcbq | NZ004E | 2024-11-17T14:01:51.502Z | 2024-11-22T14:23:05.562Z |
5536110 | 5536110 | 20241112154115_sjuLs | NZ004E | 2024-11-14T14:09:12.055Z | 2024-11-21T14:25:56.725Z |
5535987 | 5535987 | 20241112151150_p2Of2 | NZ004E | 2024-11-14T14:09:04.398Z | 2024-11-21T14:25:55.968Z |
5535976 | 5535976 | 20241112150845_1A9xS | NZ004E | 2024-11-14T14:09:03.504Z | 2024-11-21T14:25:55.685Z |
5535870 | 5535870 | 20241112143853_b1Ne0 | NZ004E | 2024-11-14T14:08:56.043Z | 2024-11-21T14:25:53.981Z |
5535864 | 5535864 | 20241112143826_l7Lbh | NZ004E | 2024-11-14T14:08:55.482Z | 2024-11-21T14:25:53.910Z |
5535859 | 5535859 | 20241112143753_yYlbJ | NZ004E | 2024-11-14T14:08:55.139Z | 2024-11-21T14:25:53.881Z |
5535819 | 5535819 | 20241112143053_INcD0 | NZ004E | 2024-11-14T14:08:52.070Z | 2024-11-21T14:25:53.574Z |
5535768 | 5535768 | 20241112141452_YwZUf | NZ004E | 2024-11-14T14:08:47.945Z | 2024-11-21T14:25:52.911Z |
5520423 | 5520423 | 20241111154527_Loemj | NZ004E | 2024-11-12T14:06:18.402Z | 2024-11-20T14:25:08.668Z |
5520247 | 5520247 | 20241111150240_AppnC | NZ004E | 2024-11-12T14:06:01.526Z | 2024-11-20T14:25:06.305Z |
5520206 | 5520206 | 20241111145800_C2v7B | NZ004E | 2024-11-12T14:05:57.678Z | 2024-11-20T14:25:05.804Z |
5520180 | 5520180 | 20241111145428_4V3wi | NZ004E | 2024-11-12T14:05:51.005Z | 2024-11-20T14:25:05.466Z |
5520075 | 5520075 | 20241111143127_OzQX3 | NZ004E | 2024-11-12T14:05:33.597Z | 2024-11-20T14:25:03.078Z |
5520051 | 5520051 | 20241111142628_ybrGr | NZ004E | 2024-11-12T14:05:31.026Z | 2024-11-20T14:25:02.664Z |
5519974 | 5519974 | 20241111140720_SeewJ | NZ004E | 2024-11-12T14:05:24.450Z | 2024-11-20T14:25:01.316Z |
5519932 | 5519932 | 20241111135746_2EKm2 | NZ004E | 2024-11-12T14:05:20.485Z | 2024-11-20T14:25:00.893Z |
5519823 | 5519823 | 20241111131434_a3oEW | NZ004E | 2024-11-12T14:05:05.849Z | 2024-11-20T14:24:58.336Z |
5514384 | 5514384 | 20241110154058_zGDoy | NZ004E | 2024-11-11T14:06:33.943Z | 2024-11-19T14:21:46.981Z |
5514362 | 5514362 | 20241110153817_h25DV | NZ004E | 2024-11-11T14:06:32.679Z | 2024-11-19T14:21:46.740Z |
5514303 | 5514303 | 20241110152739_Wq13W | NZ004E | 2024-11-11T14:06:27.061Z | 2024-11-19T14:21:46.012Z |
5514249 | 5514249 | 20241110151826_HYzt2 | NZ004E | 2024-11-11T14:06:23.700Z | 2024-11-19T14:21:45.391Z |
5514073 | 5514073 | 20241110141241_yjPNX | NZ004E | 2024-11-11T14:06:00.857Z | 2024-11-19T14:21:43.003Z |
5514071 | 5514071 | 20241110141100_4Ck3R | NZ004E | 2024-11-11T14:06:00.669Z | 2024-11-19T14:21:42.957Z |
5514057 | 5514057 | 20241110140057_O37Tq | NZ004E | 2024-11-11T14:05:58.174Z | 2024-11-19T14:21:42.819Z |
5514038 | 5514038 | 20241110135335_SOvRM | NZ004E | 2024-11-11T14:05:53.046Z | 2024-11-19T14:21:42.337Z |
5514025 | 5514025 | 20241110134601_lgZB6 | NZ004E | 2024-11-11T14:05:49.819Z | 2024-11-19T14:21:41.926Z |
5514003 | 5514003 | 20241110133251_1ohVP | NZ004E | 2024-11-11T14:05:47.068Z | 2024-11-19T14:21:41.629Z |
5514001 | 5514001 | 20241110132806_l2d0t | NZ004E | 2024-11-11T14:05:46.864Z | 2024-11-19T14:21:41.472Z |
5513091 | 5513091 | 20241110103701_NEm1B | NZ004E | 2024-11-11T14:03:52.502Z | 2024-11-19T14:21:31.145Z |
5498710 | 5498710 | 20241108094023_KOprP | NZ004E | 2024-11-09T14:02:14.534Z | 2024-11-17T14:22:59.268Z |
5493956 | 5493956 | 20241107144806_foIcm | NZ004E | 2024-11-08T14:05:03.569Z | 2024-11-16T14:27:43.619Z |
5493791 | 5493791 | 20241107134740_jQRxL | NZ004E | 2024-11-08T14:04:39.326Z | 2024-11-16T14:27:41.181Z |
5493639 | 5493639 | 20241107125124_mZOvf | NZ004E | 2024-11-08T14:04:24.686Z | 2024-11-16T14:27:37.832Z |
5493576 | 5493576 | 20241107123858_leMvU | NZ004E | 2024-11-08T14:04:08.990Z | 2024-11-16T14:27:36.295Z |
5493531 | 5493531 | 20241107122650_qziM3 | NZ004E | 2024-11-08T14:03:59.362Z | 2024-11-16T14:27:35.497Z |
5493503 | 5493503 | 20241107122302_uh70z | NZ004E | 2024-11-08T14:03:53.596Z | 2024-11-16T14:27:35.054Z |
5493439 | 5493439 | 20241107121143_YI8zH | NZ004E | 2024-11-08T14:03:45.712Z | 2024-11-16T14:27:34.305Z |
5493191 | 5493191 | 20241107111531_tr1b2 | NZ004E | 2024-11-08T14:03:05.294Z | 2024-11-16T14:27:32.875Z |
5492909 | 5492909 | 20241107101856_z21jn | NZ004E | 2024-11-08T14:02:31.759Z | 2024-11-16T14:27:30.469Z |
5492661 | 5492661 | 20241107092558_5HZsz | NZ004E | 2024-11-08T14:01:48.592Z | 2024-11-16T14:27:27.265Z |
5492575 | 5492575 | 20241107090748_BmotK | NZ004E | 2024-11-08T14:01:29.135Z | 2024-11-16T14:27:26.887Z |
5487176 | 5487176 | 20241106150353_4TFqw | NZ004E | 2024-11-07T14:05:06.373Z | 2024-11-15T14:24:37.952Z |
5480753 | 5480753 | 20241105152401_GclfR | NZ004E | 2024-11-06T14:06:29.282Z | 2024-11-14T14:23:06.345Z |
5474071 | 5474071 | 20241103154804_TFrTB | NZ004E | 2024-11-05T14:10:06.195Z | 2024-11-12T14:27:50.498Z |
5473728 | 5473728 | 20241103145521_7Oh3W | NZ004E | 2024-11-05T14:09:35.541Z | 2024-11-12T14:27:49.982Z |
5473715 | 5473715 | 20241103145313_bpT4B | NZ004E | 2024-11-05T14:09:30.731Z | 2024-11-12T14:27:49.960Z |
5473376 | 5473376 | 20241103140629_w7hDS | NZ004E | 2024-11-05T14:08:51.718Z | 2024-11-12T14:27:48.740Z |
5473259 | 5473259 | 20241103135015_MGtDn | NZ004E | 2024-11-05T14:08:42.745Z | 2024-11-12T14:27:48.293Z |
5473203 | 5473203 | 20241103134038_x0319 | NZ004E | 2024-11-05T14:08:33.574Z | 2024-11-12T14:27:48.218Z |
5473171 | 5473171 | 20241103133648_fYW8X | NZ004E | 2024-11-05T14:08:27.730Z | 2024-11-12T14:27:48.128Z |
5472986 | 5472986 | 20241103131023_Q0LXK | NZ004E | 2024-11-05T14:07:58.896Z | 2024-11-12T14:27:47.548Z |
5472888 | 5472888 | 20241103125611_xXPLw | NZ004E | 2024-11-05T14:07:49.831Z | 2024-11-12T14:27:46.862Z |
5465418 | 5465418 | 20241103115239_jljM3 | NZ004E | 2024-11-04T14:03:40.907Z | 2024-11-12T14:27:46.200Z |
5465347 | 5465347 | 20241103113159_YixNK | NZ004E | 2024-11-04T14:03:32.417Z | 2024-11-12T14:27:46.092Z |
5465094 | 5465094 | 20241103103736_A2jAx | NZ004E | 2024-11-04T14:02:44.266Z | 2024-11-12T14:27:44.446Z |
5465070 | 5465070 | 20241103103407_yCZO9 | NZ004E | 2024-11-04T14:02:37.833Z | 2024-11-12T14:27:44.366Z |
5465027 | 5465027 | 20241103102447_5quSd | NZ004E | 2024-11-04T14:02:30.624Z | 2024-11-12T14:27:44.298Z |
5464764 | 5464764 | 20241103090735_Sgb8Z | NZ004E | 2024-11-04T14:01:36.442Z | 2024-11-12T14:27:43.184Z |
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);