participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,107 rows where station_code = "US002X" 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 |
---|---|---|---|---|---|
5592455 | 5592455 | 20241123032929_Zo63u | US002X | 2024-11-24T14:21:02.261Z | 2024-11-24T14:21:11.784Z |
5592259 | 5592259 | 20241123024736_vRY7i | US002X | 2024-11-24T14:20:50.269Z | 2024-11-24T14:21:11.728Z |
5592248 | 5592248 | 20241123024551_yiQi8 | US002X | 2024-11-24T14:20:49.689Z | 2024-11-24T14:21:11.725Z |
5592197 | 5592197 | 20241123023259_puZ2z | US002X | 2024-11-24T14:20:45.801Z | 2024-11-24T14:21:11.710Z |
5591752 | 5591752 | 20241123005030_EFJ2O | US002X | 2024-11-24T14:20:15.994Z | 2024-11-24T14:21:11.581Z |
5591751 | 5591751 | 20241123004809_AAZcM | US002X | 2024-11-24T14:20:15.802Z | 2024-11-24T14:21:11.581Z |
5591734 | 5591734 | 20241123004348_JdJNY | US002X | 2024-11-24T14:20:14.909Z | 2024-11-24T14:21:11.577Z |
5586409 | 5586409 | 20241123120051_RX2XU | US002X | 2024-11-24T14:07:53.190Z | 2024-11-24T14:07:53.190Z |
5586328 | 5586328 | 20241123115040_XIbdL | US002X | 2024-11-24T14:07:34.161Z | 2024-11-24T14:07:34.161Z |
5586305 | 5586305 | 20241123114802_Kcpcg | US002X | 2024-11-24T14:07:30.350Z | 2024-11-24T14:07:30.350Z |
5586120 | 5586120 | 20241123111203_kBD5Y | US002X | 2024-11-24T14:07:04.579Z | 2024-11-24T14:07:04.579Z |
5585878 | 5585878 | 20241123102829_Wj5ot | US002X | 2024-11-24T14:06:19.917Z | 2024-11-24T14:06:19.917Z |
5585741 | 5585741 | 20241123100501_AjHKh | US002X | 2024-11-24T14:06:02.487Z | 2024-11-24T14:06:02.487Z |
5585654 | 5585654 | 20241123094713_AdELp | US002X | 2024-11-24T14:05:36.631Z | 2024-11-24T14:05:36.631Z |
5585597 | 5585597 | 20241123093933_TC8uF | US002X | 2024-11-24T14:05:26.699Z | 2024-11-24T14:05:26.699Z |
5585498 | 5585498 | 20241123091519_KIbKH | US002X | 2024-11-24T14:05:02.311Z | 2024-11-24T14:05:02.311Z |
5585428 | 5585428 | 20241123085916_5XjZa | US002X | 2024-11-24T14:04:49.539Z | 2024-11-24T14:04:49.539Z |
5585397 | 5585397 | 20241123085449_owJZV | US002X | 2024-11-24T14:04:39.929Z | 2024-11-24T14:04:39.929Z |
5585328 | 5585328 | 20241123083618_OrsqW | US002X | 2024-11-24T14:04:22.468Z | 2024-11-24T14:04:22.468Z |
5585248 | 5585248 | 20241123081326_993Cw | US002X | 2024-11-24T14:04:08.156Z | 2024-11-24T14:04:08.156Z |
5584914 | 5584914 | 20241123065215_QZpa3 | US002X | 2024-11-24T14:02:56.798Z | 2024-11-24T14:02:56.798Z |
5584827 | 5584827 | 20241123063405_U6ZoP | US002X | 2024-11-24T14:02:39.358Z | 2024-11-24T14:02:39.358Z |
5584767 | 5584767 | 20241123061804_JSxzl | US002X | 2024-11-24T14:02:28.206Z | 2024-11-24T14:02:28.206Z |
5584756 | 5584756 | 20241123061326_nh4Nn | US002X | 2024-11-24T14:02:23.781Z | 2024-11-24T14:02:23.781Z |
5584719 | 5584719 | 20241123055705_422Wj | US002X | 2024-11-24T14:02:11.908Z | 2024-11-24T14:02:11.908Z |
5584690 | 5584690 | 20241123054430_pdMTL | US002X | 2024-11-24T14:02:05.155Z | 2024-11-24T14:02:05.155Z |
5584676 | 5584676 | 20241123054032_O0nGb | US002X | 2024-11-24T14:02:02.043Z | 2024-11-24T14:02:02.043Z |
5584668 | 5584668 | 20241123053841_LgsxG | US002X | 2024-11-24T14:02:00.257Z | 2024-11-24T14:02:00.257Z |
5584586 | 5584586 | 20241123050824_QXONN | US002X | 2024-11-24T14:01:35.120Z | 2024-11-24T14:01:35.120Z |
5584575 | 5584575 | 20241123050619_eA533 | US002X | 2024-11-24T14:01:32.688Z | 2024-11-24T14:01:32.688Z |
5584392 | 5584392 | 20241123042835_V8cMC | US002X | 2024-11-24T14:00:53.501Z | 2024-11-24T14:00:53.501Z |
5584262 | 5584262 | 20241123040555_TbU1P | US002X | 2024-11-24T14:00:25.075Z | 2024-11-24T14:00:25.075Z |
5584236 | 5584236 | 20241123040018_4kqQS | US002X | 2024-11-24T14:00:19.951Z | 2024-11-24T14:00:19.951Z |
5583323 | 5583323 | 20241121041113_2kbyB | US002X | 2024-11-23T14:23:52.662Z | 2024-11-24T14:24:02.945Z |
5582859 | 5582859 | 20241122040251_4NypW | US002X | 2024-11-23T14:21:21.858Z | 2024-11-24T14:22:38.205Z |
5582759 | 5582759 | 20241122035432_cq6xb | US002X | 2024-11-23T14:21:17.298Z | 2024-11-24T14:22:37.937Z |
5582166 | 5582166 | 20241122030833_Gteqb | US002X | 2024-11-23T14:20:58.170Z | 2024-11-24T14:22:36.040Z |
5581956 | 5581956 | 20241122025048_Bgulf | US002X | 2024-11-23T14:20:51.952Z | 2024-11-24T14:22:35.389Z |
5581886 | 5581886 | 20241122024523_SwYDZ | US002X | 2024-11-23T14:20:49.070Z | 2024-11-24T14:22:35.049Z |
5581741 | 5581741 | 20241122023153_ij2Sa | US002X | 2024-11-23T14:20:41.474Z | 2024-11-24T14:22:33.221Z |
5581575 | 5581575 | 20241122021431_SFnUR | US002X | 2024-11-23T14:20:31.808Z | 2024-11-24T14:22:32.176Z |
5580917 | 5580917 | 20241122012359_ZCsPm | US002X | 2024-11-23T14:19:51.667Z | 2024-11-24T14:22:30.223Z |
5580591 | 5580591 | 20241122005635_pjmeA | US002X | 2024-11-23T14:19:31.589Z | 2024-11-24T14:22:28.961Z |
5580453 | 5580453 | 20241122004303_WVnLu | US002X | 2024-11-23T14:19:22.280Z | 2024-11-24T14:22:28.463Z |
5580300 | 5580300 | 20241122002814_eGnPk | US002X | 2024-11-23T14:19:16.455Z | 2024-11-24T14:22:27.942Z |
5576385 | 5576385 | 20241122115629_T6Goj | US002X | 2024-11-23T14:09:20.976Z | 2024-11-24T14:21:10.648Z |
5576212 | 5576212 | 20241122113055_eTKUu | US002X | 2024-11-23T14:08:47.638Z | 2024-11-24T14:21:10.595Z |
5576208 | 5576208 | 20241122112921_wp5ZM | US002X | 2024-11-23T14:08:45.840Z | 2024-11-24T14:21:10.593Z |
5576093 | 5576093 | 20241122111427_m5pur | US002X | 2024-11-23T14:08:33.644Z | 2024-11-24T14:21:10.556Z |
5576065 | 5576065 | 20241122111233_2nym7 | US002X | 2024-11-23T14:08:30.944Z | 2024-11-24T14:21:10.549Z |
5576055 | 5576055 | 20241122111035_e40nt | US002X | 2024-11-23T14:08:29.347Z | 2024-11-24T14:21:10.546Z |
5576016 | 5576016 | 20241122110303_QqwB2 | US002X | 2024-11-23T14:08:15.793Z | 2024-11-24T14:21:10.534Z |
5575994 | 5575994 | 20241122105808_UnHeB | US002X | 2024-11-23T14:08:13.734Z | 2024-11-24T14:21:10.527Z |
5575974 | 5575974 | 20241122105334_8rAYE | US002X | 2024-11-23T14:08:11.361Z | 2024-11-24T14:21:10.522Z |
5575941 | 5575941 | 20241122104942_Dm6GB | US002X | 2024-11-23T14:08:06.136Z | 2024-11-24T14:21:10.513Z |
5575817 | 5575817 | 20241122102429_ZNiEb | US002X | 2024-11-23T14:07:41.166Z | 2024-11-24T14:21:10.462Z |
5575705 | 5575705 | 20241122100306_ZPyrM | US002X | 2024-11-23T14:07:22.147Z | 2024-11-24T14:21:10.411Z |
5575658 | 5575658 | 20241122095616_kPq6E | US002X | 2024-11-23T14:07:09.827Z | 2024-11-24T14:21:10.390Z |
5575585 | 5575585 | 20241122094603_m0Umd | US002X | 2024-11-23T14:06:52.639Z | 2024-11-24T14:21:10.369Z |
5575445 | 5575445 | 20241122092259_h87Qu | US002X | 2024-11-23T14:06:35.059Z | 2024-11-24T14:21:10.321Z |
5575417 | 5575417 | 20241122091839_Ef0ww | US002X | 2024-11-23T14:06:26.731Z | 2024-11-24T14:21:10.314Z |
5575386 | 5575386 | 20241122091107_5N8Zx | US002X | 2024-11-23T14:06:21.866Z | 2024-11-24T14:21:10.306Z |
5575273 | 5575273 | 20241122085617_xmNYW | US002X | 2024-11-23T14:06:02.021Z | 2024-11-24T14:21:10.271Z |
5575183 | 5575183 | 20241122083232_x6buV | US002X | 2024-11-23T14:05:42.056Z | 2024-11-24T14:21:10.241Z |
5575127 | 5575127 | 20241122081724_PM9YG | US002X | 2024-11-23T14:05:32.115Z | 2024-11-24T14:21:10.222Z |
5575024 | 5575024 | 20241122074017_6Zrhf | US002X | 2024-11-23T14:05:06.025Z | 2024-11-24T14:21:10.193Z |
5574984 | 5574984 | 20241122072734_vmjrG | US002X | 2024-11-23T14:05:00.389Z | 2024-11-24T14:21:10.183Z |
5574952 | 5574952 | 20241122071333_PRL3L | US002X | 2024-11-23T14:04:55.215Z | 2024-11-24T14:21:10.173Z |
5574949 | 5574949 | 20241122071302_z8p4W | US002X | 2024-11-23T14:04:54.274Z | 2024-11-24T14:21:10.173Z |
5574892 | 5574892 | 20241122065726_WTSC1 | US002X | 2024-11-23T14:04:45.644Z | 2024-11-24T14:21:10.156Z |
5574875 | 5574875 | 20241122065413_plmXg | US002X | 2024-11-23T14:04:42.840Z | 2024-11-24T14:21:10.151Z |
5574857 | 5574857 | 20241122064807_GQN8L | US002X | 2024-11-23T14:04:40.223Z | 2024-11-24T14:21:10.146Z |
5574628 | 5574628 | 20241122060646_RMYGX | US002X | 2024-11-23T14:03:51.221Z | 2024-11-24T14:21:10.091Z |
5574412 | 5574412 | 20241122054241_i0PN4 | US002X | 2024-11-23T14:03:17.203Z | 2024-11-24T14:21:10.049Z |
5574299 | 5574299 | 20241122053315_vGV1G | US002X | 2024-11-23T14:02:59.833Z | 2024-11-24T14:21:10.028Z |
5574291 | 5574291 | 20241122053224_hJSEe | US002X | 2024-11-23T14:02:59.009Z | 2024-11-24T14:21:10.027Z |
5574271 | 5574271 | 20241122053056_R9svl | US002X | 2024-11-23T14:02:57.484Z | 2024-11-24T14:21:10.024Z |
5574160 | 5574160 | 20241122051849_ExqWr | US002X | 2024-11-23T14:02:40.519Z | 2024-11-24T14:21:10.005Z |
5574005 | 5574005 | 20241122045946_9t8TS | US002X | 2024-11-23T14:02:08.191Z | 2024-11-24T14:21:09.929Z |
5573790 | 5573790 | 20241122044018_3ybLn | US002X | 2024-11-23T14:01:31.108Z | 2024-11-24T14:21:09.885Z |
5573725 | 5573725 | 20241122043634_3eEyE | US002X | 2024-11-23T14:01:19.615Z | 2024-11-24T14:21:09.874Z |
5573669 | 5573669 | 20241122043400_0poXX | US002X | 2024-11-23T14:01:13.618Z | 2024-11-24T14:21:09.868Z |
5573648 | 5573648 | 20241122043200_PQSzg | US002X | 2024-11-23T14:01:11.381Z | 2024-11-24T14:21:09.865Z |
5573357 | 5573357 | 20241122041230_wj25Y | US002X | 2024-11-23T14:00:22.239Z | 2024-11-24T14:21:09.821Z |
5573305 | 5573305 | 20241122040709_p3oCq | US002X | 2024-11-23T14:00:13.324Z | 2024-11-24T14:21:09.812Z |
5573114 | 5573114 | 20241121035435_Rw0K2 | US002X | 2024-11-22T14:19:10.146Z | 2024-11-24T14:24:02.065Z |
5573001 | 5573001 | 20241121033744_RJElk | US002X | 2024-11-22T14:19:03.438Z | 2024-11-24T14:24:01.379Z |
5572979 | 5572979 | 20241121033318_vESUW | US002X | 2024-11-22T14:19:02.344Z | 2024-11-24T14:24:01.036Z |
5572850 | 5572850 | 20241121031718_5xfGU | US002X | 2024-11-22T14:18:53.609Z | 2024-11-24T14:23:59.295Z |
5572331 | 5572331 | 20241121021008_gy3fj | US002X | 2024-11-22T14:18:16.471Z | 2024-11-24T14:23:53.156Z |
5572271 | 5572271 | 20241121020117_VKJu5 | US002X | 2024-11-22T14:18:09.405Z | 2024-11-24T14:23:52.716Z |
5568002 | 5568002 | 20241121114114_v16v0 | US002X | 2024-11-22T14:07:56.265Z | 2024-11-24T14:21:57.771Z |
5567947 | 5567947 | 20241121113419_VJBhP | US002X | 2024-11-22T14:07:50.503Z | 2024-11-24T14:21:57.181Z |
5567935 | 5567935 | 20241121113321_xjk5r | US002X | 2024-11-22T14:07:48.639Z | 2024-11-24T14:21:57.124Z |
5567889 | 5567889 | 20241121112307_ykoZP | US002X | 2024-11-22T14:07:30.296Z | 2024-11-24T14:21:56.352Z |
5567753 | 5567753 | 20241121105948_392t3 | US002X | 2024-11-22T14:07:12.109Z | 2024-11-24T14:21:53.880Z |
5567715 | 5567715 | 20241121105649_Iiujk | US002X | 2024-11-22T14:07:07.410Z | 2024-11-24T14:21:53.493Z |
5567640 | 5567640 | 20241121104734_HbPwN | US002X | 2024-11-22T14:06:42.539Z | 2024-11-24T14:21:52.034Z |
5567598 | 5567598 | 20241121104200_cQKv5 | US002X | 2024-11-22T14:06:35.722Z | 2024-11-24T14:21:51.485Z |
5567590 | 5567590 | 20241121104127_tQfMD | US002X | 2024-11-22T14:06:34.752Z | 2024-11-24T14:21:51.431Z |
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);