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

360 rows where station_code = "FR0008" 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
1350501 1350501 20220602013414_C0ddV FR0008 2024-01-05T23:46:41.864Z 2024-01-05T23:46:41.864Z
1348331 1348331 20220601020832_lKOuF FR0008 2024-01-05T23:46:40.032Z 2024-01-05T23:46:40.032Z
1341089 1341089 20220530002440_dS3aK FR0008 2024-01-05T23:46:36.057Z 2024-01-05T23:46:36.057Z
1339630 1339630 20220529010013_ZgmfW FR0008 2024-01-05T23:46:34.214Z 2024-01-05T23:46:34.214Z
840020 840020 20211013032237_omjHY FR0008 2024-01-05T23:37:38.757Z 2024-01-05T23:37:38.757Z
839465 839465 20211013010010_k0gBZ FR0008 2024-01-05T23:37:38.525Z 2024-01-05T23:37:38.525Z
837845 837845 20211012044532_KMNku FR0008 2024-01-05T23:37:36.607Z 2024-01-05T23:37:36.607Z
837743 837743 20211012041612_Zzp2b FR0008 2024-01-05T23:37:36.596Z 2024-01-05T23:37:36.596Z
837731 837731 20211012041051_1KpYT FR0008 2024-01-05T23:37:36.594Z 2024-01-05T23:37:36.594Z
837722 837722 20211012040754_XV3xx FR0008 2024-01-05T23:37:36.593Z 2024-01-05T23:37:36.593Z
837285 837285 20211012020802_ZzCHc FR0008 2024-01-05T23:37:36.532Z 2024-01-05T23:37:36.532Z
837260 837260 20211012020121_L6djg FR0008 2024-01-05T23:37:36.528Z 2024-01-05T23:37:36.528Z
837152 837152 20211012013303_q8fEH FR0008 2024-01-05T23:37:36.512Z 2024-01-05T23:37:36.512Z
837037 837037 20211012010539_l7bop FR0008 2024-01-05T23:37:36.497Z 2024-01-05T23:37:36.497Z
836567 836567 20211011224638_wC8o6 FR0008 2024-01-05T23:37:36.425Z 2024-01-05T23:37:36.425Z
836071 836071 20211011185155_bF9gf FR0008 2024-01-05T23:37:36.356Z 2024-01-05T23:37:36.356Z
831588 831588 20211010195711_6jqAA FR0008 2024-01-05T23:37:34.488Z 2024-01-05T23:37:34.488Z
831532 831532 20211010192447_1xBJb FR0008 2024-01-05T23:37:34.480Z 2024-01-05T23:37:34.480Z
828908 828908 20211009223250_fDES7 FR0008 2024-01-05T23:37:32.868Z 2024-01-05T23:37:32.868Z
828799 828799 20211009214246_JIU0X FR0008 2024-01-05T23:37:32.850Z 2024-01-05T23:37:32.850Z
828724 828724 20211009203759_TDuGC FR0008 2024-01-05T23:37:32.837Z 2024-01-05T23:37:32.837Z
828643 828643 20211009194504_AmQDJ FR0008 2024-01-05T23:37:32.824Z 2024-01-05T23:37:32.824Z
827643 827643 20211009044626_FLwZj FR0008 2024-01-05T23:37:31.377Z 2024-01-05T23:37:31.377Z
827361 827361 20211009031514_Q7w3H FR0008 2024-01-05T23:37:31.340Z 2024-01-05T23:37:31.340Z
827285 827285 20211009025428_ojzYR FR0008 2024-01-05T23:37:31.330Z 2024-01-05T23:37:31.330Z
795799 795799 20210922202517_T8u13 FR0008 2024-01-05T23:37:07.586Z 2024-01-05T23:37:07.586Z
779319 779319 20210913032809_rliW6 FR0008 2024-01-05T23:36:54.047Z 2024-01-05T23:36:54.047Z
775712 775712 20210911233952_1PlCE FR0008 2024-01-05T23:36:52.335Z 2024-01-05T23:36:52.335Z
765509 765509 20210908030650_9R2qD FR0008 2024-01-05T23:36:45.826Z 2024-01-05T23:36:45.826Z
764015 764015 20210907225321_EMSTD FR0008 2024-01-05T23:36:45.652Z 2024-01-05T23:36:45.652Z
747544 747544 20210902033416_WD487 FR0008 2024-01-05T23:36:35.951Z 2024-01-05T23:36:35.951Z
747297 747297 20210902022349_UCZAE FR0008 2024-01-05T23:36:35.885Z 2024-01-05T23:36:35.885Z
747262 747262 20210902021331_Kj6g4 FR0008 2024-01-05T23:36:35.876Z 2024-01-05T23:36:35.876Z
747251 747251 20210902021125_JvaGX FR0008 2024-01-05T23:36:35.873Z 2024-01-05T23:36:35.873Z
746849 746849 20210902003315_wj3K3 FR0008 2024-01-05T23:36:35.774Z 2024-01-05T23:36:35.774Z
746592 746592 20210901233415_gziL8 FR0008 2024-01-05T23:36:35.694Z 2024-01-05T23:36:35.694Z
746483 746483 20210901231256_HUiMN FR0008 2024-01-05T23:36:35.662Z 2024-01-05T23:36:35.662Z
745426 745426 20210901015419_raI4y FR0008 2024-01-05T23:36:33.672Z 2024-01-05T23:36:33.672Z
744949 744949 20210831224709_NPG21 FR0008 2024-01-05T23:36:33.503Z 2024-01-05T23:36:33.503Z
744623 744623 20210831195816_X39h7 FR0008 2024-01-05T23:36:33.422Z 2024-01-05T23:36:33.422Z
739859 739859 20210828015259_0nn3P FR0008 2024-01-05T23:36:25.232Z 2024-01-05T23:36:25.232Z
739800 739800 20210828013910_kE32d FR0008 2024-01-05T23:36:25.224Z 2024-01-05T23:36:25.224Z
739660 739660 20210828002901_CpQkU FR0008 2024-01-05T23:36:25.204Z 2024-01-05T23:36:25.204Z
739573 739573 20210828000319_sdOXS FR0008 2024-01-05T23:36:25.192Z 2024-01-05T23:36:25.192Z
739334 739334 20210827230133_Pvw9I FR0008 2024-01-05T23:36:25.160Z 2024-01-05T23:36:25.160Z
739222 739222 20210827222125_DhKJ0 FR0008 2024-01-05T23:36:25.143Z 2024-01-05T23:36:25.143Z
738993 738993 20210827204428_Y6OLi FR0008 2024-01-05T23:36:25.109Z 2024-01-05T23:36:25.109Z
738995 738995 20210827204448_gCbIt FR0008 2024-01-05T23:36:25.109Z 2024-01-05T23:36:25.109Z
738986 738986 20210827204111_O25AT FR0008 2024-01-05T23:36:25.108Z 2024-01-05T23:36:25.108Z
736036 736036 20210825233628_LvpPm FR0008 2024-01-05T23:36:22.416Z 2024-01-05T23:36:22.416Z
736038 736038 20210825233628_ovvOJ FR0008 2024-01-05T23:36:22.416Z 2024-01-05T23:36:22.416Z
734325 734325 20210825010845_Rd1H1 FR0008 2024-01-05T23:36:20.988Z 2024-01-05T23:36:20.988Z
734260 734260 20210825000836_Iy8LZ FR0008 2024-01-05T23:36:20.978Z 2024-01-05T23:36:20.978Z
734063 734063 20210824215455_Z1Fed FR0008 2024-01-05T23:36:20.947Z 2024-01-05T23:36:20.947Z
733889 733889 20210824200212_3oxWz FR0008 2024-01-05T23:36:20.920Z 2024-01-05T23:36:20.920Z
720278 720278 20210815210654_US1VZ FR0008 2024-01-05T23:35:49.104Z 2024-01-05T23:35:49.104Z
717815 717815 20210815025148_3HZcf FR0008 2024-01-05T23:35:48.456Z 2024-01-05T23:35:48.456Z
717801 717801 20210815024601_wFUSc FR0008 2024-01-05T23:35:48.453Z 2024-01-05T23:35:48.453Z
717492 717492 20210815020351_HrNFL FR0008 2024-01-05T23:35:48.412Z 2024-01-05T23:35:48.412Z
717301 717301 20210815014632_PnMJN FR0008 2024-01-05T23:35:48.388Z 2024-01-05T23:35:48.388Z
716954 716954 20210815011729_scS3j FR0008 2024-01-05T23:35:48.347Z 2024-01-05T23:35:48.347Z
716182 716182 20210814234637_vdBie FR0008 2024-01-05T23:35:48.248Z 2024-01-05T23:35:48.248Z
715420 715420 20210814222410_yVohc FR0008 2024-01-05T23:35:48.159Z 2024-01-05T23:35:48.159Z
715158 715158 20210814214429_iSfwK FR0008 2024-01-05T23:35:48.127Z 2024-01-05T23:35:48.127Z
703812 703812 20210813023733_L3jm0 FR0008 2024-01-05T23:35:41.989Z 2024-01-05T23:35:41.989Z
703566 703566 20210813021914_Odrcc FR0008 2024-01-05T23:35:41.881Z 2024-01-05T23:35:41.881Z
703252 703252 20210813020046_ewRj6 FR0008 2024-01-05T23:35:41.840Z 2024-01-05T23:35:41.840Z
703114 703114 20210813015509_kSZP4 FR0008 2024-01-05T23:35:41.824Z 2024-01-05T23:35:41.824Z
701943 701943 20210813005636_mod0N FR0008 2024-01-05T23:35:41.684Z 2024-01-05T23:35:41.684Z
701397 701397 20210813003138_bsuGO FR0008 2024-01-05T23:35:41.617Z 2024-01-05T23:35:41.617Z
701347 701347 20210813002956_UuloF FR0008 2024-01-05T23:35:41.611Z 2024-01-05T23:35:41.611Z
701329 701329 20210813002925_NdsBO FR0008 2024-01-05T23:35:41.609Z 2024-01-05T23:35:41.609Z
700403 700403 20210812235339_zU4XF FR0008 2024-01-05T23:35:41.505Z 2024-01-05T23:35:41.505Z
700162 700162 20210812234725_1uh1e FR0008 2024-01-05T23:35:41.479Z 2024-01-05T23:35:41.479Z
700129 700129 20210812234559_ouclY FR0008 2024-01-05T23:35:41.475Z 2024-01-05T23:35:41.475Z
699703 699703 20210812233151_gHzvR FR0008 2024-01-05T23:35:41.428Z 2024-01-05T23:35:41.428Z
699668 699668 20210812233004_OCRv8 FR0008 2024-01-05T23:35:41.423Z 2024-01-05T23:35:41.423Z
699663 699663 20210812232959_5GjSa FR0008 2024-01-05T23:35:41.422Z 2024-01-05T23:35:41.422Z
699525 699525 20210812232355_gxWwE FR0008 2024-01-05T23:35:41.407Z 2024-01-05T23:35:41.407Z
698628 698628 20210812224915_TmIg5 FR0008 2024-01-05T23:35:41.309Z 2024-01-05T23:35:41.309Z
698576 698576 20210812224702_0Xz5V FR0008 2024-01-05T23:35:41.304Z 2024-01-05T23:35:41.304Z
698313 698313 20210812223739_NmW3W FR0008 2024-01-05T23:35:41.276Z 2024-01-05T23:35:41.276Z
696910 696910 20210812213121_ytBzA FR0008 2024-01-05T23:35:41.115Z 2024-01-05T23:35:41.115Z
694255 694255 20210812023032_hod3s FR0008 2024-01-05T23:35:38.664Z 2024-01-05T23:35:38.664Z
694257 694257 20210812023052_u8z0S FR0008 2024-01-05T23:35:38.664Z 2024-01-05T23:35:38.664Z
693527 693527 20210812013321_9OaWQ FR0008 2024-01-05T23:35:38.581Z 2024-01-05T23:35:38.581Z
693409 693409 20210812012342_FK1PO FR0008 2024-01-05T23:35:38.568Z 2024-01-05T23:35:38.568Z
693277 693277 20210812011424_iDaqo FR0008 2024-01-05T23:35:38.552Z 2024-01-05T23:35:38.552Z
692042 692042 20210811233900_fqPPX FR0008 2024-01-05T23:35:38.388Z 2024-01-05T23:35:38.388Z
691515 691515 20210811230547_gbkj9 FR0008 2024-01-05T23:35:38.328Z 2024-01-05T23:35:38.328Z
689277 689277 20210811031822_0591x FR0008 2024-01-05T23:35:36.144Z 2024-01-05T23:35:36.144Z
684132 684132 20210809235445_3H2L3 FR0008 2024-01-05T23:35:33.997Z 2024-01-05T23:35:33.997Z
683899 683899 20210809231428_YNeay FR0008 2024-01-05T23:35:33.963Z 2024-01-05T23:35:33.963Z
683758 683758 20210809224713_VRefl FR0008 2024-01-05T23:35:33.943Z 2024-01-05T23:35:33.943Z
683660 683660 20210809222838_8kjZe FR0008 2024-01-05T23:35:33.931Z 2024-01-05T23:35:33.931Z
683648 683648 20210809222608_nEPZS FR0008 2024-01-05T23:35:33.929Z 2024-01-05T23:35:33.929Z
683430 683430 20210809214506_7lq3w FR0008 2024-01-05T23:35:33.901Z 2024-01-05T23:35:33.901Z
683149 683149 20210809205348_fJZ6j FR0008 2024-01-05T23:35:33.867Z 2024-01-05T23:35:33.867Z
678031 678031 20210807224219_4XFhY FR0008 2024-01-05T23:35:30.222Z 2024-01-05T23:35:30.222Z
657858 657858 20210730214747_r6pnI FR0008 2024-01-05T23:35:15.708Z 2024-01-05T23:35:15.708Z

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