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 = "USL001" 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
8133373 8133373 20251018025137_Ix7Qy USL001 2025-10-19T12:13:02.261Z 2025-10-26T13:15:42.273Z
8132983 8132983 20251018021824_dfnZR USL001 2025-10-19T12:12:04.513Z 2025-10-26T13:15:38.274Z
7806173 7806173 20250911051907_tnNuR USL001 2025-09-12T12:09:18.461Z 2025-09-19T12:57:17.957Z
7800617 7800617 20250910042325_2NB96 USL001 2025-09-11T12:09:23.775Z 2025-09-18T12:59:36.888Z
7800422 7800422 20250910032311_IoQYh USL001 2025-09-11T12:08:37.424Z 2025-09-18T12:59:33.575Z
7797393 7797393 20250909101504_H3KvP USL001 2025-09-10T12:13:03.854Z 2025-09-17T12:57:08.931Z
7796643 7796643 20250909051723_XGB3Z USL001 2025-09-10T12:10:20.693Z 2025-09-17T12:56:55.328Z
7781435 7781435 20250906114603_odq3u USL001 2025-09-07T12:16:17.804Z 2025-09-14T12:51:01.244Z
7781350 7781350 20250906110510_Y8Shx USL001 2025-09-07T12:15:54.981Z 2025-09-14T12:50:52.968Z
7773821 7773821 20250905031241_bc1Ua USL001 2025-09-06T13:18:10.605Z 2025-09-13T12:58:07.842Z
7733600 7733600 20250901114247_imY5A USL001 2025-09-02T12:33:19.157Z 2025-09-09T12:49:46.326Z
7733583 7733583 20250901113958_nmwcF USL001 2025-09-02T12:33:18.756Z 2025-09-09T12:49:41.492Z
7733557 7733557 20250901113551_WLp29 USL001 2025-09-02T12:33:17.848Z 2025-09-09T12:49:40.732Z
7733425 7733425 20250901110636_BazhM USL001 2025-09-02T12:32:49.555Z 2025-09-09T12:49:28.225Z
7733254 7733254 20250901102509_oHlLz USL001 2025-09-02T12:32:19.246Z 2025-09-09T12:49:11.135Z
7733136 7733136 20250901100441_snFy9 USL001 2025-09-02T12:32:12.084Z 2025-09-09T12:49:07.973Z
7733017 7733017 20250901094209_pPNHM USL001 2025-09-02T12:32:06.745Z 2025-09-09T12:49:05.237Z
7733010 7733010 20250901094010_bZE4t USL001 2025-09-02T12:32:06.447Z 2025-09-09T12:49:05.150Z
7732625 7732625 20250901082019_Gl0a3 USL001 2025-09-02T12:31:33.789Z 2025-09-09T12:49:02.255Z
7732435 7732435 20250901074029_HvdxN USL001 2025-09-02T12:30:59.808Z 2025-09-09T12:48:59.976Z
7732392 7732392 20250901072705_8XbBn USL001 2025-09-02T12:30:55.131Z 2025-09-09T12:48:57.761Z
7732261 7732261 20250901065346_vFKR6 USL001 2025-09-02T12:30:47.550Z 2025-09-09T12:48:54.715Z
7732222 7732222 20250901064300_bICJy USL001 2025-09-02T12:30:45.533Z 2025-09-09T12:48:53.516Z
7732033 7732033 20250901060547_BGw9R USL001 2025-09-02T12:30:34.844Z 2025-09-09T12:48:52.293Z
7720406 7720406 20250830095510_X2X7J USL001 2025-09-01T12:40:08.554Z 2025-09-07T12:59:22.979Z
7720362 7720362 20250830094534_ehmv7 USL001 2025-09-01T12:40:06.377Z 2025-09-07T12:59:22.843Z
7720296 7720296 20250830093412_q5fUr USL001 2025-09-01T12:40:01.690Z 2025-09-07T12:59:22.464Z
7720114 7720114 20250830085456_dikiQ USL001 2025-09-01T12:39:40.556Z 2025-09-07T12:59:21.147Z
7720017 7720017 20250830083428_8ukx3 USL001 2025-09-01T12:39:20.374Z 2025-09-07T12:59:20.498Z
7719812 7719812 20250830074125_xAj6M USL001 2025-09-01T12:38:49.141Z 2025-09-07T12:59:19.021Z
7719697 7719697 20250830071731_PB3TK USL001 2025-09-01T12:38:41.863Z 2025-09-07T12:59:18.347Z
7719653 7719653 20250830070516_ETtqC USL001 2025-09-01T12:38:38.376Z 2025-09-07T12:59:17.823Z
7719623 7719623 20250830065509_2VdNn USL001 2025-09-01T12:38:36.314Z 2025-09-07T12:59:17.537Z
7719611 7719611 20250830065430_lgBlN USL001 2025-09-01T12:38:33.526Z 2025-09-07T12:59:17.437Z
7719523 7719523 20250830064409_XaiQn USL001 2025-09-01T12:38:17.111Z 2025-09-07T12:59:15.604Z
7719249 7719249 20250830052949_jXvHM USL001 2025-09-01T12:37:55.419Z 2025-09-07T12:59:10.018Z
7719058 7719058 20250830040907_8IlwI USL001 2025-09-01T12:37:46.184Z 2025-09-07T12:59:05.779Z
7719049 7719049 20250830040519_057Ee USL001 2025-09-01T12:37:45.808Z 2025-09-07T12:59:03.863Z
7686863 7686863 20250827055032_yXLDw USL001 2025-08-29T12:39:32.360Z 2025-09-04T12:56:54.755Z
7686861 7686861 20250827054519_3LHME USL001 2025-08-29T12:39:32.069Z 2025-09-04T12:56:53.998Z
7686859 7686859 20250827054143_o5EPb USL001 2025-08-29T12:39:32.011Z 2025-09-04T12:56:53.993Z
7686827 7686827 20250827041537_po6oV USL001 2025-08-29T12:39:28.855Z 2025-09-04T12:56:49.467Z
7686822 7686822 20250827040113_ADckN USL001 2025-08-29T12:39:28.493Z 2025-09-04T12:56:49.359Z
7594949 7594949 20250820115115_b2CAU USL001 2025-08-22T12:11:52.010Z 2025-08-29T12:55:55.040Z
7594588 7594588 20250820112219_pKQdR USL001 2025-08-22T12:11:02.936Z 2025-08-29T12:55:49.399Z
7594554 7594554 20250820112033_52B09 USL001 2025-08-22T12:11:00.248Z 2025-08-29T12:55:49.290Z
7594125 7594125 20250820102920_7gpXR USL001 2025-08-22T12:09:48.291Z 2025-08-29T12:55:45.568Z
7594026 7594026 20250820101853_vI322 USL001 2025-08-22T12:09:37.290Z 2025-08-29T12:55:44.278Z
7592885 7592885 20250820063510_xaFEP USL001 2025-08-22T12:05:55.349Z 2025-08-29T12:55:24.038Z
7592826 7592826 20250820052524_tjqqM USL001 2025-08-22T12:05:38.228Z 2025-08-29T12:55:22.493Z
7592796 7592796 20250820045800_jsV8n USL001 2025-08-22T12:05:25.647Z 2025-08-29T12:55:22.150Z
7579307 7579307 20250819115302_sANd7 USL001 2025-08-21T12:10:59.666Z 2025-08-28T12:52:07.112Z
7579284 7579284 20250819115025_ji579 USL001 2025-08-21T12:10:57.130Z 2025-08-28T12:52:06.962Z
7579134 7579134 20250819111628_dOfIS USL001 2025-08-21T12:10:29.098Z 2025-08-28T12:52:03.663Z
7579127 7579127 20250819111442_J4MMH USL001 2025-08-21T12:10:28.282Z 2025-08-28T12:52:03.651Z
7579036 7579036 20250819105707_KuLLr USL001 2025-08-21T12:10:14.690Z 2025-08-28T12:52:01.740Z
7578991 7578991 20250819104848_W2fhN USL001 2025-08-21T12:10:08.769Z 2025-08-28T12:52:01.428Z
7578953 7578953 20250819103903_rJhdu USL001 2025-08-21T12:09:54.801Z 2025-08-28T12:52:01.104Z
7578906 7578906 20250819102712_B5OCa USL001 2025-08-21T12:09:46.144Z 2025-08-28T12:52:00.263Z
7578758 7578758 20250819095802_HV46A USL001 2025-08-21T12:09:18.664Z 2025-08-28T12:51:58.835Z
7578677 7578677 20250819094224_xbG8y USL001 2025-08-21T12:09:05.209Z 2025-08-28T12:51:58.216Z
7578632 7578632 20250819093517_LUr6t USL001 2025-08-21T12:08:59.300Z 2025-08-28T12:51:57.936Z
7578430 7578430 20250819084343_nhmj6 USL001 2025-08-21T12:08:19.948Z 2025-08-28T12:51:56.499Z
7578305 7578305 20250819081624_eHYki USL001 2025-08-21T12:07:51.325Z 2025-08-28T12:51:55.487Z
7577917 7577917 20250819060339_0fKiO USL001 2025-08-21T12:06:16.033Z 2025-08-28T12:51:48.133Z
7577876 7577876 20250819054842_3tBti USL001 2025-08-21T12:06:09.205Z 2025-08-28T12:51:47.897Z
7577830 7577830 20250819053418_EPzHx USL001 2025-08-21T12:06:02.259Z 2025-08-28T12:51:47.570Z
7577813 7577813 20250819052012_2iX3d USL001 2025-08-21T12:06:00.437Z 2025-08-28T12:51:47.421Z
7577780 7577780 20250819050353_x8awE USL001 2025-08-21T12:05:52.966Z 2025-08-28T12:51:47.239Z
7577730 7577730 20250819044316_pEzq8 USL001 2025-08-21T12:05:35.248Z 2025-08-28T12:51:44.995Z
7577692 7577692 20250819042710_N1eVm USL001 2025-08-21T12:05:28.232Z 2025-08-28T12:51:44.760Z
7555172 7555172 20250817044645_M3L4Q USL001 2025-08-19T12:25:45.458Z 2025-08-25T12:51:49.353Z
7555134 7555134 20250817043119_MvJ8Y USL001 2025-08-19T12:25:36.090Z 2025-08-25T12:51:49.183Z
7555092 7555092 20250817041737_sLOoM USL001 2025-08-19T12:25:27.631Z 2025-08-25T12:51:49.010Z
7555070 7555070 20250817041136_U7ZwS USL001 2025-08-19T12:25:14.942Z 2025-08-25T12:51:48.908Z
7490829 7490829 20250813073451_ZeN24 USL001 2025-08-15T12:57:01.384Z 2025-08-21T12:47:58.620Z
7490748 7490748 20250813072332_8HeoN USL001 2025-08-15T12:56:41.888Z 2025-08-21T12:47:58.287Z
7490137 7490137 20250813054407_iSdTq USL001 2025-08-15T12:56:06.688Z 2025-08-21T12:47:51.701Z
7427158 7427158 20250810115321_nqRmT USL001 2025-08-11T12:19:55.831Z 2025-08-18T13:48:35.406Z
7427129 7427129 20250810114507_E5Yag USL001 2025-08-11T12:19:54.058Z 2025-08-18T13:48:33.993Z
7427116 7427116 20250810114043_6K3Q7 USL001 2025-08-11T12:19:53.117Z 2025-08-18T13:48:31.714Z
7427110 7427110 20250810113832_5IJNw USL001 2025-08-11T12:19:52.618Z 2025-08-18T13:48:31.349Z
7427073 7427073 20250810113054_KrmEP USL001 2025-08-11T12:19:50.904Z 2025-08-18T13:48:29.510Z
7427047 7427047 20250810112029_HAv0y USL001 2025-08-11T12:19:47.491Z 2025-08-18T13:48:28.832Z
7427029 7427029 20250810111707_yK5bO USL001 2025-08-11T12:19:39.741Z 2025-08-18T13:48:28.468Z
7426935 7426935 20250810105520_lfqET USL001 2025-08-11T12:19:20.735Z 2025-08-18T13:48:26.888Z
7426914 7426914 20250810104744_le49b USL001 2025-08-11T12:19:19.328Z 2025-08-18T13:48:26.310Z
7426907 7426907 20250810104702_e3CtX USL001 2025-08-11T12:19:18.474Z 2025-08-18T13:48:26.289Z
7426904 7426904 20250810104633_vwfWn USL001 2025-08-11T12:19:18.377Z 2025-08-18T13:48:26.278Z
7426879 7426879 20250810103430_gwg6i USL001 2025-08-11T12:19:15.735Z 2025-08-18T13:48:25.736Z
7426870 7426870 20250810103154_ZmkXv USL001 2025-08-11T12:19:14.671Z 2025-08-18T13:48:25.615Z
7426834 7426834 20250810102103_jByVG USL001 2025-08-11T12:19:12.635Z 2025-08-18T13:48:25.111Z
7426755 7426755 20250810094451_IUpwN USL001 2025-08-11T12:19:08.303Z 2025-08-18T13:48:23.664Z
7426589 7426589 20250810090100_AkyV7 USL001 2025-08-11T12:18:59.050Z 2025-08-18T13:48:17.003Z
7426485 7426485 20250810084454_7B558 USL001 2025-08-11T12:18:33.151Z 2025-08-18T13:48:13.095Z
7426478 7426478 20250810084415_PJJ5c USL001 2025-08-11T12:18:32.171Z 2025-08-18T13:48:12.607Z
7426351 7426351 20250810081018_Krw6y USL001 2025-08-11T12:18:17.268Z 2025-08-18T13:48:05.683Z
7426144 7426144 20250810071425_sVnwK USL001 2025-08-11T12:17:58.538Z 2025-08-18T13:47:50.230Z
7426104 7426104 20250810070617_y3W3b USL001 2025-08-11T12:17:34.965Z 2025-08-18T13:47:48.594Z
7425830 7425830 20250810054349_Iq7WP USL001 2025-08-11T12:17:10.132Z 2025-08-18T13:47:44.679Z

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