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

5,794 rows where station_code = "USV002" 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
8691253 8691253 20251205041746_8OpGD USV002 2025-12-06T14:17:02.806Z 2025-12-06T14:18:01.070Z
8691037 8691037 20251205025914_J6U65 USV002 2025-12-06T14:16:19.768Z 2025-12-06T14:18:01.018Z
8690994 8690994 20251205024557_InOiM USV002 2025-12-06T14:16:12.527Z 2025-12-06T14:18:01.006Z
8690881 8690881 20251205020911_2dqa6 USV002 2025-12-06T14:15:45.480Z 2025-12-06T14:18:00.979Z
8688958 8688958 20251205132240_M8sPG USV002 2025-12-06T14:06:29.570Z 2025-12-06T14:06:29.570Z
8688812 8688812 20251205125348_MckDs USV002 2025-12-06T14:05:51.485Z 2025-12-06T14:05:51.485Z
8687583 8687583 20251205074757_ORKmZ USV002 2025-12-06T14:00:51.457Z 2025-12-06T14:00:51.457Z
8682607 8682607 20251203055047_1U23W USV002 2025-12-04T14:17:41.799Z 2025-12-06T14:29:18.054Z
8682432 8682432 20251203053231_VqBy8 USV002 2025-12-04T14:17:10.633Z 2025-12-06T14:29:02.412Z
8682021 8682021 20251203044125_Baa4J USV002 2025-12-04T14:16:11.099Z 2025-12-06T14:28:43.593Z
8681897 8681897 20251203042402_GZ3gs USV002 2025-12-04T14:15:57.976Z 2025-12-06T14:28:39.285Z
8681728 8681728 20251203035120_1UW24 USV002 2025-12-04T14:15:22.048Z 2025-12-06T14:28:27.449Z
8681616 8681616 20251203033157_24LGz USV002 2025-12-04T14:15:09.054Z 2025-12-06T14:28:21.102Z
8681130 8681130 20251203022728_EltJl USV002 2025-12-04T14:13:55.274Z 2025-12-06T14:27:50.620Z
8680972 8680972 20251203020503_aRPlN USV002 2025-12-04T14:13:29.030Z 2025-12-06T14:27:36.028Z
8677895 8677895 20251203130348_8ERQq USV002 2025-12-04T14:02:56.996Z 2025-12-06T14:20:12.402Z
8677862 8677862 20251203124834_EgEMx USV002 2025-12-04T14:02:49.234Z 2025-12-06T14:20:09.516Z
8677542 8677542 20251203103758_ge83s USV002 2025-12-04T14:01:38.952Z 2025-12-06T14:19:37.072Z
8677504 8677504 20251203102816_t2ECS USV002 2025-12-04T14:01:28.080Z 2025-12-06T14:19:33.544Z
8677501 8677501 20251203102709_D4Gvl USV002 2025-12-04T14:01:27.464Z 2025-12-06T14:19:33.374Z
8677481 8677481 20251203101853_utXjD USV002 2025-12-04T14:01:22.485Z 2025-12-06T14:19:31.674Z
8677427 8677427 20251203095253_O755L USV002 2025-12-04T14:01:12.112Z 2025-12-06T14:19:26.451Z
8677404 8677404 20251203093846_rFKY0 USV002 2025-12-04T14:01:03.465Z 2025-12-06T14:19:23.679Z
8677236 8677236 20251203073353_22ydM USV002 2025-12-04T14:00:26.807Z 2025-12-06T14:18:27.572Z
8676546 8676546 20251202060144_QpRS0 USV002 2025-12-03T14:25:18.115Z 2025-12-06T14:35:23.453Z
8676499 8676499 20251202055536_PG4Xn USV002 2025-12-03T14:25:14.851Z 2025-12-06T14:35:22.442Z
8676484 8676484 20251202055507_8Bo3P USV002 2025-12-03T14:25:14.173Z 2025-12-06T14:35:22.252Z
8676357 8676357 20251202054838_aNDD5 USV002 2025-12-03T14:25:08.971Z 2025-12-06T14:35:20.666Z
8675952 8675952 20251202052641_eD92r USV002 2025-12-03T14:24:33.563Z 2025-12-06T14:35:05.723Z
8675657 8675657 20251202050430_mYgpT USV002 2025-12-03T14:23:58.788Z 2025-12-06T14:34:57.694Z
8675503 8675503 20251202045025_2RD3D USV002 2025-12-03T14:23:47.985Z 2025-12-06T14:34:54.829Z
8675136 8675136 20251202040446_NusqN USV002 2025-12-03T14:23:06.252Z 2025-12-06T14:34:32.954Z
8675123 8675123 20251202040302_lo5Zy USV002 2025-12-03T14:23:05.069Z 2025-12-06T14:34:30.041Z
8675006 8675006 20251202035148_TfCm5 USV002 2025-12-03T14:22:50.065Z 2025-12-06T14:34:27.198Z
8674253 8674253 20251202015501_2tCva USV002 2025-12-03T14:21:17.502Z 2025-12-06T14:34:02.538Z
8674130 8674130 20251202013015_OBkzE USV002 2025-12-03T14:20:58.508Z 2025-12-06T14:33:59.174Z
8671695 8671695 20251201124850_iUFKV USV002 2025-12-03T14:13:20.926Z 2025-12-06T14:31:16.327Z
8671643 8671643 20251201124518_iUaSn USV002 2025-12-03T14:13:13.846Z 2025-12-06T14:31:14.527Z
8671601 8671601 20251201123824_JonmA USV002 2025-12-03T14:13:08.592Z 2025-12-06T14:31:12.959Z
8671282 8671282 20251201115124_EtRhm USV002 2025-12-03T14:12:03.536Z 2025-12-06T14:30:50.737Z
8671210 8671210 20251201113523_GL1ZV USV002 2025-12-03T14:11:46.489Z 2025-12-06T14:30:47.451Z
8671069 8671069 20251201111000_e2u9W USV002 2025-12-03T14:11:12.227Z 2025-12-06T14:30:42.253Z
8670999 8670999 20251201110022_sLGmW USV002 2025-12-03T14:11:02.091Z 2025-12-06T14:30:39.153Z
8670991 8670991 20251201105902_gZf0L USV002 2025-12-03T14:11:00.925Z 2025-12-06T14:30:38.803Z
8670952 8670952 20251201105254_ekJQi USV002 2025-12-03T14:10:50.310Z 2025-12-06T14:30:37.951Z
8670837 8670837 20251201102535_OZ2xo USV002 2025-12-03T14:10:29.739Z 2025-12-06T14:30:26.582Z
8670563 8670563 20251201092546_dqhna USV002 2025-12-03T14:09:15.728Z 2025-12-06T14:30:09.431Z
8670529 8670529 20251201091756_ziQ3i USV002 2025-12-03T14:09:06.817Z 2025-12-06T14:30:08.032Z
8669901 8669901 20251202122431_ZnSpz USV002 2025-12-03T14:05:58.480Z 2025-12-06T14:24:25.969Z
8669880 8669880 20251202122029_RclCG USV002 2025-12-03T14:05:54.262Z 2025-12-06T14:24:24.276Z
8669473 8669473 20251202111812_J3692 USV002 2025-12-03T14:04:04.496Z 2025-12-06T14:23:57.045Z
8669273 8669273 20251202104300_rCHcR USV002 2025-12-03T14:03:06.700Z 2025-12-06T14:23:47.031Z
8669210 8669210 20251202103205_3nxum USV002 2025-12-03T14:02:52.219Z 2025-12-06T14:23:40.235Z
8669041 8669041 20251202095608_vrQ0J USV002 2025-12-03T14:02:06.083Z 2025-12-06T14:23:27.696Z
8668755 8668755 20251202085120_13aQR USV002 2025-12-03T14:01:02.799Z 2025-12-06T14:23:08.498Z
8668685 8668685 20251202082137_pPDvN USV002 2025-12-03T14:00:50.116Z 2025-12-06T14:23:03.658Z
8668385 8668385 20251130074857_smex8 USV002 2025-12-02T14:42:22.199Z 2025-12-06T14:50:31.351Z
8668240 8668240 20251130065404_OlqS1 USV002 2025-12-02T14:42:13.902Z 2025-12-06T14:50:28.202Z
8667945 8667945 20251130052302_Toduy USV002 2025-12-02T14:41:22.184Z 2025-12-06T14:49:43.827Z
8667801 8667801 20251130040745_LocMp USV002 2025-12-02T14:40:25.888Z 2025-12-06T14:49:25.457Z
8667792 8667792 20251130040521_LX42C USV002 2025-12-02T14:40:24.199Z 2025-12-06T14:49:24.475Z
8667780 8667780 20251130035618_kiqBo USV002 2025-12-02T14:40:20.863Z 2025-12-06T14:49:08.655Z
8667753 8667753 20251130034548_OQuvJ USV002 2025-12-02T14:40:14.823Z 2025-12-06T14:48:52.014Z
8667745 8667745 20251130034547_gOfOn USV002 2025-12-02T14:40:14.535Z 2025-12-06T14:48:51.997Z
8667662 8667662 20251130031225_O7zjz USV002 2025-12-02T14:39:39.110Z 2025-12-06T14:48:41.359Z
8666919 8666919 20251201072220_NIYXz USV002 2025-12-02T14:30:45.920Z 2025-12-06T14:42:43.517Z
8666917 8666917 20251201072157_439fu USV002 2025-12-02T14:30:45.693Z 2025-12-06T14:42:43.471Z
8666915 8666915 20251201071710_dDapU USV002 2025-12-02T14:30:45.392Z 2025-12-06T14:42:43.402Z
8666905 8666905 20251201070523_AstEi USV002 2025-12-02T14:30:42.515Z 2025-12-06T14:42:42.982Z
8666886 8666886 20251201063547_bQOpr USV002 2025-12-02T14:30:39.448Z 2025-12-06T14:42:42.217Z
8666853 8666853 20251201052749_qSvvi USV002 2025-12-02T14:30:16.746Z 2025-12-06T14:42:20.259Z
8666848 8666848 20251201050215_29blT USV002 2025-12-02T14:29:29.604Z 2025-12-06T14:42:15.553Z
8666840 8666840 20251201043124_0cNX3 USV002 2025-12-02T14:28:17.142Z 2025-12-06T14:42:11.341Z
8666830 8666830 20251201041140_8NNFF USV002 2025-12-02T14:28:12.366Z 2025-12-06T14:42:07.191Z
8666826 8666826 20251201040736_Y7LOQ USV002 2025-12-02T14:28:08.990Z 2025-12-06T14:42:06.246Z
8666810 8666810 20251201035141_f3Xm2 USV002 2025-12-02T14:27:59.967Z 2025-12-06T14:41:46.958Z
8666787 8666787 20251201030029_HBhgL USV002 2025-12-02T14:27:49.991Z 2025-12-06T14:41:32.158Z
8666765 8666765 20251201014932_9ojx3 USV002 2025-12-02T14:27:36.858Z 2025-12-06T14:41:00.921Z
8666759 8666759 20251201013924_vY2Ow USV002 2025-12-02T14:27:31.244Z 2025-12-06T14:40:57.902Z
8660354 8660354 20251130123807_Ddqqe USV002 2025-12-02T14:07:30.203Z 2025-12-06T14:37:01.588Z
8659362 8659362 20251130101458_JIidS USV002 2025-12-02T14:03:37.702Z 2025-12-06T14:36:16.225Z
8659284 8659284 20251130100353_BtXL1 USV002 2025-12-02T14:03:22.823Z 2025-12-06T14:36:13.173Z
8659184 8659184 20251130094220_JhIrO USV002 2025-12-02T14:02:51.297Z 2025-12-06T14:36:09.731Z
8658970 8658970 20251130090816_BrVLH USV002 2025-12-02T14:01:54.167Z 2025-12-06T14:36:00.698Z
8658959 8658959 20251130090609_Lr33D USV002 2025-12-02T14:01:49.640Z 2025-12-06T14:35:59.540Z
8658904 8658904 20251130085435_TAbfc USV002 2025-12-02T14:01:28.750Z 2025-12-06T14:35:51.041Z
8648472 8648472 20251129080423_X9Alo USV002 2025-11-30T14:30:14.586Z 2025-12-06T14:57:44.779Z
8648470 8648470 20251129080419_wCdTB USV002 2025-11-30T14:30:14.435Z 2025-12-06T14:57:44.634Z
8648281 8648281 20251129071854_6jsG3 USV002 2025-11-30T14:30:01.366Z 2025-12-06T14:57:30.474Z
8647838 8647838 20251129054243_6ehbH USV002 2025-11-30T14:29:11.107Z 2025-12-06T14:56:48.958Z
8647239 8647239 20251129041054_aUyjc USV002 2025-11-30T14:27:52.739Z 2025-12-06T14:56:34.364Z
8647023 8647023 20251129032850_UAoxt USV002 2025-11-30T14:27:20.263Z 2025-12-06T14:56:30.009Z
8646372 8646372 20251129015512_PCXJ5 USV002 2025-11-30T14:25:54.756Z 2025-12-06T14:56:02.925Z
8639831 8639831 20251129121050_KW0ke USV002 2025-11-30T14:06:13.422Z 2025-12-06T14:43:51.838Z
8639028 8639028 20251129101750_E0DkE USV002 2025-11-30T14:03:31.986Z 2025-12-06T14:43:08.622Z
8638824 8638824 20251129094824_IQiyt USV002 2025-11-30T14:02:31.963Z 2025-12-06T14:43:01.695Z
8638656 8638656 20251129091902_wzSkS USV002 2025-11-30T14:01:48.985Z 2025-12-06T14:42:57.555Z
8638494 8638494 20251129085707_gbiVj USV002 2025-11-30T14:01:11.319Z 2025-12-06T14:42:52.615Z
8638457 8638457 20251129084916_3S1aR USV002 2025-11-30T14:00:59.119Z 2025-12-06T14:42:51.532Z
8638344 8638344 20251129083013_Kdqy6 USV002 2025-11-30T14:00:35.038Z 2025-12-06T14:42:48.267Z

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