participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,677 rows where station_code = "NZ001X" 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 |
---|---|---|---|---|---|
5560978 | 5560978 | 20241120154253_d2CV9 | NZ001X | 2024-11-21T14:10:07.941Z | 2024-11-22T14:19:21.776Z |
5560932 | 5560932 | 20241120152425_STRt9 | NZ001X | 2024-11-21T14:09:59.317Z | 2024-11-22T14:19:21.763Z |
5560808 | 5560808 | 20241120143255_KSxAa | NZ001X | 2024-11-21T14:09:47.239Z | 2024-11-22T14:19:21.737Z |
5560748 | 5560748 | 20241120141509_CjaeG | NZ001X | 2024-11-21T14:09:42.118Z | 2024-11-22T14:19:21.727Z |
5560672 | 5560672 | 20241120135128_MvJOY | NZ001X | 2024-11-21T14:09:24.243Z | 2024-11-22T14:19:21.710Z |
5560622 | 5560622 | 20241120132747_pThcw | NZ001X | 2024-11-21T14:09:16.524Z | 2024-11-22T14:19:21.699Z |
5560451 | 5560451 | 20241120125320_q93QS | NZ001X | 2024-11-21T14:08:53.524Z | 2024-11-22T14:19:21.662Z |
5559839 | 5559839 | 20241120112301_zyiMG | NZ001X | 2024-11-21T14:07:18.700Z | 2024-11-22T14:19:21.534Z |
5559824 | 5559824 | 20241120112200_d5g1h | NZ001X | 2024-11-21T14:07:16.846Z | 2024-11-22T14:19:21.532Z |
5555740 | 5555740 | 20241119152309_PurUp | NZ001X | 2024-11-20T14:06:31.055Z | 2024-11-22T14:20:13.300Z |
5555720 | 5555720 | 20241119150104_wSYUx | NZ001X | 2024-11-20T14:06:28.554Z | 2024-11-22T14:20:12.876Z |
5555672 | 5555672 | 20241119143307_vPBwG | NZ001X | 2024-11-20T14:06:22.927Z | 2024-11-22T14:20:12.206Z |
5555653 | 5555653 | 20241119142318_n2p7d | NZ001X | 2024-11-20T14:06:20.579Z | 2024-11-22T14:20:11.859Z |
5555630 | 5555630 | 20241119141155_4iaMJ | NZ001X | 2024-11-20T14:06:10.539Z | 2024-11-22T14:20:11.327Z |
5555606 | 5555606 | 20241119140505_8FTr2 | NZ001X | 2024-11-20T14:06:05.828Z | 2024-11-22T14:20:10.833Z |
5555603 | 5555603 | 20241119140341_vYooS | NZ001X | 2024-11-20T14:06:05.092Z | 2024-11-22T14:20:10.767Z |
5555350 | 5555350 | 20241119125418_QSanf | NZ001X | 2024-11-20T14:05:15.948Z | 2024-11-22T14:20:04.611Z |
5555318 | 5555318 | 20241119124037_K4nOO | NZ001X | 2024-11-20T14:05:10.760Z | 2024-11-22T14:20:03.778Z |
5551756 | 5551756 | 20241118150557_eeErT | NZ001X | 2024-11-19T14:05:24.584Z | 2024-11-22T14:22:12.387Z |
5551732 | 5551732 | 20241118145835_nY4To | NZ001X | 2024-11-19T14:05:22.058Z | 2024-11-22T14:22:12.329Z |
5551536 | 5551536 | 20241118141009_AKTpD | NZ001X | 2024-11-19T14:04:57.938Z | 2024-11-22T14:22:11.331Z |
5551522 | 5551522 | 20241118140721_Fr2vV | NZ001X | 2024-11-19T14:04:56.715Z | 2024-11-22T14:22:11.242Z |
5550823 | 5550823 | 20241118113210_QA9Ym | NZ001X | 2024-11-19T14:03:10.121Z | 2024-11-22T14:22:05.949Z |
5550419 | 5550419 | 20241118101818_F38mG | NZ001X | 2024-11-19T14:02:18.946Z | 2024-11-22T14:22:02.820Z |
5550291 | 5550291 | 20241118100018_U20N0 | NZ001X | 2024-11-19T14:02:05.686Z | 2024-11-22T14:22:00.855Z |
5547303 | 5547303 | 20241117153406_4HgMt | NZ001X | 2024-11-18T14:05:26.982Z | 2024-11-22T14:22:38.899Z |
5547273 | 5547273 | 20241117152439_FBbjL | NZ001X | 2024-11-18T14:05:24.468Z | 2024-11-22T14:22:38.310Z |
5547139 | 5547139 | 20241117145842_EoWLd | NZ001X | 2024-11-18T14:05:10.231Z | 2024-11-22T14:22:37.607Z |
5546840 | 5546840 | 20241117125903_FqTL2 | NZ001X | 2024-11-18T14:04:19.753Z | 2024-11-22T14:22:34.933Z |
5546572 | 5546572 | 20241117114322_eMHUS | NZ001X | 2024-11-18T14:03:32.295Z | 2024-11-22T14:22:33.090Z |
5546036 | 5546036 | 20241117085549_d05P9 | NZ001X | 2024-11-18T14:01:47.767Z | 2024-11-22T14:22:28.306Z |
5544771 | 5544771 | 20241116151501_hM9Ov | NZ001X | 2024-11-17T14:02:03.678Z | 2024-11-22T14:23:06.225Z |
5535869 | 5535869 | 20241112143853_b1Ne0 | NZ001X | 2024-11-14T14:08:56.043Z | 2024-11-21T14:25:53.981Z |
5535767 | 5535767 | 20241112141452_YwZUf | NZ001X | 2024-11-14T14:08:47.945Z | 2024-11-21T14:25:52.911Z |
5535358 | 5535358 | 20241112121840_mFnGo | NZ001X | 2024-11-14T14:07:51.181Z | 2024-11-21T14:25:46.557Z |
5520420 | 5520420 | 20241111154527_Loemj | NZ001X | 2024-11-12T14:06:18.402Z | 2024-11-20T14:25:08.668Z |
5520195 | 5520195 | 20241111145725_bhWlu | NZ001X | 2024-11-12T14:05:57.000Z | 2024-11-20T14:25:05.739Z |
5520049 | 5520049 | 20241111142628_ybrGr | NZ001X | 2024-11-12T14:05:31.026Z | 2024-11-20T14:25:02.664Z |
5519933 | 5519933 | 20241111135853_hVFmQ | NZ001X | 2024-11-12T14:05:20.848Z | 2024-11-20T14:25:00.898Z |
5519822 | 5519822 | 20241111131434_a3oEW | NZ001X | 2024-11-12T14:05:05.849Z | 2024-11-20T14:24:58.336Z |
5519734 | 5519734 | 20241111124525_K0KCh | NZ001X | 2024-11-12T14:04:52.248Z | 2024-11-20T14:24:56.337Z |
5519598 | 5519598 | 20241111121032_I5DHI | NZ001X | 2024-11-12T14:04:34.553Z | 2024-11-20T14:24:53.359Z |
5514382 | 5514382 | 20241110154058_zGDoy | NZ001X | 2024-11-11T14:06:33.943Z | 2024-11-19T14:21:46.981Z |
5514301 | 5514301 | 20241110152739_Wq13W | NZ001X | 2024-11-11T14:06:27.061Z | 2024-11-19T14:21:46.012Z |
5514247 | 5514247 | 20241110151826_HYzt2 | NZ001X | 2024-11-11T14:06:23.700Z | 2024-11-19T14:21:45.391Z |
5514195 | 5514195 | 20241110150601_PIQaP | NZ001X | 2024-11-11T14:06:19.918Z | 2024-11-19T14:21:44.757Z |
5514086 | 5514086 | 20241110141904_2A6Mt | NZ001X | 2024-11-11T14:06:04.903Z | 2024-11-19T14:21:43.284Z |
5514036 | 5514036 | 20241110135335_SOvRM | NZ001X | 2024-11-11T14:05:53.046Z | 2024-11-19T14:21:42.337Z |
5513090 | 5513090 | 20241110103701_NEm1B | NZ001X | 2024-11-11T14:03:52.502Z | 2024-11-19T14:21:31.145Z |
5498709 | 5498709 | 20241108094023_KOprP | NZ001X | 2024-11-09T14:02:14.518Z | 2024-11-17T14:22:59.268Z |
5494066 | 5494066 | 20241107152612_TvXUM | NZ001X | 2024-11-08T14:05:19.528Z | 2024-11-16T14:27:46.210Z |
5494000 | 5494000 | 20241107150728_5pZla | NZ001X | 2024-11-08T14:05:14.000Z | 2024-11-16T14:27:44.545Z |
5493962 | 5493962 | 20241107145248_B4frt | NZ001X | 2024-11-08T14:05:05.457Z | 2024-11-16T14:27:43.846Z |
5493955 | 5493955 | 20241107144806_foIcm | NZ001X | 2024-11-08T14:05:03.569Z | 2024-11-16T14:27:43.619Z |
5493871 | 5493871 | 20241107142309_3Xt6E | NZ001X | 2024-11-08T14:04:48.092Z | 2024-11-16T14:27:42.750Z |
5493822 | 5493822 | 20241107135756_X59io | NZ001X | 2024-11-08T14:04:41.924Z | 2024-11-16T14:27:41.729Z |
5493683 | 5493683 | 20241107130104_CrKmw | NZ001X | 2024-11-08T14:04:29.351Z | 2024-11-16T14:27:39.034Z |
5493638 | 5493638 | 20241107125124_mZOvf | NZ001X | 2024-11-08T14:04:24.686Z | 2024-11-16T14:27:37.832Z |
5493597 | 5493597 | 20241107124354_lbXlt | NZ001X | 2024-11-08T14:04:14.707Z | 2024-11-16T14:27:36.680Z |
5493575 | 5493575 | 20241107123858_leMvU | NZ001X | 2024-11-08T14:04:08.990Z | 2024-11-16T14:27:36.295Z |
5493529 | 5493529 | 20241107122650_qziM3 | NZ001X | 2024-11-08T14:03:59.362Z | 2024-11-16T14:27:35.497Z |
5493501 | 5493501 | 20241107122302_uh70z | NZ001X | 2024-11-08T14:03:53.596Z | 2024-11-16T14:27:35.054Z |
5493248 | 5493248 | 20241107112537_4fo8b | NZ001X | 2024-11-08T14:03:19.455Z | 2024-11-16T14:27:33.169Z |
5493189 | 5493189 | 20241107111531_tr1b2 | NZ001X | 2024-11-08T14:03:05.294Z | 2024-11-16T14:27:32.875Z |
5493131 | 5493131 | 20241107110132_3r7bN | NZ001X | 2024-11-08T14:02:56.242Z | 2024-11-16T14:27:32.211Z |
5493051 | 5493051 | 20241107104327_5tf6m | NZ001X | 2024-11-08T14:02:46.562Z | 2024-11-16T14:27:31.696Z |
5492908 | 5492908 | 20241107101856_z21jn | NZ001X | 2024-11-08T14:02:31.759Z | 2024-11-16T14:27:30.469Z |
5492573 | 5492573 | 20241107090748_BmotK | NZ001X | 2024-11-08T14:01:29.130Z | 2024-11-16T14:27:26.887Z |
5473727 | 5473727 | 20241103145521_7Oh3W | NZ001X | 2024-11-05T14:09:35.541Z | 2024-11-12T14:27:49.982Z |
5473714 | 5473714 | 20241103145313_bpT4B | NZ001X | 2024-11-05T14:09:30.731Z | 2024-11-12T14:27:49.960Z |
5473201 | 5473201 | 20241103134038_x0319 | NZ001X | 2024-11-05T14:08:33.574Z | 2024-11-12T14:27:48.218Z |
5473169 | 5473169 | 20241103133648_fYW8X | NZ001X | 2024-11-05T14:08:27.730Z | 2024-11-12T14:27:48.128Z |
5473027 | 5473027 | 20241103131630_JsLDo | NZ001X | 2024-11-05T14:08:04.096Z | 2024-11-12T14:27:47.585Z |
5465416 | 5465416 | 20241103115239_jljM3 | NZ001X | 2024-11-04T14:03:40.907Z | 2024-11-12T14:27:46.200Z |
5465346 | 5465346 | 20241103113159_YixNK | NZ001X | 2024-11-04T14:03:32.417Z | 2024-11-12T14:27:46.092Z |
5464761 | 5464761 | 20241103090735_Sgb8Z | NZ001X | 2024-11-04T14:01:36.442Z | 2024-11-12T14:27:43.184Z |
5461022 | 5461022 | 20241101153700_pWZ2r | NZ001X | 2024-11-03T14:14:39.627Z | 2024-11-10T14:26:26.540Z |
5460386 | 5460386 | 20241101140145_SPyWH | NZ001X | 2024-11-03T14:13:41.049Z | 2024-11-10T14:26:23.747Z |
5460310 | 5460310 | 20241101134100_zl9MB | NZ001X | 2024-11-03T14:13:34.966Z | 2024-11-10T14:26:23.338Z |
5460016 | 5460016 | 20241101123023_1PsXT | NZ001X | 2024-11-03T14:13:07.945Z | 2024-11-10T14:26:21.894Z |
5459959 | 5459959 | 20241101122409_8hdCA | NZ001X | 2024-11-03T14:12:58.215Z | 2024-11-10T14:26:21.750Z |
5459740 | 5459740 | 20241101114648_6O7A3 | NZ001X | 2024-11-03T14:12:32.381Z | 2024-11-10T14:26:20.758Z |
5457025 | 5457025 | 20241102131504_YV0W4 | NZ001X | 2024-11-03T14:06:23.451Z | 2024-11-11T14:22:32.374Z |
5456998 | 5456998 | 20241102131239_2i1ty | NZ001X | 2024-11-03T14:06:20.387Z | 2024-11-11T14:22:32.348Z |
5437934 | 5437934 | 20241030160400_pGTaU | NZ001X | 2024-11-01T12:10:44.461Z | 2024-11-08T14:22:58.492Z |
5437653 | 5437653 | 20241030153222_PTpzY | NZ001X | 2024-11-01T12:10:09.360Z | 2024-11-08T14:22:57.619Z |
5437611 | 5437611 | 20241030152745_PrYS5 | NZ001X | 2024-11-01T12:10:05.298Z | 2024-11-08T14:22:57.579Z |
5437256 | 5437256 | 20241030144829_3GR96 | NZ001X | 2024-11-01T12:09:18.164Z | 2024-11-08T14:22:56.795Z |
5437192 | 5437192 | 20241030143958_n2g2p | NZ001X | 2024-11-01T12:09:13.311Z | 2024-11-08T14:22:56.762Z |
5437053 | 5437053 | 20241030142343_HvFjY | NZ001X | 2024-11-01T12:08:48.570Z | 2024-11-08T14:22:56.427Z |
5436647 | 5436647 | 20241030133058_yE1v3 | NZ001X | 2024-11-01T12:08:01.063Z | 2024-11-08T14:22:54.566Z |
5436607 | 5436607 | 20241030132752_T7qHd | NZ001X | 2024-11-01T12:07:57.412Z | 2024-11-08T14:22:54.500Z |
5436423 | 5436423 | 20241030130522_h75Vy | NZ001X | 2024-11-01T12:07:32.478Z | 2024-11-08T14:22:54.036Z |
5436403 | 5436403 | 20241030130200_9zRTQ | NZ001X | 2024-11-01T12:07:29.155Z | 2024-11-08T14:22:54.028Z |
5436254 | 5436254 | 20241030124207_u3eLk | NZ001X | 2024-11-01T12:07:10.888Z | 2024-11-08T14:22:53.623Z |
5435811 | 5435811 | 20241030115901_YoPJJ | NZ001X | 2024-11-01T12:05:57.794Z | 2024-11-08T14:22:51.752Z |
5435775 | 5435775 | 20241030115553_X1R0q | NZ001X | 2024-11-01T12:05:52.678Z | 2024-11-08T14:22:51.697Z |
5435672 | 5435672 | 20241030114908_BWKAm | NZ001X | 2024-11-01T12:05:44.954Z | 2024-11-08T14:22:51.350Z |
5435333 | 5435333 | 20241030111851_Becwl | NZ001X | 2024-11-01T12:04:56.043Z | 2024-11-08T14:22:50.235Z |
5435029 | 5435029 | 20241030104035_I8T2t | NZ001X | 2024-11-01T12:04:00.991Z | 2024-11-08T14:22:48.972Z |
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);