participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00G" 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 |
---|---|---|---|---|---|
5505599 | 5505599 | 20241108062020_mL3vw | USL00G | 2024-11-09T14:16:24.811Z | 2024-11-09T14:16:28.824Z |
5505596 | 5505596 | 20241108061952_QdQ68 | USL00G | 2024-11-09T14:16:24.687Z | 2024-11-09T14:16:28.823Z |
5505422 | 5505422 | 20241108051414_l5pEN | USL00G | 2024-11-09T14:16:16.840Z | 2024-11-09T14:16:28.780Z |
5505376 | 5505376 | 20241108045654_wYfy3 | USL00G | 2024-11-09T14:16:14.352Z | 2024-11-09T14:16:28.768Z |
5505214 | 5505214 | 20241108040848_ML9P0 | USL00G | 2024-11-09T14:15:56.096Z | 2024-11-09T14:16:28.727Z |
5505196 | 5505196 | 20241108040527_D3EXj | USL00G | 2024-11-09T14:15:54.646Z | 2024-11-09T14:16:28.723Z |
5505130 | 5505130 | 20241108035642_y9K82 | USL00G | 2024-11-09T14:15:46.550Z | 2024-11-09T14:16:28.707Z |
5504795 | 5504795 | 20241108025934_8q8vx | USL00G | 2024-11-09T14:15:11.826Z | 2024-11-09T14:16:28.628Z |
5499604 | 5499604 | 20241108124325_Ktaij | USL00G | 2024-11-09T14:04:25.751Z | 2024-11-09T14:04:25.751Z |
5499482 | 5499482 | 20241108122733_TihtQ | USL00G | 2024-11-09T14:04:11.119Z | 2024-11-09T14:04:11.119Z |
5499264 | 5499264 | 20241108114712_uHJPs | USL00G | 2024-11-09T14:03:39.057Z | 2024-11-09T14:03:39.057Z |
5499203 | 5499203 | 20241108113321_x8jK3 | USL00G | 2024-11-09T14:03:31.814Z | 2024-11-09T14:03:31.814Z |
5499182 | 5499182 | 20241108112550_4nb2t | USL00G | 2024-11-09T14:03:29.718Z | 2024-11-09T14:03:29.718Z |
5499120 | 5499120 | 20241108111159_tkHen | USL00G | 2024-11-09T14:03:15.880Z | 2024-11-09T14:03:15.880Z |
5499101 | 5499101 | 20241108110850_Qlh8b | USL00G | 2024-11-09T14:03:11.607Z | 2024-11-09T14:03:11.607Z |
5499049 | 5499049 | 20241108105250_sciyC | USL00G | 2024-11-09T14:03:02.805Z | 2024-11-09T14:03:02.805Z |
5498935 | 5498935 | 20241108102931_MrOx5 | USL00G | 2024-11-09T14:02:48.680Z | 2024-11-09T14:02:48.680Z |
5498860 | 5498860 | 20241108101606_GS1hW | USL00G | 2024-11-09T14:02:38.383Z | 2024-11-09T14:02:38.383Z |
5498793 | 5498793 | 20241108095955_O3Yyh | USL00G | 2024-11-09T14:02:25.275Z | 2024-11-09T14:02:25.275Z |
5498782 | 5498782 | 20241108095855_7ACGk | USL00G | 2024-11-09T14:02:23.910Z | 2024-11-09T14:02:23.910Z |
5498767 | 5498767 | 20241108095428_qKQ9P | USL00G | 2024-11-09T14:02:22.118Z | 2024-11-09T14:02:22.118Z |
5498532 | 5498532 | 20241108085725_3ymJX | USL00G | 2024-11-09T14:01:42.968Z | 2024-11-09T14:01:42.968Z |
5498521 | 5498521 | 20241108085533_vHjQ3 | USL00G | 2024-11-09T14:01:41.598Z | 2024-11-09T14:01:41.598Z |
5498283 | 5498283 | 20241108074927_ExPgk | USL00G | 2024-11-09T14:01:02.035Z | 2024-11-09T14:01:02.035Z |
5498280 | 5498280 | 20241108074906_Bqbrm | USL00G | 2024-11-09T14:01:01.663Z | 2024-11-09T14:01:01.663Z |
5498268 | 5498268 | 20241108074710_4QRDV | USL00G | 2024-11-09T14:00:59.603Z | 2024-11-09T14:00:59.603Z |
5498243 | 5498243 | 20241108074124_Bpyed | USL00G | 2024-11-09T14:00:55.939Z | 2024-11-09T14:00:55.939Z |
5498218 | 5498218 | 20241108073419_ptD6E | USL00G | 2024-11-09T14:00:52.067Z | 2024-11-09T14:00:52.067Z |
5498167 | 5498167 | 20241108071934_IdMNF | USL00G | 2024-11-09T14:00:42.145Z | 2024-11-09T14:00:42.145Z |
5498155 | 5498155 | 20241108071553_d3sac | USL00G | 2024-11-09T14:00:39.791Z | 2024-11-09T14:00:39.791Z |
5498147 | 5498147 | 20241108071320_I1Rmy | USL00G | 2024-11-09T14:00:38.278Z | 2024-11-09T14:00:38.278Z |
5498144 | 5498144 | 20241108071253_fu5Vz | USL00G | 2024-11-09T14:00:37.856Z | 2024-11-09T14:00:37.856Z |
5498019 | 5498019 | 20241108062502_m437o | USL00G | 2024-11-09T14:00:10.282Z | 2024-11-09T14:00:10.282Z |
5497963 | 5497963 | 20241107062646_fBsHb | USL00G | 2024-11-08T14:14:32.456Z | 2024-11-09T14:18:54.392Z |
5497933 | 5497933 | 20241107061054_PnOvi | USL00G | 2024-11-08T14:14:31.277Z | 2024-11-09T14:18:53.849Z |
5497911 | 5497911 | 20241107060012_2v0nc | USL00G | 2024-11-08T14:14:30.315Z | 2024-11-09T14:18:53.559Z |
5497645 | 5497645 | 20241107041700_llzqT | USL00G | 2024-11-08T14:14:07.535Z | 2024-11-09T14:18:49.314Z |
5497098 | 5497098 | 20241107024144_7whu4 | USL00G | 2024-11-08T14:13:09.984Z | 2024-11-09T14:18:35.504Z |
5493553 | 5493553 | 20241107123306_3s3i1 | USL00G | 2024-11-08T14:04:03.422Z | 2024-11-09T14:16:27.654Z |
5493520 | 5493520 | 20241107122452_L3Eiw | USL00G | 2024-11-08T14:03:56.855Z | 2024-11-09T14:16:27.646Z |
5493447 | 5493447 | 20241107121255_sK5jO | USL00G | 2024-11-08T14:03:46.493Z | 2024-11-09T14:16:27.626Z |
5493444 | 5493444 | 20241107121153_thM32 | USL00G | 2024-11-08T14:03:46.198Z | 2024-11-09T14:16:27.625Z |
5493432 | 5493432 | 20241107121136_DlvMw | USL00G | 2024-11-08T14:03:45.225Z | 2024-11-09T14:16:27.622Z |
5493386 | 5493386 | 20241107120121_f2X8u | USL00G | 2024-11-08T14:03:40.086Z | 2024-11-09T14:16:27.608Z |
5493343 | 5493343 | 20241107115055_0uNXg | USL00G | 2024-11-08T14:03:35.198Z | 2024-11-09T14:16:27.593Z |
5493315 | 5493315 | 20241107114632_TWnrT | USL00G | 2024-11-08T14:03:32.283Z | 2024-11-09T14:16:27.585Z |
5493194 | 5493194 | 20241107111544_Mi5bW | USL00G | 2024-11-08T14:03:05.927Z | 2024-11-09T14:16:27.557Z |
5493116 | 5493116 | 20241107105850_dPtZ2 | USL00G | 2024-11-08T14:02:52.911Z | 2024-11-09T14:16:27.537Z |
5493073 | 5493073 | 20241107104948_S843m | USL00G | 2024-11-08T14:02:48.785Z | 2024-11-09T14:16:27.525Z |
5493025 | 5493025 | 20241107103801_a8M2y | USL00G | 2024-11-08T14:02:43.977Z | 2024-11-09T14:16:27.510Z |
5492994 | 5492994 | 20241107103310_pptud | USL00G | 2024-11-08T14:02:40.998Z | 2024-11-09T14:16:27.503Z |
5492933 | 5492933 | 20241107102136_4jyrb | USL00G | 2024-11-08T14:02:35.838Z | 2024-11-09T14:16:27.491Z |
5492922 | 5492922 | 20241107102037_QLkYP | USL00G | 2024-11-08T14:02:34.271Z | 2024-11-09T14:16:27.488Z |
5492743 | 5492743 | 20241107094850_XAH5Y | USL00G | 2024-11-08T14:02:00.922Z | 2024-11-09T14:16:27.444Z |
5492717 | 5492717 | 20241107094008_0lpfB | USL00G | 2024-11-08T14:01:57.404Z | 2024-11-09T14:16:27.435Z |
5492693 | 5492693 | 20241107093245_0GOn5 | USL00G | 2024-11-08T14:01:54.598Z | 2024-11-09T14:16:27.430Z |
5492598 | 5492598 | 20241107091327_Rk5oC | USL00G | 2024-11-08T14:01:31.734Z | 2024-11-09T14:16:27.410Z |
5492555 | 5492555 | 20241107085935_3wEzI | USL00G | 2024-11-08T14:01:24.676Z | 2024-11-09T14:16:27.400Z |
5492502 | 5492502 | 20241107084348_VRhKn | USL00G | 2024-11-08T14:01:18.138Z | 2024-11-09T14:16:27.387Z |
5492442 | 5492442 | 20241107083459_dtn8r | USL00G | 2024-11-08T14:01:11.268Z | 2024-11-09T14:16:27.374Z |
5492423 | 5492423 | 20241107083138_TM2YK | USL00G | 2024-11-08T14:01:03.115Z | 2024-11-09T14:16:27.369Z |
5492388 | 5492388 | 20241107082101_flxdQ | USL00G | 2024-11-08T14:00:58.450Z | 2024-11-09T14:16:27.361Z |
5492305 | 5492305 | 20241107080507_8Lpb2 | USL00G | 2024-11-08T14:00:44.505Z | 2024-11-09T14:16:27.340Z |
5492254 | 5492254 | 20241107074719_2kgIg | USL00G | 2024-11-08T14:00:38.418Z | 2024-11-09T14:16:27.329Z |
5492196 | 5492196 | 20241107072533_oZ01p | USL00G | 2024-11-08T14:00:27.092Z | 2024-11-09T14:16:27.310Z |
5492175 | 5492175 | 20241107071933_fWwq4 | USL00G | 2024-11-08T14:00:23.514Z | 2024-11-09T14:16:27.303Z |
5492159 | 5492159 | 20241107071527_nJFn5 | USL00G | 2024-11-08T14:00:21.374Z | 2024-11-09T14:16:27.298Z |
5492146 | 5492146 | 20241107071043_fOB9b | USL00G | 2024-11-08T14:00:19.160Z | 2024-11-09T14:16:27.292Z |
5492135 | 5492135 | 20241107070115_sn7T4 | USL00G | 2024-11-08T14:00:17.561Z | 2024-11-09T14:16:27.288Z |
5491030 | 5491030 | 20241106014034_yIAMc | USL00G | 2024-11-07T14:15:14.140Z | 2024-11-09T14:20:03.234Z |
5471882 | 5471882 | 20241104125516_vSgwX | USL00G | 2024-11-05T14:04:45.400Z | 2024-11-09T14:20:34.491Z |
5471873 | 5471873 | 20241104125314_zx0kH | USL00G | 2024-11-05T14:04:44.684Z | 2024-11-09T14:20:34.385Z |
5471837 | 5471837 | 20241104124924_3AaeK | USL00G | 2024-11-05T14:04:41.332Z | 2024-11-09T14:20:34.124Z |
5471682 | 5471682 | 20241104122547_BKzSB | USL00G | 2024-11-05T14:04:19.960Z | 2024-11-09T14:20:32.725Z |
5471675 | 5471675 | 20241104122307_N4EbZ | USL00G | 2024-11-05T14:04:18.522Z | 2024-11-09T14:20:32.670Z |
5471625 | 5471625 | 20241104121109_TjyF5 | USL00G | 2024-11-05T14:04:06.335Z | 2024-11-09T14:20:32.243Z |
5471574 | 5471574 | 20241104120500_ZhZ1t | USL00G | 2024-11-05T14:03:57.849Z | 2024-11-09T14:20:32.014Z |
5471521 | 5471521 | 20241104115835_BIRML | USL00G | 2024-11-05T14:03:52.399Z | 2024-11-09T14:20:31.620Z |
5471437 | 5471437 | 20241104114423_cRz33 | USL00G | 2024-11-05T14:03:44.025Z | 2024-11-09T14:20:31.111Z |
5471418 | 5471418 | 20241104114320_uvHzp | USL00G | 2024-11-05T14:03:42.712Z | 2024-11-09T14:20:31.000Z |
5471137 | 5471137 | 20241104105118_1RhyF | USL00G | 2024-11-05T14:02:58.024Z | 2024-11-09T14:20:28.753Z |
5471123 | 5471123 | 20241104104833_ZoX2M | USL00G | 2024-11-05T14:02:56.030Z | 2024-11-09T14:20:28.583Z |
5471120 | 5471120 | 20241104104816_ANg7j | USL00G | 2024-11-05T14:02:55.508Z | 2024-11-09T14:20:28.540Z |
5471050 | 5471050 | 20241104104056_E54VW | USL00G | 2024-11-05T14:02:37.620Z | 2024-11-09T14:20:27.930Z |
5470987 | 5470987 | 20241104102426_rnWoH | USL00G | 2024-11-05T14:02:27.090Z | 2024-11-09T14:20:27.147Z |
5470972 | 5470972 | 20241104101817_RMxz0 | USL00G | 2024-11-05T14:02:25.269Z | 2024-11-09T14:20:26.948Z |
5470914 | 5470914 | 20241104100306_3OmHW | USL00G | 2024-11-05T14:02:16.679Z | 2024-11-09T14:20:26.291Z |
5470842 | 5470842 | 20241104095512_8yo53 | USL00G | 2024-11-05T14:02:02.073Z | 2024-11-09T14:20:25.404Z |
5470750 | 5470750 | 20241104093805_Dp3D0 | USL00G | 2024-11-05T14:01:43.851Z | 2024-11-09T14:20:24.135Z |
5470623 | 5470623 | 20241104090601_Gwn6D | USL00G | 2024-11-05T14:01:19.346Z | 2024-11-09T14:20:21.953Z |
5470464 | 5470464 | 20241104081228_k28N8 | USL00G | 2024-11-05T14:00:46.631Z | 2024-11-09T14:20:20.397Z |
5470440 | 5470440 | 20241104080521_JgMAe | USL00G | 2024-11-05T14:00:39.602Z | 2024-11-09T14:20:19.640Z |
5470408 | 5470408 | 20241104075832_rnObM | USL00G | 2024-11-05T14:00:32.889Z | 2024-11-09T14:20:19.363Z |
5470336 | 5470336 | 20241104071821_FFmty | USL00G | 2024-11-05T14:00:18.302Z | 2024-11-09T14:20:18.622Z |
5470324 | 5470324 | 20241104071028_y4o3h | USL00G | 2024-11-05T14:00:15.224Z | 2024-11-09T14:20:18.538Z |
5470300 | 5470300 | 20241104064446_3ZWJE | USL00G | 2024-11-05T14:00:09.978Z | 2024-11-09T14:20:18.001Z |
5470130 | 5470130 | 20241103055242_PjkNF | USL00G | 2024-11-04T14:17:50.005Z | 2024-11-09T14:23:05.605Z |
5469995 | 5469995 | 20241103050435_zwy38 | USL00G | 2024-11-04T14:17:32.347Z | 2024-11-09T14:23:04.601Z |
5469952 | 5469952 | 20241103045011_rUhxH | USL00G | 2024-11-04T14:17:25.120Z | 2024-11-09T14:23:04.408Z |
5469751 | 5469751 | 20241103041303_FBtVS | USL00G | 2024-11-04T14:16:59.247Z | 2024-11-09T14:23:03.738Z |
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);