participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,208 rows where station_code = "USL01C" 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 |
---|---|---|---|---|---|
5573089 | 5573089 | 20241121035011_8uhKN | USL01C | 2024-11-22T14:19:09.363Z | 2024-11-22T14:19:22.447Z |
5572788 | 5572788 | 20241121030957_S9yhW | USL01C | 2024-11-22T14:18:49.463Z | 2024-11-22T14:19:22.391Z |
5572487 | 5572487 | 20241121022730_7KKpm | USL01C | 2024-11-22T14:18:29.522Z | 2024-11-22T14:19:22.337Z |
5568317 | 5568317 | 20241121122334_wzHsO | USL01C | 2024-11-22T14:08:41.847Z | 2024-11-22T14:08:41.847Z |
5567883 | 5567883 | 20241121112111_aUqoc | USL01C | 2024-11-22T14:07:29.356Z | 2024-11-22T14:07:29.356Z |
5567836 | 5567836 | 20241121111655_Wz4n0 | USL01C | 2024-11-22T14:07:21.756Z | 2024-11-22T14:07:21.756Z |
5567480 | 5567480 | 20241121102613_0NB2Q | USL01C | 2024-11-22T14:06:22.335Z | 2024-11-22T14:06:22.335Z |
5567457 | 5567457 | 20241121102127_w3ysi | USL01C | 2024-11-22T14:06:19.068Z | 2024-11-22T14:06:19.068Z |
5567414 | 5567414 | 20241121101414_bZm6E | USL01C | 2024-11-22T14:06:12.709Z | 2024-11-22T14:06:12.709Z |
5567328 | 5567328 | 20241121100255_Q41Uy | USL01C | 2024-11-22T14:05:53.438Z | 2024-11-22T14:05:53.438Z |
5567207 | 5567207 | 20241121094052_ULWjJ | USL01C | 2024-11-22T14:05:34.217Z | 2024-11-22T14:05:34.217Z |
5567073 | 5567073 | 20241121090941_k5Yt3 | USL01C | 2024-11-22T14:05:03.245Z | 2024-11-22T14:05:03.245Z |
5566858 | 5566858 | 20241121081711_tKn9U | USL01C | 2024-11-22T14:04:18.096Z | 2024-11-22T14:04:18.096Z |
5566848 | 5566848 | 20241121081347_JZ6Rk | USL01C | 2024-11-22T14:04:16.498Z | 2024-11-22T14:04:16.498Z |
5566765 | 5566765 | 20241121074254_DQUBL | USL01C | 2024-11-22T14:03:53.507Z | 2024-11-22T14:03:53.507Z |
5566563 | 5566563 | 20241121064216_mq3GL | USL01C | 2024-11-22T14:03:11.535Z | 2024-11-22T14:03:11.535Z |
5566515 | 5566515 | 20241121062632_kxdYM | USL01C | 2024-11-22T14:03:03.076Z | 2024-11-22T14:03:03.076Z |
5565647 | 5565647 | 20241121043105_t2D0W | USL01C | 2024-11-22T14:00:34.700Z | 2024-11-22T14:00:34.700Z |
5565645 | 5565645 | 20241121043053_5SUsM | USL01C | 2024-11-22T14:00:33.971Z | 2024-11-22T14:00:33.971Z |
5565465 | 5565465 | 20241120042832_wscEX | USL01C | 2024-11-21T14:18:50.051Z | 2024-11-22T14:21:47.402Z |
5565271 | 5565271 | 20241120040851_9TKiV | USL01C | 2024-11-21T14:18:44.260Z | 2024-11-22T14:21:45.007Z |
5563539 | 5563539 | 20241120013927_4hnya | USL01C | 2024-11-21T14:16:15.989Z | 2024-11-22T14:21:17.848Z |
5560485 | 5560485 | 20241120125606_I4r3o | USL01C | 2024-11-21T14:08:56.565Z | 2024-11-22T14:19:21.668Z |
5560424 | 5560424 | 20241120125003_oI380 | USL01C | 2024-11-21T14:08:49.731Z | 2024-11-22T14:19:21.656Z |
5560057 | 5560057 | 20241120115225_aGebE | USL01C | 2024-11-21T14:07:57.343Z | 2024-11-22T14:19:21.577Z |
5559847 | 5559847 | 20241120112358_G8gvb | USL01C | 2024-11-21T14:07:19.562Z | 2024-11-22T14:19:21.535Z |
5559142 | 5559142 | 20241120092744_zsyXG | USL01C | 2024-11-21T14:05:27.146Z | 2024-11-22T14:19:21.372Z |
5558959 | 5558959 | 20241120085916_MsDY6 | USL01C | 2024-11-21T14:04:53.318Z | 2024-11-22T14:19:21.335Z |
5558852 | 5558852 | 20241120082929_6OYZN | USL01C | 2024-11-21T14:04:37.995Z | 2024-11-22T14:19:21.314Z |
5558586 | 5558586 | 20241120064539_0P2sS | USL01C | 2024-11-21T14:03:45.027Z | 2024-11-22T14:19:21.257Z |
5558575 | 5558575 | 20241120064208_jtLDU | USL01C | 2024-11-21T14:03:43.173Z | 2024-11-22T14:19:21.255Z |
5557127 | 5557127 | 20241119040246_PJgvd | USL01C | 2024-11-20T14:12:19.864Z | 2024-11-22T14:22:22.385Z |
5556971 | 5556971 | 20241119031124_FigPj | USL01C | 2024-11-20T14:11:53.124Z | 2024-11-22T14:22:21.401Z |
5554727 | 5554727 | 20241119101843_KKlvY | USL01C | 2024-11-20T14:03:07.978Z | 2024-11-22T14:19:50.082Z |
5554705 | 5554705 | 20241119101202_6dtgS | USL01C | 2024-11-20T14:03:04.387Z | 2024-11-22T14:19:49.335Z |
5554597 | 5554597 | 20241119094648_2IGyV | USL01C | 2024-11-20T14:02:35.402Z | 2024-11-22T14:19:45.117Z |
5554572 | 5554572 | 20241119093838_ZQqLz | USL01C | 2024-11-20T14:02:30.817Z | 2024-11-22T14:19:44.325Z |
5554307 | 5554307 | 20241119080051_UQ6Bp | USL01C | 2024-11-20T14:01:29.210Z | 2024-11-22T14:19:35.958Z |
5554280 | 5554280 | 20241119074021_NpLqN | USL01C | 2024-11-20T14:01:22.534Z | 2024-11-22T14:19:34.910Z |
5554165 | 5554165 | 20241119064407_blZ8E | USL01C | 2024-11-20T14:00:57.974Z | 2024-11-22T14:19:31.687Z |
5554067 | 5554067 | 20241119055858_y4Eld | USL01C | 2024-11-20T14:00:37.776Z | 2024-11-22T14:19:28.282Z |
5553230 | 5553230 | 20241118014428_Nmkf5 | USL01C | 2024-11-19T14:10:10.878Z | 2024-11-22T14:22:51.232Z |
5550016 | 5550016 | 20241118090843_eYJpq | USL01C | 2024-11-19T14:01:26.895Z | 2024-11-22T14:21:56.834Z |
5543685 | 5543685 | 20241115025915_d4IJJ | USL01C | 2024-11-16T14:07:01.169Z | 2024-11-22T14:24:00.741Z |
5543530 | 5543530 | 20241115015836_bfxgZ | USL01C | 2024-11-16T14:06:35.424Z | 2024-11-22T14:23:59.885Z |
5542188 | 5542188 | 20241115065501_iAS3u | USL01C | 2024-11-16T14:00:34.053Z | 2024-11-22T14:23:23.820Z |
5542156 | 5542156 | 20241115061837_qEECx | USL01C | 2024-11-16T14:00:26.622Z | 2024-11-22T14:23:23.544Z |
5542150 | 5542150 | 20241115061336_7m6C2 | USL01C | 2024-11-16T14:00:25.448Z | 2024-11-22T14:23:23.504Z |
5541969 | 5541969 | 20241114052310_ifwee | USL01C | 2024-11-15T14:08:44.489Z | 2024-11-22T14:24:21.467Z |
5541794 | 5541794 | 20241114043536_katX8 | USL01C | 2024-11-15T14:08:30.362Z | 2024-11-22T14:24:20.232Z |
5541791 | 5541791 | 20241114043512_ssocq | USL01C | 2024-11-15T14:08:30.097Z | 2024-11-22T14:24:20.221Z |
5541612 | 5541612 | 20241114031020_crxqH | USL01C | 2024-11-15T14:07:56.736Z | 2024-11-22T14:24:19.597Z |
5541580 | 5541580 | 20241114024907_iymsS | USL01C | 2024-11-15T14:07:53.246Z | 2024-11-22T14:24:19.532Z |
5541023 | 5541023 | 20241114124756_WGk4C | USL01C | 2024-11-15T14:04:56.914Z | 2024-11-22T14:23:54.321Z |
5541008 | 5541008 | 20241114124446_XcdI1 | USL01C | 2024-11-15T14:04:55.809Z | 2024-11-22T14:23:54.196Z |
5540929 | 5540929 | 20241114123024_m0z4A | USL01C | 2024-11-15T14:04:45.674Z | 2024-11-22T14:23:53.221Z |
5540924 | 5540924 | 20241114122945_zrxac | USL01C | 2024-11-15T14:04:45.064Z | 2024-11-22T14:23:53.208Z |
5540915 | 5540915 | 20241114122529_aIMwK | USL01C | 2024-11-15T14:04:42.215Z | 2024-11-22T14:23:53.097Z |
5540778 | 5540778 | 20241114120509_ThZjG | USL01C | 2024-11-15T14:04:27.303Z | 2024-11-22T14:23:52.680Z |
5540738 | 5540738 | 20241114115728_f12Fp | USL01C | 2024-11-15T14:04:22.053Z | 2024-11-22T14:23:52.444Z |
5540640 | 5540640 | 20241114114410_mViI0 | USL01C | 2024-11-15T14:04:12.565Z | 2024-11-22T14:23:51.881Z |
5540585 | 5540585 | 20241114113433_WH8ME | USL01C | 2024-11-15T14:04:05.402Z | 2024-11-22T14:23:51.675Z |
5540455 | 5540455 | 20241114110920_BW38X | USL01C | 2024-11-15T14:03:51.124Z | 2024-11-22T14:23:51.068Z |
5540453 | 5540453 | 20241114110857_xxSiy | USL01C | 2024-11-15T14:03:50.720Z | 2024-11-22T14:23:51.067Z |
5540398 | 5540398 | 20241114105438_Fxxqt | USL01C | 2024-11-15T14:03:35.039Z | 2024-11-22T14:23:50.761Z |
5540392 | 5540392 | 20241114105405_1AP72 | USL01C | 2024-11-15T14:03:34.170Z | 2024-11-22T14:23:50.731Z |
5540380 | 5540380 | 20241114104823_uS2jf | USL01C | 2024-11-15T14:03:32.976Z | 2024-11-22T14:23:50.641Z |
5540219 | 5540219 | 20241114102355_EoTBJ | USL01C | 2024-11-15T14:03:08.722Z | 2024-11-22T14:23:50.003Z |
5540035 | 5540035 | 20241114095236_3PpEE | USL01C | 2024-11-15T14:02:40.085Z | 2024-11-22T14:23:48.558Z |
5539804 | 5539804 | 20241114090324_Rx3xm | USL01C | 2024-11-15T14:02:01.114Z | 2024-11-22T14:23:46.549Z |
5539758 | 5539758 | 20241114085507_1Vlto | USL01C | 2024-11-15T14:01:51.612Z | 2024-11-22T14:23:46.243Z |
5539756 | 5539756 | 20241114085435_YmE4J | USL01C | 2024-11-15T14:01:51.130Z | 2024-11-22T14:23:46.232Z |
5535529 | 5535529 | 20241112124507_51EOG | USL01C | 2024-11-14T14:08:02.260Z | 2024-11-21T14:25:49.004Z |
5535488 | 5535488 | 20241112123743_ABHDl | USL01C | 2024-11-14T14:07:59.643Z | 2024-11-21T14:25:48.628Z |
5535433 | 5535433 | 20241112122604_EtXmW | USL01C | 2024-11-14T14:07:55.521Z | 2024-11-21T14:25:48.219Z |
5534959 | 5534959 | 20241112111647_rMNsv | USL01C | 2024-11-14T14:07:01.886Z | 2024-11-21T14:25:41.919Z |
5534919 | 5534919 | 20241112110808_m6G7m | USL01C | 2024-11-14T14:06:58.902Z | 2024-11-21T14:25:41.569Z |
5532760 | 5532760 | 20241111051526_fk7kH | USL01C | 2024-11-13T14:21:00.582Z | 2024-11-19T14:22:23.447Z |
5532756 | 5532756 | 20241111031704_DXE1g | USL01C | 2024-11-13T14:20:43.716Z | 2024-11-19T14:22:17.457Z |
5532749 | 5532749 | 20241111015839_NKKEE | USL01C | 2024-11-13T14:20:31.246Z | 2024-11-19T14:22:13.966Z |
5532326 | 5532326 | 20241112050756_rh5T2 | USL01C | 2024-11-13T14:16:36.794Z | 2024-11-20T14:26:21.903Z |
5532005 | 5532005 | 20241112042623_NslD4 | USL01C | 2024-11-13T14:16:09.153Z | 2024-11-20T14:26:16.913Z |
5531957 | 5531957 | 20241112042229_i3bJg | USL01C | 2024-11-13T14:16:03.629Z | 2024-11-20T14:26:16.608Z |
5531577 | 5531577 | 20241112035021_jPZrf | USL01C | 2024-11-13T14:15:45.263Z | 2024-11-20T14:26:12.513Z |
5527117 | 5527117 | 20241112110157_yPHvu | USL01C | 2024-11-13T14:05:04.310Z | 2024-11-21T14:25:41.367Z |
5527090 | 5527090 | 20241112105933_FvaJ5 | USL01C | 2024-11-13T14:05:00.619Z | 2024-11-21T14:25:41.036Z |
5527025 | 5527025 | 20241112104801_AS4yR | USL01C | 2024-11-13T14:04:52.385Z | 2024-11-21T14:25:40.429Z |
5526691 | 5526691 | 20241112100223_A0Mq7 | USL01C | 2024-11-13T14:03:55.930Z | 2024-11-21T14:25:37.233Z |
5526464 | 5526464 | 20241112092333_R3iwr | USL01C | 2024-11-13T14:03:14.752Z | 2024-11-21T14:25:35.688Z |
5526419 | 5526419 | 20241112091538_lxCUl | USL01C | 2024-11-13T14:02:57.659Z | 2024-11-21T14:25:34.789Z |
5526268 | 5526268 | 20241112084750_AIla1 | USL01C | 2024-11-13T14:02:32.851Z | 2024-11-21T14:25:33.392Z |
5526005 | 5526005 | 20241112074423_fWE94 | USL01C | 2024-11-13T14:01:27.240Z | 2024-11-21T14:25:29.751Z |
5525884 | 5525884 | 20241112071002_YqcGq | USL01C | 2024-11-13T14:01:04.639Z | 2024-11-21T14:25:28.697Z |
5524794 | 5524794 | 20241111054500_QdN7I | USL01C | 2024-11-12T14:18:01.580Z | 2024-11-19T14:22:24.080Z |
5524710 | 5524710 | 20241111051525_21uiG | USL01C | 2024-11-12T14:17:56.432Z | 2024-11-19T14:22:23.440Z |
5524121 | 5524121 | 20241111031704_H4Ew2 | USL01C | 2024-11-12T14:16:34.006Z | 2024-11-12T14:18:08.478Z |
5520532 | 5520532 | 20241110114647_LzgeL | USL01C | 2024-11-12T14:08:12.200Z | 2024-11-19T14:21:35.561Z |
5520465 | 5520465 | 20241110080209_1KQxZ | USL01C | 2024-11-12T14:06:55.773Z | 2024-11-19T14:21:20.825Z |
5518567 | 5518567 | 20241111081725_4emW0 | USL01C | 2024-11-12T14:01:21.903Z | 2024-11-20T14:24:36.951Z |
5518519 | 5518519 | 20241111080836_GvR0K | USL01C | 2024-11-12T14:01:11.366Z | 2024-11-20T14:24:35.673Z |
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);