participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,409 rows where station_code = "NZ003K" 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 |
---|---|---|---|---|---|
5568627 | 5568627 | 20241121131424_KIqUZ | NZ003K | 2024-11-22T14:09:27.032Z | 2024-11-22T14:09:27.032Z |
5568573 | 5568573 | 20241121130520_D8SE6 | NZ003K | 2024-11-22T14:09:22.325Z | 2024-11-22T14:09:22.325Z |
5568567 | 5568567 | 20241121130430_JTm33 | NZ003K | 2024-11-22T14:09:21.709Z | 2024-11-22T14:09:21.709Z |
5568563 | 5568563 | 20241121130055_g6Qr3 | NZ003K | 2024-11-22T14:09:21.043Z | 2024-11-22T14:09:21.043Z |
5568530 | 5568530 | 20241121125558_I7UL7 | NZ003K | 2024-11-22T14:09:16.976Z | 2024-11-22T14:09:16.976Z |
5568505 | 5568505 | 20241121125330_OUoa2 | NZ003K | 2024-11-22T14:09:08.195Z | 2024-11-22T14:09:08.195Z |
5568468 | 5568468 | 20241121125023_6J7fs | NZ003K | 2024-11-22T14:09:01.075Z | 2024-11-22T14:09:01.075Z |
5568446 | 5568446 | 20241121124841_NLOpd | NZ003K | 2024-11-22T14:08:58.597Z | 2024-11-22T14:08:58.597Z |
5568406 | 5568406 | 20241121124238_PZqeK | NZ003K | 2024-11-22T14:08:52.606Z | 2024-11-22T14:08:52.606Z |
5568232 | 5568232 | 20241121121157_P6qtP | NZ003K | 2024-11-22T14:08:33.473Z | 2024-11-22T14:08:33.473Z |
5568178 | 5568178 | 20241121120204_bkdZF | NZ003K | 2024-11-22T14:08:18.989Z | 2024-11-22T14:08:18.989Z |
5567953 | 5567953 | 20241121113541_pJ4Vl | NZ003K | 2024-11-22T14:07:51.136Z | 2024-11-22T14:07:51.136Z |
5567916 | 5567916 | 20241121113047_CRAES | NZ003K | 2024-11-22T14:07:39.828Z | 2024-11-22T14:07:39.828Z |
5567843 | 5567843 | 20241121111845_sbBgf | NZ003K | 2024-11-22T14:07:22.981Z | 2024-11-22T14:07:22.981Z |
5567726 | 5567726 | 20241121105746_HJRRk | NZ003K | 2024-11-22T14:07:08.728Z | 2024-11-22T14:07:08.728Z |
5567706 | 5567706 | 20241121105424_Blyfq | NZ003K | 2024-11-22T14:07:05.226Z | 2024-11-22T14:07:05.226Z |
5567681 | 5567681 | 20241121105208_LQtph | NZ003K | 2024-11-22T14:06:53.123Z | 2024-11-22T14:06:53.123Z |
5567649 | 5567649 | 20241121104818_4mxgn | NZ003K | 2024-11-22T14:06:44.535Z | 2024-11-22T14:06:44.535Z |
5567546 | 5567546 | 20241121103316_kgLJe | NZ003K | 2024-11-22T14:06:29.351Z | 2024-11-22T14:06:29.351Z |
5567440 | 5567440 | 20241121101855_KRb6V | NZ003K | 2024-11-22T14:06:16.836Z | 2024-11-22T14:06:16.836Z |
5567395 | 5567395 | 20241121101033_6aOQV | NZ003K | 2024-11-22T14:06:05.640Z | 2024-11-22T14:06:05.640Z |
5559952 | 5559952 | 20241120113820_s9e1D | NZ003K | 2024-11-21T14:07:40.333Z | 2024-11-22T14:19:21.555Z |
5559805 | 5559805 | 20241120111930_WvFEX | NZ003K | 2024-11-21T14:07:13.273Z | 2024-11-22T14:19:21.528Z |
5555038 | 5555038 | 20241119112444_eBzNW | NZ003K | 2024-11-20T14:04:11.247Z | 2024-11-22T14:19:55.841Z |
5551595 | 5551595 | 20241118142311_sQef2 | NZ003K | 2024-11-19T14:05:03.360Z | 2024-11-22T14:22:11.587Z |
5551461 | 5551461 | 20241118134343_PFU27 | NZ003K | 2024-11-19T14:04:49.464Z | 2024-11-22T14:22:10.818Z |
5551344 | 5551344 | 20241118131009_2604j | NZ003K | 2024-11-19T14:04:32.033Z | 2024-11-22T14:22:10.277Z |
5550772 | 5550772 | 20241118112327_hsgPS | NZ003K | 2024-11-19T14:03:04.111Z | 2024-11-22T14:22:05.509Z |
5550605 | 5550605 | 20241118105500_h76kr | NZ003K | 2024-11-19T14:02:47.271Z | 2024-11-22T14:22:04.295Z |
5550242 | 5550242 | 20241118095126_pzzSQ | NZ003K | 2024-11-19T14:01:54.675Z | 2024-11-22T14:22:00.290Z |
5550218 | 5550218 | 20241118094833_HHffA | NZ003K | 2024-11-19T14:01:47.133Z | 2024-11-22T14:21:59.899Z |
5550140 | 5550140 | 20241118093722_Z9gY2 | NZ003K | 2024-11-19T14:01:37.613Z | 2024-11-22T14:21:58.785Z |
5550085 | 5550085 | 20241118092906_o3Mhp | NZ003K | 2024-11-19T14:01:33.449Z | 2024-11-22T14:21:57.900Z |
5549942 | 5549942 | 20241118085327_Vwbtl | NZ003K | 2024-11-19T14:01:20.232Z | 2024-11-22T14:21:55.574Z |
5547246 | 5547246 | 20241117151440_KxLxN | NZ003K | 2024-11-18T14:05:21.049Z | 2024-11-22T14:22:38.195Z |
5547219 | 5547219 | 20241117150830_HdJon | NZ003K | 2024-11-18T14:05:17.820Z | 2024-11-22T14:22:38.045Z |
5547184 | 5547184 | 20241117150404_3R5pe | NZ003K | 2024-11-18T14:05:14.387Z | 2024-11-22T14:22:37.888Z |
5547090 | 5547090 | 20241117144019_JdCFT | NZ003K | 2024-11-18T14:04:56.908Z | 2024-11-22T14:22:36.811Z |
5547065 | 5547065 | 20241117143101_eJlPo | NZ003K | 2024-11-18T14:04:53.138Z | 2024-11-22T14:22:36.625Z |
5546659 | 5546659 | 20241117120641_0bqI2 | NZ003K | 2024-11-18T14:03:44.925Z | 2024-11-22T14:22:33.655Z |
5546642 | 5546642 | 20241117120132_HxnDn | NZ003K | 2024-11-18T14:03:42.978Z | 2024-11-22T14:22:33.628Z |
5546622 | 5546622 | 20241117115840_vn6Kj | NZ003K | 2024-11-18T14:03:40.334Z | 2024-11-22T14:22:33.447Z |
5546607 | 5546607 | 20241117115257_HXFFC | NZ003K | 2024-11-18T14:03:38.387Z | 2024-11-22T14:22:33.355Z |
5546556 | 5546556 | 20241117113550_h2mFM | NZ003K | 2024-11-18T14:03:29.441Z | 2024-11-22T14:22:32.622Z |
5546484 | 5546484 | 20241117110927_ETl1r | NZ003K | 2024-11-18T14:03:12.610Z | 2024-11-22T14:22:32.237Z |
5546199 | 5546199 | 20241117094133_EbgTr | NZ003K | 2024-11-18T14:02:26.165Z | 2024-11-22T14:22:29.991Z |
5546030 | 5546030 | 20241117085436_szIza | NZ003K | 2024-11-18T14:01:46.175Z | 2024-11-22T14:22:28.208Z |
5544927 | 5544927 | 20241115151823_HnAhj | NZ003K | 2024-11-17T14:03:15.895Z | 2024-11-22T14:23:32.247Z |
5542884 | 5542884 | 20241115153422_iE8rY | NZ003K | 2024-11-16T14:02:54.346Z | 2024-11-22T14:23:32.289Z |
5542876 | 5542876 | 20241115152055_e3WNl | NZ003K | 2024-11-16T14:02:53.118Z | 2024-11-22T14:23:32.249Z |
5542852 | 5542852 | 20241115144613_i39jh | NZ003K | 2024-11-16T14:02:46.563Z | 2024-11-22T14:23:31.854Z |
5542849 | 5542849 | 20241115143244_jMBUy | NZ003K | 2024-11-16T14:02:45.805Z | 2024-11-22T14:23:31.792Z |
5536074 | 5536074 | 20241112153351_sjU4X | NZ003K | 2024-11-14T14:09:10.337Z | 2024-11-21T14:25:56.475Z |
5536039 | 5536039 | 20241112152819_V3A66 | NZ003K | 2024-11-14T14:09:08.079Z | 2024-11-21T14:25:56.343Z |
5535997 | 5535997 | 20241112151514_R6KHi | NZ003K | 2024-11-14T14:09:05.295Z | 2024-11-21T14:25:56.049Z |
5535461 | 5535461 | 20241112123310_dzbfe | NZ003K | 2024-11-14T14:07:58.099Z | 2024-11-21T14:25:48.538Z |
5535093 | 5535093 | 20241112113606_RYipF | NZ003K | 2024-11-14T14:07:13.330Z | 2024-11-21T14:25:43.848Z |
5532735 | 5532735 | 20241110090441_BGJo6 | NZ003K | 2024-11-13T14:18:03.836Z | 2024-11-19T14:21:26.050Z |
5512539 | 5512539 | 20241110090441_x2z7j | NZ003K | 2024-11-11T14:02:34.965Z | 2024-11-12T14:18:06.114Z |
5500499 | 5500499 | 20241108155131_Y2h3X | NZ003K | 2024-11-09T14:06:22.251Z | 2024-11-17T14:23:22.991Z |
5500437 | 5500437 | 20241108154242_F38TE | NZ003K | 2024-11-09T14:06:16.994Z | 2024-11-17T14:23:22.695Z |
5500425 | 5500425 | 20241108154059_CV6Np | NZ003K | 2024-11-09T14:06:15.811Z | 2024-11-17T14:23:22.546Z |
5500391 | 5500391 | 20241108153334_tT34n | NZ003K | 2024-11-09T14:06:12.548Z | 2024-11-17T14:23:22.409Z |
5500206 | 5500206 | 20241108150434_halM0 | NZ003K | 2024-11-09T14:05:58.621Z | 2024-11-17T14:23:20.127Z |
5500197 | 5500197 | 20241108150250_5mQQJ | NZ003K | 2024-11-09T14:05:58.088Z | 2024-11-17T14:23:20.057Z |
5500155 | 5500155 | 20241108145859_6QsMp | NZ003K | 2024-11-09T14:05:55.641Z | 2024-11-17T14:23:19.870Z |
5500108 | 5500108 | 20241108144626_fV1ut | NZ003K | 2024-11-09T14:05:42.178Z | 2024-11-17T14:23:19.073Z |
5500096 | 5500096 | 20241108144426_zh3E3 | NZ003K | 2024-11-09T14:05:40.891Z | 2024-11-17T14:23:18.882Z |
5499998 | 5499998 | 20241108142115_b3FiQ | NZ003K | 2024-11-09T14:05:28.362Z | 2024-11-17T14:23:17.917Z |
5499975 | 5499975 | 20241108141637_daOES | NZ003K | 2024-11-09T14:05:25.465Z | 2024-11-17T14:23:17.833Z |
5499971 | 5499971 | 20241108141635_yI5IJ | NZ003K | 2024-11-09T14:05:24.939Z | 2024-11-17T14:23:17.725Z |
5499870 | 5499870 | 20241108135142_W4mcB | NZ003K | 2024-11-09T14:05:05.239Z | 2024-11-17T14:23:16.555Z |
5499859 | 5499859 | 20241108134902_cPoXj | NZ003K | 2024-11-09T14:05:04.162Z | 2024-11-17T14:23:16.474Z |
5499791 | 5499791 | 20241108132853_IKPCb | NZ003K | 2024-11-09T14:04:58.200Z | 2024-11-17T14:23:16.145Z |
5499697 | 5499697 | 20241108130247_HElup | NZ003K | 2024-11-09T14:04:46.212Z | 2024-11-17T14:23:14.548Z |
5499686 | 5499686 | 20241108125806_285jG | NZ003K | 2024-11-09T14:04:44.154Z | 2024-11-17T14:23:14.458Z |
5499677 | 5499677 | 20241108125543_WwEaZ | NZ003K | 2024-11-09T14:04:43.218Z | 2024-11-17T14:23:14.392Z |
5499635 | 5499635 | 20241108124722_cXWYf | NZ003K | 2024-11-09T14:04:30.193Z | 2024-11-17T14:23:14.005Z |
5499616 | 5499616 | 20241108124510_XyoI5 | NZ003K | 2024-11-09T14:04:26.991Z | 2024-11-17T14:23:13.760Z |
5499573 | 5499573 | 20241108123901_4KHH3 | NZ003K | 2024-11-09T14:04:21.504Z | 2024-11-17T14:23:13.290Z |
5499568 | 5499568 | 20241108123755_iIlB3 | NZ003K | 2024-11-09T14:04:20.659Z | 2024-11-17T14:23:13.261Z |
5499533 | 5499533 | 20241108123317_d7cDm | NZ003K | 2024-11-09T14:04:16.534Z | 2024-11-17T14:23:12.715Z |
5499497 | 5499497 | 20241108122751_a4VOz | NZ003K | 2024-11-09T14:04:12.693Z | 2024-11-17T14:23:12.142Z |
5499473 | 5499473 | 20241108122619_UrNIm | NZ003K | 2024-11-09T14:04:10.234Z | 2024-11-17T14:23:11.866Z |
5499388 | 5499388 | 20241108121022_fffNR | NZ003K | 2024-11-09T14:03:58.467Z | 2024-11-17T14:23:10.795Z |
5499374 | 5499374 | 20241108120619_02aKc | NZ003K | 2024-11-09T14:03:53.209Z | 2024-11-17T14:23:10.567Z |
5499166 | 5499166 | 20241108112116_2tXMS | NZ003K | 2024-11-09T14:03:28.087Z | 2024-11-17T14:23:07.394Z |
5499065 | 5499065 | 20241108105722_AT1ql | NZ003K | 2024-11-09T14:03:05.040Z | 2024-11-17T14:23:04.749Z |
5498741 | 5498741 | 20241108094743_MLUCd | NZ003K | 2024-11-09T14:02:18.432Z | 2024-11-17T14:22:59.467Z |
5498624 | 5498624 | 20241108092255_Ebftq | NZ003K | 2024-11-09T14:01:58.681Z | 2024-11-17T14:22:58.428Z |
5494108 | 5494108 | 20241107153815_vmJ5U | NZ003K | 2024-11-08T14:05:23.235Z | 2024-11-16T14:27:47.719Z |
5494104 | 5494104 | 20241107153547_vzA1h | NZ003K | 2024-11-08T14:05:23.003Z | 2024-11-16T14:27:47.691Z |
5494053 | 5494053 | 20241107152304_8ggb4 | NZ003K | 2024-11-08T14:05:18.162Z | 2024-11-16T14:27:45.685Z |
5494021 | 5494021 | 20241107151306_36aIz | NZ003K | 2024-11-08T14:05:16.026Z | 2024-11-16T14:27:45.291Z |
5493982 | 5493982 | 20241107150033_zRw76 | NZ003K | 2024-11-08T14:05:10.944Z | 2024-11-16T14:27:44.159Z |
5492658 | 5492658 | 20241107092537_31zEy | NZ003K | 2024-11-08T14:01:46.826Z | 2024-11-16T14:27:27.245Z |
5492514 | 5492514 | 20241107084652_g2v0w | NZ003K | 2024-11-08T14:01:19.490Z | 2024-11-16T14:27:26.201Z |
5492418 | 5492418 | 20241107083113_jd9Dk | NZ003K | 2024-11-08T14:01:02.276Z | 2024-11-16T14:27:25.000Z |
5479257 | 5479257 | 20241105084732_thcgu | NZ003K | 2024-11-06T14:01:37.857Z | 2024-11-14T14:22:58.144Z |
5479067 | 5479067 | 20241105075015_uK3md | NZ003K | 2024-11-06T14:00:54.029Z | 2024-11-14T14:22:57.453Z |
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);