participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "HR000M" 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 |
---|---|---|---|---|---|
5572132 | 5572132 | 20241121013827_alGJE | HR000M | 2024-11-22T14:18:00.596Z | 2024-11-22T14:19:22.267Z |
5561614 | 5561614 | 20241119211425_yhwCO | HR000M | 2024-11-21T14:13:34.971Z | 2024-11-22T14:20:42.171Z |
5503422 | 5503422 | 20241107221801_UbT3L | HR000M | 2024-11-09T14:13:02.612Z | 2024-11-16T14:28:07.111Z |
5503397 | 5503397 | 20241107220551_iSb2D | HR000M | 2024-11-09T14:12:58.957Z | 2024-11-16T14:28:06.998Z |
5502797 | 5502797 | 20241107194558_dliCq | HR000M | 2024-11-09T14:12:03.919Z | 2024-11-16T14:27:59.613Z |
5502791 | 5502791 | 20241107194536_dTraw | HR000M | 2024-11-09T14:12:03.614Z | 2024-11-16T14:27:59.598Z |
5502767 | 5502767 | 20241107194311_bXdA3 | HR000M | 2024-11-09T14:12:02.502Z | 2024-11-16T14:27:59.436Z |
5502692 | 5502692 | 20241107193226_fELyI | HR000M | 2024-11-09T14:11:58.547Z | 2024-11-16T14:27:58.751Z |
5502361 | 5502361 | 20241107181312_rX3gK | HR000M | 2024-11-09T14:11:13.233Z | 2024-11-16T14:27:54.468Z |
5502179 | 5502179 | 20241107173650_KI1w7 | HR000M | 2024-11-09T14:11:02.289Z | 2024-11-16T14:27:51.383Z |
5497640 | 5497640 | 20241107041652_pINDd | HR000M | 2024-11-08T14:14:07.219Z | 2024-11-15T14:25:05.259Z |
5497429 | 5497429 | 20241107033856_jPhS7 | HR000M | 2024-11-08T14:13:45.859Z | 2024-11-15T14:25:03.660Z |
5497331 | 5497331 | 20241107032316_L8Lch | HR000M | 2024-11-08T14:13:34.220Z | 2024-11-15T14:25:02.954Z |
5497132 | 5497132 | 20241107024736_XshEJ | HR000M | 2024-11-08T14:13:14.302Z | 2024-11-15T14:25:01.887Z |
5496893 | 5496893 | 20241107020751_2De9G | HR000M | 2024-11-08T14:12:57.578Z | 2024-11-15T14:25:00.780Z |
5496851 | 5496851 | 20241107015400_cPAdL | HR000M | 2024-11-08T14:12:55.117Z | 2024-11-15T14:25:00.592Z |
5496780 | 5496780 | 20241107013801_jjKpQ | HR000M | 2024-11-08T14:12:51.463Z | 2024-11-15T14:24:59.959Z |
5496511 | 5496511 | 20241107004055_2B7Fk | HR000M | 2024-11-08T14:12:17.845Z | 2024-11-15T14:24:58.282Z |
5496450 | 5496450 | 20241107002849_OsrRi | HR000M | 2024-11-08T14:12:10.930Z | 2024-11-15T14:24:57.862Z |
5496403 | 5496403 | 20241107001540_jHZaL | HR000M | 2024-11-08T14:12:06.868Z | 2024-11-15T14:24:57.286Z |
5496320 | 5496320 | 20241106235515_95oYJ | HR000M | 2024-11-08T14:11:58.277Z | 2024-11-15T14:24:56.838Z |
5496218 | 5496218 | 20241106233004_AuNFe | HR000M | 2024-11-08T14:11:47.495Z | 2024-11-15T14:24:56.174Z |
5495487 | 5495487 | 20241106200127_EJM7Y | HR000M | 2024-11-08T14:10:17.864Z | 2024-11-15T14:24:49.860Z |
5491653 | 5491653 | 20241106041537_wbs4J | HR000M | 2024-11-07T14:16:38.765Z | 2024-11-14T14:23:26.380Z |
5491538 | 5491538 | 20241106034146_z3k2d | HR000M | 2024-11-07T14:16:20.761Z | 2024-11-14T14:23:26.029Z |
5491471 | 5491471 | 20241106032310_bnJeD | HR000M | 2024-11-07T14:16:11.803Z | 2024-11-14T14:23:25.822Z |
5491393 | 5491393 | 20241106031125_UVmWL | HR000M | 2024-11-07T14:16:02.873Z | 2024-11-14T14:23:25.480Z |
5491230 | 5491230 | 20241106023150_ZyIcV | HR000M | 2024-11-07T14:15:35.209Z | 2024-11-14T14:23:24.930Z |
5490689 | 5490689 | 20241106001034_2vb8f | HR000M | 2024-11-07T14:14:32.756Z | 2024-11-14T14:23:21.226Z |
5490540 | 5490540 | 20241105231836_5RWlR | HR000M | 2024-11-07T14:14:10.866Z | 2024-11-14T14:23:20.783Z |
5490305 | 5490305 | 20241105220522_wdzsA | HR000M | 2024-11-07T14:13:50.985Z | 2024-11-14T14:23:18.801Z |
5490198 | 5490198 | 20241105213845_DUVgg | HR000M | 2024-11-07T14:13:33.594Z | 2024-11-14T14:23:18.135Z |
5490118 | 5490118 | 20241105210813_VfPv8 | HR000M | 2024-11-07T14:13:14.144Z | 2024-11-14T14:23:17.528Z |
5490097 | 5490097 | 20241105205919_WIRdo | HR000M | 2024-11-07T14:13:11.257Z | 2024-11-14T14:23:17.509Z |
5490066 | 5490066 | 20241105205143_Cb1pA | HR000M | 2024-11-07T14:13:08.092Z | 2024-11-14T14:23:17.393Z |
5489536 | 5489536 | 20241105191119_PYSN7 | HR000M | 2024-11-07T14:12:09.485Z | 2024-11-14T14:23:13.654Z |
5489514 | 5489514 | 20241105190800_EJK4A | HR000M | 2024-11-07T14:12:07.466Z | 2024-11-14T14:23:13.631Z |
5488878 | 5488878 | 20241105170858_1HEUP | HR000M | 2024-11-07T14:10:46.591Z | 2024-11-14T14:23:08.345Z |
5485108 | 5485108 | 20241105040511_I5ZlF | HR000M | 2024-11-06T14:17:46.536Z | 2024-11-13T14:27:40.755Z |
5484727 | 5484727 | 20241105032249_4yeUO | HR000M | 2024-11-06T14:17:12.306Z | 2024-11-13T14:27:39.452Z |
5484533 | 5484533 | 20241105030230_Mofdr | HR000M | 2024-11-06T14:16:59.915Z | 2024-11-13T14:27:38.571Z |
5484458 | 5484458 | 20241105025407_N7JYx | HR000M | 2024-11-06T14:16:56.171Z | 2024-11-13T14:27:38.112Z |
5484365 | 5484365 | 20241105024058_ShPxd | HR000M | 2024-11-06T14:16:51.121Z | 2024-11-13T14:27:37.793Z |
5483984 | 5483984 | 20241105015135_t24Ya | HR000M | 2024-11-06T14:16:00.586Z | 2024-11-13T14:27:37.104Z |
5483818 | 5483818 | 20241105013521_OD2wv | HR000M | 2024-11-06T14:15:44.697Z | 2024-11-13T14:27:36.867Z |
5483630 | 5483630 | 20241105011300_iBMw7 | HR000M | 2024-11-06T14:15:32.668Z | 2024-11-13T14:27:36.535Z |
5483572 | 5483572 | 20241105005935_LLJxl | HR000M | 2024-11-06T14:15:29.611Z | 2024-11-13T14:27:36.445Z |
5483253 | 5483253 | 20241105001931_tH1tt | HR000M | 2024-11-06T14:14:50.161Z | 2024-11-13T14:27:35.922Z |
5483225 | 5483225 | 20241105001605_RkfN2 | HR000M | 2024-11-06T14:14:48.616Z | 2024-11-13T14:27:35.869Z |
5483196 | 5483196 | 20241105001144_m6nId | HR000M | 2024-11-06T14:14:45.841Z | 2024-11-13T14:27:35.830Z |
5483033 | 5483033 | 20241104234904_kJtoM | HR000M | 2024-11-06T14:14:35.826Z | 2024-11-13T14:27:35.608Z |
5483005 | 5483005 | 20241104234748_9JkeN | HR000M | 2024-11-06T14:14:34.544Z | 2024-11-13T14:27:35.564Z |
5482932 | 5482932 | 20241104233554_46FFY | HR000M | 2024-11-06T14:14:22.143Z | 2024-11-13T14:27:35.389Z |
5482622 | 5482622 | 20241104225024_3rrjw | HR000M | 2024-11-06T14:13:27.489Z | 2024-11-13T14:27:34.906Z |
5482549 | 5482549 | 20241104223902_sOYO4 | HR000M | 2024-11-06T14:13:20.965Z | 2024-11-13T14:27:34.799Z |
5482411 | 5482411 | 20241104220840_Exdw8 | HR000M | 2024-11-06T14:13:08.924Z | 2024-11-13T14:27:34.514Z |
5482385 | 5482385 | 20241104220345_KMqVw | HR000M | 2024-11-06T14:13:07.057Z | 2024-11-13T14:27:34.470Z |
5482237 | 5482237 | 20241104213353_p3UYF | HR000M | 2024-11-06T14:12:39.981Z | 2024-11-13T14:27:34.151Z |
5482183 | 5482183 | 20241104212254_S2nF7 | HR000M | 2024-11-06T14:12:33.689Z | 2024-11-13T14:27:34.094Z |
5482166 | 5482166 | 20241104211928_3ucLy | HR000M | 2024-11-06T14:12:30.892Z | 2024-11-13T14:27:34.069Z |
5482152 | 5482152 | 20241104211706_rDd3W | HR000M | 2024-11-06T14:12:28.795Z | 2024-11-13T14:27:34.025Z |
5482139 | 5482139 | 20241104211247_VVAVR | HR000M | 2024-11-06T14:12:27.780Z | 2024-11-13T14:27:33.994Z |
5482127 | 5482127 | 20241104211055_nxNqN | HR000M | 2024-11-06T14:12:26.428Z | 2024-11-13T14:27:33.956Z |
5482042 | 5482042 | 20241104205652_tQ4UR | HR000M | 2024-11-06T14:12:17.402Z | 2024-11-13T14:27:33.760Z |
5481952 | 5481952 | 20241104202823_BPN0h | HR000M | 2024-11-06T14:11:59.753Z | 2024-11-13T14:27:33.575Z |
5481630 | 5481630 | 20241104185514_TS9Tt | HR000M | 2024-11-06T14:11:01.146Z | 2024-11-13T14:27:31.210Z |
5481361 | 5481361 | 20241104171644_zM1uo | HR000M | 2024-11-06T14:10:13.688Z | 2024-11-13T14:27:28.107Z |
5478339 | 5478339 | 20241104035457_gHOw3 | HR000M | 2024-11-05T14:18:14.969Z | 2024-11-12T14:28:14.982Z |
5478252 | 5478252 | 20241104034224_K1EQB | HR000M | 2024-11-05T14:18:06.912Z | 2024-11-12T14:28:14.725Z |
5478150 | 5478150 | 20241104032849_fRqWW | HR000M | 2024-11-05T14:17:59.286Z | 2024-11-12T14:28:14.460Z |
5477872 | 5477872 | 20241104024847_MF0E0 | HR000M | 2024-11-05T14:17:32.814Z | 2024-11-12T14:28:13.117Z |
5477687 | 5477687 | 20241104022138_iuSZw | HR000M | 2024-11-05T14:17:15.232Z | 2024-11-12T14:28:12.449Z |
5477666 | 5477666 | 20241104021932_50UUU | HR000M | 2024-11-05T14:17:13.969Z | 2024-11-12T14:28:12.386Z |
5477550 | 5477550 | 20241104020723_wkd0N | HR000M | 2024-11-05T14:17:03.060Z | 2024-11-12T14:28:11.985Z |
5477517 | 5477517 | 20241104020545_AYuWO | HR000M | 2024-11-05T14:17:00.927Z | 2024-11-12T14:28:11.934Z |
5477481 | 5477481 | 20241104020154_hQrcK | HR000M | 2024-11-05T14:16:56.706Z | 2024-11-12T14:28:11.845Z |
5477437 | 5477437 | 20241104015309_2ncUE | HR000M | 2024-11-05T14:16:53.587Z | 2024-11-12T14:28:11.756Z |
5477298 | 5477298 | 20241104013412_mHh1s | HR000M | 2024-11-05T14:16:41.790Z | 2024-11-12T14:28:10.538Z |
5477234 | 5477234 | 20241104012317_K7z6G | HR000M | 2024-11-05T14:16:34.077Z | 2024-11-12T14:28:10.440Z |
5477054 | 5477054 | 20241104005526_elNVJ | HR000M | 2024-11-05T14:16:19.628Z | 2024-11-12T14:28:08.396Z |
5476976 | 5476976 | 20241104004707_HZzWR | HR000M | 2024-11-05T14:16:15.477Z | 2024-11-12T14:28:07.963Z |
5476870 | 5476870 | 20241104003700_AWVD0 | HR000M | 2024-11-05T14:16:09.083Z | 2024-11-12T14:28:07.792Z |
5476599 | 5476599 | 20241103235052_C3A65 | HR000M | 2024-11-05T14:15:43.229Z | 2024-11-12T14:28:06.554Z |
5476466 | 5476466 | 20241103232948_5Wblk | HR000M | 2024-11-05T14:15:26.450Z | 2024-11-12T14:28:06.139Z |
5476392 | 5476392 | 20241103232020_QO20O | HR000M | 2024-11-05T14:15:15.097Z | 2024-11-12T14:28:05.935Z |
5476272 | 5476272 | 20241103225817_R73OA | HR000M | 2024-11-05T14:14:59.841Z | 2024-11-12T14:28:04.790Z |
5476262 | 5476262 | 20241103225455_XJiVJ | HR000M | 2024-11-05T14:14:59.142Z | 2024-11-12T14:28:04.693Z |
5476170 | 5476170 | 20241103223711_phl06 | HR000M | 2024-11-05T14:14:49.612Z | 2024-11-12T14:28:03.618Z |
5476152 | 5476152 | 20241103223436_n24mQ | HR000M | 2024-11-05T14:14:48.737Z | 2024-11-12T14:28:03.427Z |
5476119 | 5476119 | 20241103222933_qw66B | HR000M | 2024-11-05T14:14:46.457Z | 2024-11-12T14:28:03.062Z |
5475962 | 5475962 | 20241103220108_I2IZD | HR000M | 2024-11-05T14:14:35.942Z | 2024-11-12T14:28:01.899Z |
5475909 | 5475909 | 20241103214850_vepCG | HR000M | 2024-11-05T14:14:33.102Z | 2024-11-12T14:28:01.794Z |
5475796 | 5475796 | 20241103212723_E8H8U | HR000M | 2024-11-05T14:14:13.435Z | 2024-11-12T14:28:01.020Z |
5475745 | 5475745 | 20241103211501_bGh9e | HR000M | 2024-11-05T14:14:07.469Z | 2024-11-12T14:28:00.797Z |
5475380 | 5475380 | 20241103195627_kG3tf | HR000M | 2024-11-05T14:13:22.528Z | 2024-11-12T14:27:58.149Z |
5475367 | 5475367 | 20241103195432_IknqM | HR000M | 2024-11-05T14:13:20.660Z | 2024-11-12T14:27:58.108Z |
5475271 | 5475271 | 20241103193834_UoK2i | HR000M | 2024-11-05T14:12:57.830Z | 2024-11-12T14:27:57.881Z |
5475225 | 5475225 | 20241103193322_vxG4F | HR000M | 2024-11-05T14:12:48.671Z | 2024-11-12T14:27:57.642Z |
5475149 | 5475149 | 20241103191752_wNzWQ | HR000M | 2024-11-05T14:12:36.861Z | 2024-11-12T14:27:57.336Z |
5474912 | 5474912 | 20241103183627_L6YSe | HR000M | 2024-11-05T14:12:16.070Z | 2024-11-12T14:27:55.511Z |
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);