home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

>10,000 rows count all where station_code = "USL00M" sorted by created_at descending

✎ View and edit SQL

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
9611749 9611749 20260405032054_eZDxw USL00M 2026-04-06T12:15:53.797Z 2026-04-06T12:16:14.858Z
9610054 9610054 20260405121338_ZgnVJ USL00M 2026-04-06T12:05:26.430Z 2026-04-06T12:05:26.430Z
9610006 9610006 20260405114912_P2hnO USL00M 2026-04-06T12:05:14.173Z 2026-04-06T12:05:14.173Z
9610003 9610003 20260405114857_fzcEP USL00M 2026-04-06T12:05:13.664Z 2026-04-06T12:05:13.664Z
9609897 9609897 20260405110053_FNtT9 USL00M 2026-04-06T12:04:32.646Z 2026-04-06T12:04:32.646Z
9609845 9609845 20260405102912_32bjq USL00M 2026-04-06T12:04:18.053Z 2026-04-06T12:04:18.053Z
9609839 9609839 20260405102712_Daxos USL00M 2026-04-06T12:04:12.680Z 2026-04-06T12:04:12.680Z
9609783 9609783 20260405095707_kEi7S USL00M 2026-04-06T12:03:51.232Z 2026-04-06T12:03:51.232Z
9609729 9609729 20260405093531_DLMXs USL00M 2026-04-06T12:03:34.892Z 2026-04-06T12:03:34.892Z
9609625 9609625 20260405084106_Y3V9N USL00M 2026-04-06T12:02:57.264Z 2026-04-06T12:02:57.264Z
9609530 9609530 20260405075141_GqtJt USL00M 2026-04-06T12:02:22.437Z 2026-04-06T12:02:22.437Z
9609495 9609495 20260405073217_F3zox USL00M 2026-04-06T12:02:04.394Z 2026-04-06T12:02:04.394Z
9609479 9609479 20260405071656_5lYxo USL00M 2026-04-06T12:01:55.289Z 2026-04-06T12:01:55.289Z
9609464 9609464 20260405065300_Di1Ik USL00M 2026-04-06T12:01:51.326Z 2026-04-06T12:01:51.326Z
9609422 9609422 20260405061019_HI976 USL00M 2026-04-06T12:01:42.407Z 2026-04-06T12:01:42.407Z
9609383 9609383 20260405053931_ChuPW USL00M 2026-04-06T12:01:32.269Z 2026-04-06T12:01:32.269Z
9609372 9609372 20260405051339_xyM05 USL00M 2026-04-06T12:01:30.281Z 2026-04-06T12:01:30.281Z
9609335 9609335 20260405044207_iSLgC USL00M 2026-04-06T12:01:16.908Z 2026-04-06T12:01:16.908Z
9609254 9609254 20260405040414_vmTTg USL00M 2026-04-06T12:00:49.396Z 2026-04-06T12:00:49.396Z
9609171 9609171 20260405035219_OzPZc USL00M 2026-04-06T12:00:32.447Z 2026-04-06T12:00:32.447Z
9609048 9609048 20260402105128_SpSgF USL00M 2026-04-05T12:14:15.431Z 2026-04-06T12:22:10.954Z
9607688 9607688 20260404115234_uDndU USL00M 2026-04-05T12:03:28.866Z 2026-04-06T12:16:14.491Z
9607369 9607369 20260404081119_1Xs2S USL00M 2026-04-05T12:01:52.822Z 2026-04-06T12:16:14.420Z
9607325 9607325 20260404073646_b8QsK USL00M 2026-04-05T12:01:36.850Z 2026-04-06T12:16:14.411Z
9607207 9607207 20260404045638_Kx1We USL00M 2026-04-05T12:00:54.933Z 2026-04-06T12:16:14.384Z
9605790 9605790 20260403120523_VINEA USL00M 2026-04-04T12:03:56.290Z 2026-04-06T12:18:21.436Z
9605718 9605718 20260403114046_NaRSd USL00M 2026-04-04T12:03:34.663Z 2026-04-06T12:18:14.637Z
9605393 9605393 20260403094152_hyN2f USL00M 2026-04-04T12:02:01.835Z 2026-04-06T12:17:46.766Z
9605246 9605246 20260403081338_Lzabp USL00M 2026-04-04T12:01:25.467Z 2026-04-06T12:17:36.964Z
9605090 9605090 20260403061222_j29uZ USL00M 2026-04-04T12:00:41.563Z 2026-04-06T12:16:33.184Z
9603575 9603575 20260402110555_oRbQn USL00M 2026-04-03T12:03:41.907Z 2026-04-06T12:22:14.329Z
9603065 9603065 20260402073203_62MR7 USL00M 2026-04-03T12:01:37.737Z 2026-04-06T12:21:31.516Z
9603054 9603054 20260402072300_UlOc8 USL00M 2026-04-03T12:01:35.537Z 2026-04-06T12:21:30.487Z
9593611 9593611 20260329121000_Mnzm4 USL00M 2026-03-30T12:04:31.761Z 2026-04-06T12:35:30.136Z
9593488 9593488 20260329111344_N1PDP USL00M 2026-03-30T12:04:08.658Z 2026-04-06T12:35:21.712Z
9593415 9593415 20260329102317_QDwn2 USL00M 2026-03-30T12:03:53.188Z 2026-04-06T12:35:17.300Z
9593407 9593407 20260329102221_7slRp USL00M 2026-03-30T12:03:52.172Z 2026-04-06T12:35:16.987Z
9590977 9590977 20260328121003_AYDXl USL00M 2026-03-29T12:03:34.575Z 2026-04-06T12:38:43.408Z
9590786 9590786 20260328111601_3tT3c USL00M 2026-03-29T12:03:17.728Z 2026-04-06T12:38:34.660Z
9590765 9590765 20260328111130_1YlQp USL00M 2026-03-29T12:03:14.297Z 2026-04-06T12:38:33.742Z
9590737 9590737 20260328110101_T1193 USL00M 2026-03-29T12:03:11.724Z 2026-04-06T12:38:32.244Z
9590567 9590567 20260328100508_7RqUx USL00M 2026-03-29T12:02:55.211Z 2026-04-06T12:38:24.451Z
9590331 9590331 20260328081625_vqSts USL00M 2026-03-29T12:02:25.785Z 2026-04-06T12:38:01.565Z
9590256 9590256 20260328075325_s0ygJ USL00M 2026-03-29T12:02:20.128Z 2026-04-06T12:37:58.712Z
9590104 9590104 20260328053710_xQqte USL00M 2026-03-29T12:02:00.890Z 2026-04-06T12:37:50.935Z
9590066 9590066 20260328044242_w9stx USL00M 2026-03-29T12:01:56.496Z 2026-04-06T12:37:48.994Z
9590047 9590047 20260328043643_Mb7qH USL00M 2026-03-29T12:01:54.791Z 2026-04-06T12:37:48.109Z
9587404 9587404 20260327122811_U9Qlt USL00M 2026-03-28T12:05:26.253Z 2026-04-05T12:34:25.205Z
9587388 9587388 20260327122317_vZjr3 USL00M 2026-03-28T12:05:24.692Z 2026-04-05T12:34:24.651Z
9587342 9587342 20260327121129_iJT0f USL00M 2026-03-28T12:05:19.065Z 2026-04-05T12:34:22.679Z
9587229 9587229 20260327114815_fxCKc USL00M 2026-03-28T12:05:04.377Z 2026-04-05T12:34:09.321Z
9587227 9587227 20260327114707_nkHx2 USL00M 2026-03-28T12:05:04.034Z 2026-04-05T12:34:09.167Z
9587155 9587155 20260327112758_127mn USL00M 2026-03-28T12:04:54.592Z 2026-04-05T12:34:04.504Z
9586965 9586965 20260327103341_OeOnt USL00M 2026-03-28T12:04:28.133Z 2026-04-05T12:33:56.468Z
9586842 9586842 20260327095610_6l6I3 USL00M 2026-03-28T12:04:12.506Z 2026-04-05T12:33:51.485Z
9586780 9586780 20260327093256_UEoIZ USL00M 2026-03-28T12:03:59.872Z 2026-04-05T12:33:48.146Z
9586763 9586763 20260327092825_BJNZW USL00M 2026-03-28T12:03:57.028Z 2026-04-05T12:33:47.277Z
9586745 9586745 20260327092313_D3qxJ USL00M 2026-03-28T12:03:54.257Z 2026-04-05T12:33:46.242Z
9586719 9586719 20260327091951_zOX1s USL00M 2026-03-28T12:03:50.510Z 2026-04-05T12:33:39.039Z
9586697 9586697 20260327091335_S5X29 USL00M 2026-03-28T12:03:46.714Z 2026-04-05T12:33:37.747Z
9586522 9586522 20260327080922_AaUg8 USL00M 2026-03-28T12:03:19.511Z 2026-04-05T12:33:28.901Z
9586510 9586510 20260327080411_P3kyD USL00M 2026-03-28T12:03:18.206Z 2026-04-05T12:33:28.505Z
9586413 9586413 20260327071435_vVx09 USL00M 2026-03-28T12:03:01.604Z 2026-04-05T12:33:24.310Z
9586364 9586364 20260327064434_CAmpA USL00M 2026-03-28T12:02:54.249Z 2026-04-05T12:33:22.227Z
9586317 9586317 20260327060705_nLSGj USL00M 2026-03-28T12:02:49.171Z 2026-04-05T12:33:20.523Z
9586308 9586308 20260327060517_u5z8o USL00M 2026-03-28T12:02:47.670Z 2026-04-05T12:33:20.138Z
9586300 9586300 20260327060005_t1yoi USL00M 2026-03-28T12:02:46.805Z 2026-04-05T12:33:19.839Z
9586293 9586293 20260327055455_cqBwX USL00M 2026-03-28T12:02:44.312Z 2026-04-05T12:33:19.357Z
9586233 9586233 20260327050444_94V2d USL00M 2026-03-28T12:02:34.373Z 2026-04-05T12:33:09.267Z
9583298 9583298 20260326121045_wv5yK USL00M 2026-03-27T12:08:18.822Z 2026-04-04T12:41:01.070Z
9583268 9583268 20260326120236_95Z1B USL00M 2026-03-27T12:08:14.108Z 2026-04-04T12:40:59.109Z
9583222 9583222 20260326114336_GIHaj USL00M 2026-03-27T12:08:06.469Z 2026-04-04T12:40:57.221Z
9583142 9583142 20260326112029_ShLH8 USL00M 2026-03-27T12:07:51.526Z 2026-04-04T12:40:53.715Z
9583090 9583090 20260326105217_JGNhx USL00M 2026-03-27T12:07:40.011Z 2026-04-04T12:40:45.273Z
9583078 9583078 20260326105033_NjExG USL00M 2026-03-27T12:07:36.489Z 2026-04-04T12:40:44.493Z
9583064 9583064 20260326104750_ao4tF USL00M 2026-03-27T12:07:34.028Z 2026-04-04T12:40:43.849Z
9582977 9582977 20260326103137_HewVH USL00M 2026-03-27T12:07:22.801Z 2026-04-04T12:40:38.791Z
9582944 9582944 20260326100449_cN0Hs USL00M 2026-03-27T12:07:17.464Z 2026-04-04T12:40:37.180Z
9582834 9582834 20260326094342_rQ3Lm USL00M 2026-03-27T12:06:56.980Z 2026-04-04T12:40:31.037Z
9582801 9582801 20260326093127_HxsIO USL00M 2026-03-27T12:06:50.454Z 2026-04-04T12:40:29.044Z
9582738 9582738 20260326091624_XX3sr USL00M 2026-03-27T12:06:38.423Z 2026-04-04T12:40:26.310Z
9582734 9582734 20260326091611_WAfv5 USL00M 2026-03-27T12:06:38.018Z 2026-04-04T12:40:26.171Z
9582634 9582634 20260326084729_Vww3Z USL00M 2026-03-27T12:06:23.893Z 2026-04-04T12:40:16.425Z
9582628 9582628 20260326084527_S46Jh USL00M 2026-03-27T12:06:22.933Z 2026-04-04T12:40:16.172Z
9582453 9582453 20260326074119_hEW0f USL00M 2026-03-27T12:05:49.268Z 2026-04-04T12:40:01.754Z
9582418 9582418 20260326071955_1GdQj USL00M 2026-03-27T12:05:42.815Z 2026-04-04T12:40:00.181Z
9582384 9582384 20260326071037_Rr1zX USL00M 2026-03-27T12:05:36.051Z 2026-04-04T12:39:58.555Z
9582357 9582357 20260326070149_WAmeO USL00M 2026-03-27T12:05:31.416Z 2026-04-04T12:39:57.642Z
9582247 9582247 20260326054148_2CXes USL00M 2026-03-27T12:05:05.588Z 2026-04-04T12:39:45.043Z
9581404 9581404 20260326030732_DA6g3 USL00M 2026-03-27T12:03:00.184Z 2026-04-04T12:39:03.446Z
9581401 9581401 20260326030657_y16xk USL00M 2026-03-27T12:02:59.432Z 2026-04-04T12:39:03.354Z
9578596 9578596 20260325123147_k8r7q USL00M 2026-03-26T12:08:03.252Z 2026-04-03T12:38:09.894Z
9578428 9578428 20260325114957_nEmoW USL00M 2026-03-26T12:07:36.284Z 2026-04-03T12:38:03.183Z
9578211 9578211 20260325104649_Uyu3S USL00M 2026-03-26T12:07:00.280Z 2026-04-03T12:37:43.425Z
9578168 9578168 20260325103702_9SQHd USL00M 2026-03-26T12:06:53.040Z 2026-04-03T12:37:41.766Z
9578138 9578138 20260325101935_YjHah USL00M 2026-03-26T12:06:49.107Z 2026-04-03T12:37:38.685Z
9578074 9578074 20260325095321_KT894 USL00M 2026-03-26T12:06:41.284Z 2026-04-03T12:37:35.968Z
9577965 9577965 20260325092432_1nuYU USL00M 2026-03-26T12:06:27.398Z 2026-04-03T12:37:32.661Z
9577927 9577927 20260325091556_MYY2Q USL00M 2026-03-26T12:06:21.538Z 2026-04-03T12:37:31.209Z
9577875 9577875 20260325090802_787GF USL00M 2026-03-26T12:06:16.458Z 2026-04-03T12:37:29.732Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network