participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00D" 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 |
---|---|---|---|---|---|
5573044 | 5573044 | 20241121034317_LQwlz | USL00D | 2024-11-22T14:19:07.159Z | 2024-11-22T14:19:22.439Z |
5572902 | 5572902 | 20241121032348_plkJL | USL00D | 2024-11-22T14:18:57.882Z | 2024-11-22T14:19:22.411Z |
5572395 | 5572395 | 20241121021741_KvnJk | USL00D | 2024-11-22T14:18:22.839Z | 2024-11-22T14:19:22.322Z |
5572178 | 5572178 | 20241121014339_d6yj7 | USL00D | 2024-11-22T14:18:03.610Z | 2024-11-22T14:19:22.274Z |
5568555 | 5568555 | 20241121125836_F7tWO | USL00D | 2024-11-22T14:09:19.829Z | 2024-11-22T14:09:19.829Z |
5568433 | 5568433 | 20241121124815_0e2In | USL00D | 2024-11-22T14:08:57.184Z | 2024-11-22T14:08:57.184Z |
5568337 | 5568337 | 20241121122656_LLL7J | USL00D | 2024-11-22T14:08:45.100Z | 2024-11-22T14:08:45.100Z |
5568278 | 5568278 | 20241121121714_kT6fP | USL00D | 2024-11-22T14:08:38.183Z | 2024-11-22T14:08:38.183Z |
5568172 | 5568172 | 20241121120011_od3hQ | USL00D | 2024-11-22T14:08:16.491Z | 2024-11-22T14:08:16.491Z |
5567674 | 5567674 | 20241121105106_hgcba | USL00D | 2024-11-22T14:06:50.753Z | 2024-11-22T14:06:50.753Z |
5567540 | 5567540 | 20241121103315_hIjyG | USL00D | 2024-11-22T14:06:28.949Z | 2024-11-22T14:06:28.949Z |
5567422 | 5567422 | 20241121101543_X5LY4 | USL00D | 2024-11-22T14:06:14.042Z | 2024-11-22T14:06:14.042Z |
5567238 | 5567238 | 20241121094746_eJDYg | USL00D | 2024-11-22T14:05:39.855Z | 2024-11-22T14:05:39.855Z |
5567218 | 5567218 | 20241121094342_6w2HR | USL00D | 2024-11-22T14:05:35.979Z | 2024-11-22T14:05:35.979Z |
5567178 | 5567178 | 20241121093647_IzX5Q | USL00D | 2024-11-22T14:05:30.328Z | 2024-11-22T14:05:30.328Z |
5567091 | 5567091 | 20241121092001_wvWaa | USL00D | 2024-11-22T14:05:07.776Z | 2024-11-22T14:05:07.776Z |
5566969 | 5566969 | 20241121085044_NFVGb | USL00D | 2024-11-22T14:04:47.525Z | 2024-11-22T14:04:47.525Z |
5566928 | 5566928 | 20241121084301_iS3Br | USL00D | 2024-11-22T14:04:32.100Z | 2024-11-22T14:04:32.100Z |
5566840 | 5566840 | 20241121080923_PTkuM | USL00D | 2024-11-22T14:04:14.625Z | 2024-11-22T14:04:14.625Z |
5566732 | 5566732 | 20241121073509_JZ4R3 | USL00D | 2024-11-22T14:03:48.098Z | 2024-11-22T14:03:48.098Z |
5566636 | 5566636 | 20241121070806_BzTZc | USL00D | 2024-11-22T14:03:31.203Z | 2024-11-22T14:03:31.203Z |
5566393 | 5566393 | 20241121060639_t3L7a | USL00D | 2024-11-22T14:02:43.094Z | 2024-11-22T14:02:43.094Z |
5566380 | 5566380 | 20241121060604_RMaIz | USL00D | 2024-11-22T14:02:40.528Z | 2024-11-22T14:02:40.528Z |
5566242 | 5566242 | 20241121055235_z7zgQ | USL00D | 2024-11-22T14:02:17.398Z | 2024-11-22T14:02:17.398Z |
5566190 | 5566190 | 20241121054423_vXHgb | USL00D | 2024-11-22T14:02:10.347Z | 2024-11-22T14:02:10.347Z |
5566061 | 5566061 | 20241121052145_lgKI2 | USL00D | 2024-11-22T14:01:39.209Z | 2024-11-22T14:01:39.209Z |
5565871 | 5565871 | 20241121045720_LWoP3 | USL00D | 2024-11-22T14:01:15.662Z | 2024-11-22T14:01:15.662Z |
5565757 | 5565757 | 20241121044159_79l5T | USL00D | 2024-11-22T14:00:52.881Z | 2024-11-22T14:00:52.881Z |
5565171 | 5565171 | 20241120035945_TL9x9 | USL00D | 2024-11-21T14:18:34.961Z | 2024-11-22T14:21:42.865Z |
5564482 | 5564482 | 20241120030022_ZrcSc | USL00D | 2024-11-21T14:17:41.429Z | 2024-11-22T14:21:32.692Z |
5560415 | 5560415 | 20241120124902_2TiYR | USL00D | 2024-11-21T14:08:48.919Z | 2024-11-22T14:19:21.654Z |
5560320 | 5560320 | 20241120123558_3ta5s | USL00D | 2024-11-21T14:08:36.987Z | 2024-11-22T14:19:21.636Z |
5560293 | 5560293 | 20241120123040_BzcxN | USL00D | 2024-11-21T14:08:32.353Z | 2024-11-22T14:19:21.630Z |
5560029 | 5560029 | 20241120114806_I5IQh | USL00D | 2024-11-21T14:07:53.766Z | 2024-11-22T14:19:21.572Z |
5559936 | 5559936 | 20241120113604_AIPQO | USL00D | 2024-11-21T14:07:36.707Z | 2024-11-22T14:19:21.553Z |
5559744 | 5559744 | 20241120111157_A3Rvm | USL00D | 2024-11-21T14:07:06.198Z | 2024-11-22T14:19:21.516Z |
5559522 | 5559522 | 20241120103840_xfBMO | USL00D | 2024-11-21T14:06:31.588Z | 2024-11-22T14:19:21.465Z |
5558921 | 5558921 | 20241120085028_neyOj | USL00D | 2024-11-21T14:04:48.872Z | 2024-11-22T14:19:21.328Z |
5558884 | 5558884 | 20241120084330_RyIyo | USL00D | 2024-11-21T14:04:43.608Z | 2024-11-22T14:19:21.321Z |
5558780 | 5558780 | 20241120080016_gFIqF | USL00D | 2024-11-21T14:04:21.329Z | 2024-11-22T14:19:21.299Z |
5558657 | 5558657 | 20241120071727_qkFYc | USL00D | 2024-11-21T14:03:57.955Z | 2024-11-22T14:19:21.273Z |
5558651 | 5558651 | 20241120071724_ERJX5 | USL00D | 2024-11-21T14:03:56.449Z | 2024-11-22T14:19:21.271Z |
5558618 | 5558618 | 20241120070744_0xA8b | USL00D | 2024-11-21T14:03:50.160Z | 2024-11-22T14:19:21.264Z |
5558615 | 5558615 | 20241120070636_KdG5u | USL00D | 2024-11-21T14:03:49.715Z | 2024-11-22T14:19:21.263Z |
5558570 | 5558570 | 20241120063952_BrRPa | USL00D | 2024-11-21T14:03:42.755Z | 2024-11-22T14:19:21.254Z |
5558308 | 5558308 | 20241120055457_C3ypp | USL00D | 2024-11-21T14:02:59.607Z | 2024-11-22T14:19:21.208Z |
5558251 | 5558251 | 20241120054908_MzCfJ | USL00D | 2024-11-21T14:02:52.361Z | 2024-11-22T14:19:21.199Z |
5557721 | 5557721 | 20241120050754_stRD4 | USL00D | 2024-11-21T14:01:35.399Z | 2024-11-22T14:19:21.117Z |
5557568 | 5557568 | 20241120045750_tMQvV | USL00D | 2024-11-21T14:01:12.054Z | 2024-11-22T14:19:21.092Z |
5557260 | 5557260 | 20241120043139_8wYUi | USL00D | 2024-11-21T14:00:17.836Z | 2024-11-22T14:19:21.039Z |
5535420 | 5535420 | 20241112122503_eZLG0 | USL00D | 2024-11-14T14:07:54.939Z | 2024-11-21T14:25:47.979Z |
5535307 | 5535307 | 20241112120655_7Owjd | USL00D | 2024-11-14T14:07:47.406Z | 2024-11-21T14:25:46.174Z |
5535103 | 5535103 | 20241112113831_ZSvuv | USL00D | 2024-11-14T14:07:15.606Z | 2024-11-21T14:25:43.882Z |
5535027 | 5535027 | 20241112112657_P22uI | USL00D | 2024-11-14T14:07:07.311Z | 2024-11-21T14:25:43.244Z |
5534977 | 5534977 | 20241112112046_gMEQb | USL00D | 2024-11-14T14:07:03.170Z | 2024-11-21T14:25:42.724Z |
5532717 | 5532717 | 20241112055404_t2w2T | USL00D | 2024-11-13T14:17:11.709Z | 2024-11-20T14:26:25.781Z |
5527032 | 5527032 | 20241112105002_w5NIn | USL00D | 2024-11-13T14:04:53.785Z | 2024-11-21T14:25:40.756Z |
5527007 | 5527007 | 20241112104451_TbN9r | USL00D | 2024-11-13T14:04:50.332Z | 2024-11-21T14:25:40.279Z |
5526984 | 5526984 | 20241112104213_6CYez | USL00D | 2024-11-13T14:04:47.321Z | 2024-11-21T14:25:40.141Z |
5526948 | 5526948 | 20241112103532_2VGIh | USL00D | 2024-11-13T14:04:42.232Z | 2024-11-21T14:25:39.892Z |
5526827 | 5526827 | 20241112102028_62n2Q | USL00D | 2024-11-13T14:04:16.165Z | 2024-11-21T14:25:38.889Z |
5526818 | 5526818 | 20241112102002_5JUwi | USL00D | 2024-11-13T14:04:14.735Z | 2024-11-21T14:25:38.833Z |
5526798 | 5526798 | 20241112101621_b8Yd0 | USL00D | 2024-11-13T14:04:10.811Z | 2024-11-21T14:25:38.587Z |
5526647 | 5526647 | 20241112095733_ytrbU | USL00D | 2024-11-13T14:03:42.795Z | 2024-11-21T14:25:36.887Z |
5526629 | 5526629 | 20241112095631_c6Tlk | USL00D | 2024-11-13T14:03:40.107Z | 2024-11-21T14:25:36.874Z |
5526600 | 5526600 | 20241112095222_3MMpg | USL00D | 2024-11-13T14:03:35.491Z | 2024-11-21T14:25:36.758Z |
5526332 | 5526332 | 20241112090050_lZ6wa | USL00D | 2024-11-13T14:02:43.634Z | 2024-11-21T14:25:34.093Z |
5526235 | 5526235 | 20241112083938_6dKS0 | USL00D | 2024-11-13T14:02:19.116Z | 2024-11-21T14:25:33.001Z |
5526167 | 5526167 | 20241112082548_2xZ4D | USL00D | 2024-11-13T14:02:04.615Z | 2024-11-21T14:25:30.850Z |
5526119 | 5526119 | 20241112080918_yDf2S | USL00D | 2024-11-13T14:01:57.420Z | 2024-11-21T14:25:30.569Z |
5525935 | 5525935 | 20241112072241_l39Ti | USL00D | 2024-11-13T14:01:15.703Z | 2024-11-21T14:25:29.095Z |
5525816 | 5525816 | 20241112065142_BBb4j | USL00D | 2024-11-13T14:00:50.830Z | 2024-11-21T14:25:27.286Z |
5525795 | 5525795 | 20241112064614_NwzgP | USL00D | 2024-11-13T14:00:46.890Z | 2024-11-21T14:25:26.823Z |
5524383 | 5524383 | 20241111040446_M3zAC | USL00D | 2024-11-12T14:17:12.972Z | 2024-11-19T14:22:20.884Z |
5519742 | 5519742 | 20241111124750_E9Sd4 | USL00D | 2024-11-12T14:04:53.575Z | 2024-11-20T14:24:56.621Z |
5519685 | 5519685 | 20241111123100_9fX90 | USL00D | 2024-11-12T14:04:45.626Z | 2024-11-20T14:24:55.552Z |
5519670 | 5519670 | 20241111122438_bFsN0 | USL00D | 2024-11-12T14:04:42.995Z | 2024-11-20T14:24:55.146Z |
5519651 | 5519651 | 20241111122108_MYzpO | USL00D | 2024-11-12T14:04:39.926Z | 2024-11-20T14:24:54.452Z |
5519575 | 5519575 | 20241111120415_tKAna | USL00D | 2024-11-12T14:04:32.411Z | 2024-11-20T14:24:52.809Z |
5519505 | 5519505 | 20241111114126_COrSu | USL00D | 2024-11-12T14:04:18.141Z | 2024-11-20T14:24:51.371Z |
5519407 | 5519407 | 20241111111823_yO3qW | USL00D | 2024-11-12T14:03:57.231Z | 2024-11-20T14:24:49.800Z |
5519333 | 5519333 | 20241111110200_z7XeT | USL00D | 2024-11-12T14:03:46.861Z | 2024-11-20T14:24:47.646Z |
5519242 | 5519242 | 20241111104441_SWYdA | USL00D | 2024-11-12T14:03:24.449Z | 2024-11-20T14:24:46.669Z |
5519195 | 5519195 | 20241111103839_OcsrR | USL00D | 2024-11-12T14:03:19.520Z | 2024-11-20T14:24:46.415Z |
5519189 | 5519189 | 20241111103624_rxIj1 | USL00D | 2024-11-12T14:03:17.542Z | 2024-11-20T14:24:46.384Z |
5519173 | 5519173 | 20241111103343_FnBLZ | USL00D | 2024-11-12T14:03:15.231Z | 2024-11-20T14:24:46.270Z |
5519169 | 5519169 | 20241111103218_VFN5x | USL00D | 2024-11-12T14:03:14.777Z | 2024-11-20T14:24:46.225Z |
5519163 | 5519163 | 20241111102852_OztkJ | USL00D | 2024-11-12T14:03:14.040Z | 2024-11-20T14:24:46.045Z |
5519151 | 5519151 | 20241111102434_4d6il | USL00D | 2024-11-12T14:03:12.518Z | 2024-11-20T14:24:45.961Z |
5518897 | 5518897 | 20241111092901_G68nK | USL00D | 2024-11-12T14:02:18.141Z | 2024-11-20T14:24:42.599Z |
5518894 | 5518894 | 20241111092852_HekoE | USL00D | 2024-11-12T14:02:17.451Z | 2024-11-20T14:24:42.491Z |
5518810 | 5518810 | 20241111091602_3clIH | USL00D | 2024-11-12T14:02:08.668Z | 2024-11-20T14:24:41.567Z |
5518760 | 5518760 | 20241111090244_xmkvf | USL00D | 2024-11-12T14:01:55.153Z | 2024-11-20T14:24:40.851Z |
5518730 | 5518730 | 20241111090146_NoO5V | USL00D | 2024-11-12T14:01:48.137Z | 2024-11-20T14:24:40.625Z |
5518723 | 5518723 | 20241111085957_aFDPE | USL00D | 2024-11-12T14:01:47.241Z | 2024-11-20T14:24:40.541Z |
5518708 | 5518708 | 20241111085349_pqdsi | USL00D | 2024-11-12T14:01:44.694Z | 2024-11-20T14:24:40.173Z |
5518393 | 5518393 | 20241111072518_qv7gc | USL00D | 2024-11-12T14:00:49.866Z | 2024-11-20T14:24:33.468Z |
5518391 | 5518391 | 20241111072514_3jpDB | USL00D | 2024-11-12T14:00:49.540Z | 2024-11-20T14:24:33.342Z |
5511386 | 5511386 | 20241109060138_U3tmI | USL00D | 2024-11-10T14:16:44.382Z | 2024-11-17T14:24:08.427Z |
5511326 | 5511326 | 20241109054539_O4CXp | USL00D | 2024-11-10T14:16:40.782Z | 2024-11-17T14:24:07.914Z |
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);