participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,227 rows where station_code = "NZ0029" 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 |
---|---|---|---|---|---|
5569402 | 5569402 | 20241121152326_GboZq | NZ0029 | 2024-11-22T14:10:50.930Z | 2024-11-22T14:10:50.930Z |
5569304 | 5569304 | 20241121150715_kBKM4 | NZ0029 | 2024-11-22T14:10:44.552Z | 2024-11-22T14:10:44.552Z |
5569292 | 5569292 | 20241121150553_4KMrn | NZ0029 | 2024-11-22T14:10:43.961Z | 2024-11-22T14:10:43.961Z |
5569289 | 5569289 | 20241121150455_IOrnR | NZ0029 | 2024-11-22T14:10:43.698Z | 2024-11-22T14:10:43.698Z |
5569222 | 5569222 | 20241121145332_kJ3yv | NZ0029 | 2024-11-22T14:10:40.210Z | 2024-11-22T14:10:40.210Z |
5569198 | 5569198 | 20241121145101_VrCjj | NZ0029 | 2024-11-22T14:10:34.120Z | 2024-11-22T14:10:34.120Z |
5569172 | 5569172 | 20241121144634_o12WJ | NZ0029 | 2024-11-22T14:10:26.427Z | 2024-11-22T14:10:26.427Z |
5569036 | 5569036 | 20241121142259_12coA | NZ0029 | 2024-11-22T14:10:13.259Z | 2024-11-22T14:10:13.259Z |
5568903 | 5568903 | 20241121140035_GkoPa | NZ0029 | 2024-11-22T14:10:02.788Z | 2024-11-22T14:10:02.788Z |
5568837 | 5568837 | 20241121134516_kfuxp | NZ0029 | 2024-11-22T14:09:57.385Z | 2024-11-22T14:09:57.385Z |
5568835 | 5568835 | 20241121134505_QhTh5 | NZ0029 | 2024-11-22T14:09:56.116Z | 2024-11-22T14:09:56.116Z |
5568801 | 5568801 | 20241121134055_gqwej | NZ0029 | 2024-11-22T14:09:45.857Z | 2024-11-22T14:09:45.857Z |
5568773 | 5568773 | 20241121133151_npE5g | NZ0029 | 2024-11-22T14:09:41.161Z | 2024-11-22T14:09:41.161Z |
5568694 | 5568694 | 20241121132115_ZT50t | NZ0029 | 2024-11-22T14:09:33.559Z | 2024-11-22T14:09:33.559Z |
5568663 | 5568663 | 20241121131833_o2SjW | NZ0029 | 2024-11-22T14:09:31.759Z | 2024-11-22T14:09:31.759Z |
5568376 | 5568376 | 20241121123418_INIfV | NZ0029 | 2024-11-22T14:08:49.649Z | 2024-11-22T14:08:49.649Z |
5568253 | 5568253 | 20241121121456_KURwV | NZ0029 | 2024-11-22T14:08:35.383Z | 2024-11-22T14:08:35.383Z |
5568210 | 5568210 | 20241121120616_zUTk9 | NZ0029 | 2024-11-22T14:08:27.772Z | 2024-11-22T14:08:27.772Z |
5568116 | 5568116 | 20241121115151_YR5qO | NZ0029 | 2024-11-22T14:08:07.784Z | 2024-11-22T14:08:07.784Z |
5567907 | 5567907 | 20241121112858_fC373 | NZ0029 | 2024-11-22T14:07:35.459Z | 2024-11-22T14:07:35.459Z |
5567731 | 5567731 | 20241121105754_V8NGz | NZ0029 | 2024-11-22T14:07:09.551Z | 2024-11-22T14:07:09.551Z |
5567721 | 5567721 | 20241121105716_boUXV | NZ0029 | 2024-11-22T14:07:08.031Z | 2024-11-22T14:07:08.031Z |
5560402 | 5560402 | 20241120124741_yzZ3D | NZ0029 | 2024-11-21T14:08:47.799Z | 2024-11-22T14:19:21.652Z |
5560359 | 5560359 | 20241120124200_EyFa2 | NZ0029 | 2024-11-21T14:08:44.105Z | 2024-11-22T14:19:21.644Z |
5560323 | 5560323 | 20241120123603_3nAOH | NZ0029 | 2024-11-21T14:08:38.119Z | 2024-11-22T14:19:21.637Z |
5560188 | 5560188 | 20241120121533_eQBCb | NZ0029 | 2024-11-21T14:08:13.213Z | 2024-11-22T14:19:21.607Z |
5560106 | 5560106 | 20241120115926_phbjl | NZ0029 | 2024-11-21T14:08:03.256Z | 2024-11-22T14:19:21.588Z |
5559640 | 5559640 | 20241120105249_IkSfs | NZ0029 | 2024-11-21T14:06:50.024Z | 2024-11-22T14:19:21.492Z |
5559451 | 5559451 | 20241120102525_gxgIa | NZ0029 | 2024-11-21T14:06:21.882Z | 2024-11-22T14:19:21.451Z |
5559144 | 5559144 | 20241120092805_kn22c | NZ0029 | 2024-11-21T14:05:27.752Z | 2024-11-22T14:19:21.373Z |
5555663 | 5555663 | 20241119142856_B1uTg | NZ0029 | 2024-11-20T14:06:21.726Z | 2024-11-22T14:20:12.058Z |
5555521 | 5555521 | 20241119134130_qRVOg | NZ0029 | 2024-11-20T14:05:55.089Z | 2024-11-22T14:20:09.077Z |
5555451 | 5555451 | 20241119131905_6Oyhs | NZ0029 | 2024-11-20T14:05:39.806Z | 2024-11-22T14:20:06.601Z |
5551229 | 5551229 | 20241118124628_529Da | NZ0029 | 2024-11-19T14:04:07.894Z | 2024-11-22T14:22:09.315Z |
5550982 | 5550982 | 20241118120649_YuYZW | NZ0029 | 2024-11-19T14:03:44.078Z | 2024-11-22T14:22:07.384Z |
5550959 | 5550959 | 20241118120245_qZaEv | NZ0029 | 2024-11-19T14:03:38.106Z | 2024-11-22T14:22:07.123Z |
5550860 | 5550860 | 20241118113834_y2PPN | NZ0029 | 2024-11-19T14:03:13.363Z | 2024-11-22T14:22:06.220Z |
5550674 | 5550674 | 20241118110841_9RMmj | NZ0029 | 2024-11-19T14:02:54.354Z | 2024-11-22T14:22:04.804Z |
5550626 | 5550626 | 20241118110004_9DBEx | NZ0029 | 2024-11-19T14:02:49.921Z | 2024-11-22T14:22:04.460Z |
5550488 | 5550488 | 20241118102845_jj4BR | NZ0029 | 2024-11-19T14:02:25.432Z | 2024-11-22T14:22:03.378Z |
5550451 | 5550451 | 20241118102226_TcODW | NZ0029 | 2024-11-19T14:02:21.598Z | 2024-11-22T14:22:03.041Z |
5550431 | 5550431 | 20241118102033_SQvnx | NZ0029 | 2024-11-19T14:02:19.908Z | 2024-11-22T14:22:02.910Z |
5550082 | 5550082 | 20241118092850_yH3bY | NZ0029 | 2024-11-19T14:01:33.109Z | 2024-11-22T14:21:57.859Z |
5550024 | 5550024 | 20241118091048_v1LrV | NZ0029 | 2024-11-19T14:01:27.522Z | 2024-11-22T14:21:56.923Z |
5549985 | 5549985 | 20241118090143_YkB3Y | NZ0029 | 2024-11-19T14:01:24.139Z | 2024-11-22T14:21:56.310Z |
5547324 | 5547324 | 20241117153928_C4m9E | NZ0029 | 2024-11-18T14:05:31.075Z | 2024-11-22T14:22:38.996Z |
5547290 | 5547290 | 20241117152557_l1p6O | NZ0029 | 2024-11-18T14:05:25.580Z | 2024-11-22T14:22:38.347Z |
5547168 | 5547168 | 20241117150305_Gkjks | NZ0029 | 2024-11-18T14:05:13.219Z | 2024-11-22T14:22:37.799Z |
5547103 | 5547103 | 20241117144403_WbeD3 | NZ0029 | 2024-11-18T14:05:00.769Z | 2024-11-22T14:22:36.937Z |
5547080 | 5547080 | 20241117143722_FY4zu | NZ0029 | 2024-11-18T14:04:55.252Z | 2024-11-22T14:22:36.730Z |
5546946 | 5546946 | 20241117133329_osImw | NZ0029 | 2024-11-18T14:04:31.520Z | 2024-11-22T14:22:35.656Z |
5546878 | 5546878 | 20241117131310_lA9ek | NZ0029 | 2024-11-18T14:04:23.778Z | 2024-11-22T14:22:35.257Z |
5546855 | 5546855 | 20241117130245_eWAmN | NZ0029 | 2024-11-18T14:04:21.693Z | 2024-11-22T14:22:35.016Z |
5546831 | 5546831 | 20241117125213_NH5vn | NZ0029 | 2024-11-18T14:04:18.335Z | 2024-11-22T14:22:34.798Z |
5546797 | 5546797 | 20241117124549_sK9ec | NZ0029 | 2024-11-18T14:04:15.035Z | 2024-11-22T14:22:34.647Z |
5546767 | 5546767 | 20241117123943_x7TN8 | NZ0029 | 2024-11-18T14:04:11.902Z | 2024-11-22T14:22:34.552Z |
5546712 | 5546712 | 20241117122559_G2x3c | NZ0029 | 2024-11-18T14:03:54.893Z | 2024-11-22T14:22:34.078Z |
5546666 | 5546666 | 20241117120911_nMb0G | NZ0029 | 2024-11-18T14:03:46.294Z | 2024-11-22T14:22:33.710Z |
5546576 | 5546576 | 20241117114541_PmRr5 | NZ0029 | 2024-11-18T14:03:32.731Z | 2024-11-22T14:22:33.144Z |
5546514 | 5546514 | 20241117112257_sRP2r | NZ0029 | 2024-11-18T14:03:16.007Z | 2024-11-22T14:22:32.375Z |
5546511 | 5546511 | 20241117112255_X5yQv | NZ0029 | 2024-11-18T14:03:15.627Z | 2024-11-22T14:22:32.353Z |
5546503 | 5546503 | 20241117112210_Jlja5 | NZ0029 | 2024-11-18T14:03:14.798Z | 2024-11-22T14:22:32.301Z |
5546358 | 5546358 | 20241117103126_YIhrN | NZ0029 | 2024-11-18T14:02:55.347Z | 2024-11-22T14:22:31.338Z |
5546240 | 5546240 | 20241117100406_wCqgI | NZ0029 | 2024-11-18T14:02:33.022Z | 2024-11-22T14:22:30.492Z |
5546195 | 5546195 | 20241117094034_CjxNM | NZ0029 | 2024-11-18T14:02:25.350Z | 2024-11-22T14:22:29.966Z |
5544782 | 5544782 | 20241116152042_QPehb | NZ0029 | 2024-11-17T14:02:06.059Z | 2024-11-22T14:23:06.277Z |
5544744 | 5544744 | 20241116145725_YJff3 | NZ0029 | 2024-11-17T14:01:59.763Z | 2024-11-22T14:23:06.121Z |
5544732 | 5544732 | 20241116145146_2niXD | NZ0029 | 2024-11-17T14:01:57.355Z | 2024-11-22T14:23:05.941Z |
5544724 | 5544724 | 20241116144845_zAb2C | NZ0029 | 2024-11-17T14:01:55.989Z | 2024-11-22T14:23:05.935Z |
5544718 | 5544718 | 20241116144454_kJOf2 | NZ0029 | 2024-11-17T14:01:54.453Z | 2024-11-22T14:23:05.912Z |
5544671 | 5544671 | 20241116140218_bYy43 | NZ0029 | 2024-11-17T14:01:49.247Z | 2024-11-22T14:23:05.350Z |
5544654 | 5544654 | 20241116134808_EXWQX | NZ0029 | 2024-11-17T14:01:46.326Z | 2024-11-22T14:23:05.260Z |
5544639 | 5544639 | 20241116133454_mGSFl | NZ0029 | 2024-11-17T14:01:44.613Z | 2024-11-22T14:23:05.190Z |
5544630 | 5544630 | 20241116131947_AJt0G | NZ0029 | 2024-11-17T14:01:43.350Z | 2024-11-22T14:23:05.061Z |
5544604 | 5544604 | 20241116130204_C8qf1 | NZ0029 | 2024-11-17T14:01:39.924Z | 2024-11-22T14:23:04.806Z |
5544501 | 5544501 | 20241116114835_Kxy1M | NZ0029 | 2024-11-17T14:01:18.602Z | 2024-11-22T14:23:03.502Z |
5544375 | 5544375 | 20241116103013_l3H4R | NZ0029 | 2024-11-17T14:00:58.332Z | 2024-11-22T14:23:02.000Z |
5544360 | 5544360 | 20241116101906_DzMbf | NZ0029 | 2024-11-17T14:00:56.363Z | 2024-11-22T14:23:01.905Z |
5542894 | 5542894 | 20241115154602_zhDdE | NZ0029 | 2024-11-16T14:02:56.140Z | 2024-11-22T14:23:32.372Z |
5542886 | 5542886 | 20241115154258_tO200 | NZ0029 | 2024-11-16T14:02:54.763Z | 2024-11-22T14:23:32.310Z |
5542847 | 5542847 | 20241115143215_kVIQG | NZ0029 | 2024-11-16T14:02:45.471Z | 2024-11-22T14:23:31.702Z |
5535674 | 5535674 | 20241112133829_aaYok | NZ0029 | 2024-11-14T14:08:20.325Z | 2024-11-21T14:25:51.127Z |
5534657 | 5534657 | 20241113150458_KbHtU | NZ0029 | 2024-11-14T14:04:49.971Z | 2024-11-22T14:24:15.035Z |
5534648 | 5534648 | 20241113144649_7YRt1 | NZ0029 | 2024-11-14T14:04:47.456Z | 2024-11-22T14:24:14.916Z |
5534632 | 5534632 | 20241113134753_Ef8u2 | NZ0029 | 2024-11-14T14:04:44.654Z | 2024-11-22T14:24:14.846Z |
5534628 | 5534628 | 20241113134131_bffh3 | NZ0029 | 2024-11-14T14:04:44.148Z | 2024-11-22T14:24:14.818Z |
5534623 | 5534623 | 20241113133424_kXYa3 | NZ0029 | 2024-11-14T14:04:43.662Z | 2024-11-22T14:24:14.811Z |
5534609 | 5534609 | 20241113130147_4nm3R | NZ0029 | 2024-11-14T14:04:42.018Z | 2024-11-22T14:24:14.773Z |
5534607 | 5534607 | 20241113130121_AD1IN | NZ0029 | 2024-11-14T14:04:41.726Z | 2024-11-22T14:24:14.772Z |
5534604 | 5534604 | 20241113130041_mMgyT | NZ0029 | 2024-11-14T14:04:40.945Z | 2024-11-22T14:24:14.743Z |
5534218 | 5534218 | 20241113112107_g65ix | NZ0029 | 2024-11-14T14:03:49.656Z | 2024-11-22T14:24:13.019Z |
5526813 | 5526813 | 20241112101856_ULKCK | NZ0029 | 2024-11-13T14:04:13.442Z | 2024-11-21T14:25:38.802Z |
5520388 | 5520388 | 20241111153239_TxCuT | NZ0029 | 2024-11-12T14:06:14.816Z | 2024-11-20T14:25:07.728Z |
5520374 | 5520374 | 20241111153014_DmsQQ | NZ0029 | 2024-11-12T14:06:13.923Z | 2024-11-20T14:25:07.638Z |
5520367 | 5520367 | 20241111152927_NXksg | NZ0029 | 2024-11-12T14:06:13.519Z | 2024-11-20T14:25:07.634Z |
5520356 | 5520356 | 20241111152817_O931T | NZ0029 | 2024-11-12T14:06:12.318Z | 2024-11-20T14:25:07.437Z |
5520339 | 5520339 | 20241111152345_4SbRe | NZ0029 | 2024-11-12T14:06:10.770Z | 2024-11-20T14:25:07.030Z |
5520294 | 5520294 | 20241111151357_QtJea | NZ0029 | 2024-11-12T14:06:06.382Z | 2024-11-20T14:25:06.476Z |
5520275 | 5520275 | 20241111151105_NRQHW | NZ0029 | 2024-11-12T14:06:03.929Z | 2024-11-20T14:25:06.400Z |
5520187 | 5520187 | 20241111145458_92EOK | NZ0029 | 2024-11-12T14:05:53.505Z | 2024-11-20T14:25:05.543Z |
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);