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

1,160 rows where station_code = "IT0003" 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
2900253 2900253 20230826025454_Uumjo IT0003 2024-01-06T00:01:15.738Z 2024-01-06T00:01:15.738Z
2899821 2899821 20230826020950_4Zy3D IT0003 2024-01-06T00:01:15.700Z 2024-01-06T00:01:15.700Z
2899023 2899023 20230826010953_Eitt8 IT0003 2024-01-06T00:01:15.635Z 2024-01-06T00:01:15.635Z
2898821 2898821 20230826004910_uIClE IT0003 2024-01-06T00:01:15.616Z 2024-01-06T00:01:15.616Z
2898748 2898748 20230826004030_hkb0W IT0003 2024-01-06T00:01:15.610Z 2024-01-06T00:01:15.610Z
2898580 2898580 20230826002942_VrP4H IT0003 2024-01-06T00:01:15.598Z 2024-01-06T00:01:15.598Z
2898539 2898539 20230826002406_G3kYw IT0003 2024-01-06T00:01:15.595Z 2024-01-06T00:01:15.595Z
2898514 2898514 20230826002127_2Vp9l IT0003 2024-01-06T00:01:15.592Z 2024-01-06T00:01:15.592Z
2898485 2898485 20230826001843_pc3Hx IT0003 2024-01-06T00:01:15.589Z 2024-01-06T00:01:15.589Z
2897495 2897495 20230825221942_aQXBr IT0003 2024-01-06T00:01:15.502Z 2024-01-06T00:01:15.502Z
2897216 2897216 20230825212501_rt2uz IT0003 2024-01-06T00:01:15.472Z 2024-01-06T00:01:15.472Z
2894888 2894888 20230825030353_dGRIC IT0003 2024-01-06T00:01:13.938Z 2024-01-06T00:01:13.938Z
2894531 2894531 20230825021820_ZFmM3 IT0003 2024-01-06T00:01:13.905Z 2024-01-06T00:01:13.905Z
2893327 2893327 20230825003309_2z1kb IT0003 2024-01-06T00:01:13.806Z 2024-01-06T00:01:13.806Z
2892951 2892951 20230825000438_cenhc IT0003 2024-01-06T00:01:13.776Z 2024-01-06T00:01:13.776Z
2889093 2889093 20230824032211_5kf3l IT0003 2024-01-06T00:01:12.033Z 2024-01-06T00:01:12.033Z
2888300 2888300 20230824011120_V0Cay IT0003 2024-01-06T00:01:11.934Z 2024-01-06T00:01:11.934Z
2888291 2888291 20230824010925_FY186 IT0003 2024-01-06T00:01:11.933Z 2024-01-06T00:01:11.933Z
2888196 2888196 20230824005719_7j2dG IT0003 2024-01-06T00:01:11.922Z 2024-01-06T00:01:11.922Z
2888147 2888147 20230824005231_TFHvh IT0003 2024-01-06T00:01:11.917Z 2024-01-06T00:01:11.917Z
2887736 2887736 20230823235958_FhXFj IT0003 2024-01-06T00:01:11.869Z 2024-01-06T00:01:11.869Z
2887035 2887035 20230823224637_jEtSE IT0003 2024-01-06T00:01:11.810Z 2024-01-06T00:01:11.810Z
2886790 2886790 20230823220123_Amv87 IT0003 2024-01-06T00:01:11.786Z 2024-01-06T00:01:11.786Z
2886564 2886564 20230823212312_N8ENd IT0003 2024-01-06T00:01:11.764Z 2024-01-06T00:01:11.764Z
2883760 2883760 20230823024148_sZ4c6 IT0003 2024-01-06T00:01:10.145Z 2024-01-06T00:01:10.145Z
2882384 2882384 20230823011755_NwTbm IT0003 2024-01-06T00:01:10.010Z 2024-01-06T00:01:10.010Z
2882263 2882263 20230823011220_3eVUr IT0003 2024-01-06T00:01:10.001Z 2024-01-06T00:01:10.001Z
2881847 2881847 20230823004934_oG2UT IT0003 2024-01-06T00:01:09.963Z 2024-01-06T00:01:09.963Z
2881613 2881613 20230823003644_HYYVI IT0003 2024-01-06T00:01:09.942Z 2024-01-06T00:01:09.942Z
2881599 2881599 20230823003638_DIpl2 IT0003 2024-01-06T00:01:09.941Z 2024-01-06T00:01:09.941Z
2881572 2881572 20230823003606_PXovX IT0003 2024-01-06T00:01:09.939Z 2024-01-06T00:01:09.939Z
2881516 2881516 20230823003133_72QN3 IT0003 2024-01-06T00:01:09.933Z 2024-01-06T00:01:09.933Z
2880424 2880424 20230822224610_GkQHK IT0003 2024-01-06T00:01:09.818Z 2024-01-06T00:01:09.818Z
2879042 2879042 20230822195339_RrTAC IT0003 2024-01-06T00:01:09.689Z 2024-01-06T00:01:09.689Z
2878998 2878998 20230822193613_1sJhP IT0003 2024-01-06T00:01:09.683Z 2024-01-06T00:01:09.683Z
2876654 2876654 20230822030224_vdAhH IT0003 2024-01-06T00:01:08.089Z 2024-01-06T00:01:08.089Z
2876632 2876632 20230822025700_8Vano IT0003 2024-01-06T00:01:08.087Z 2024-01-06T00:01:08.087Z
2876552 2876552 20230822024752_29l3Z IT0003 2024-01-06T00:01:08.079Z 2024-01-06T00:01:08.079Z
2875007 2875007 20230822004123_bnh2j IT0003 2024-01-06T00:01:07.918Z 2024-01-06T00:01:07.918Z
2874551 2874551 20230822001026_Fq36q IT0003 2024-01-06T00:01:07.873Z 2024-01-06T00:01:07.873Z
2874525 2874525 20230822000830_fii2v IT0003 2024-01-06T00:01:07.871Z 2024-01-06T00:01:07.871Z
2874402 2874402 20230821235543_E5Lhy IT0003 2024-01-06T00:01:07.857Z 2024-01-06T00:01:07.857Z
2873942 2873942 20230821231251_1ut32 IT0003 2024-01-06T00:01:07.810Z 2024-01-06T00:01:07.810Z
2873577 2873577 20230821224002_styit IT0003 2024-01-06T00:01:07.772Z 2024-01-06T00:01:07.772Z
2873331 2873331 20230821221940_oYF2o IT0003 2024-01-06T00:01:07.748Z 2024-01-06T00:01:07.748Z
2873174 2873174 20230821220357_xLpKV IT0003 2024-01-06T00:01:07.735Z 2024-01-06T00:01:07.735Z
2873123 2873123 20230821220033_dyo2l IT0003 2024-01-06T00:01:07.730Z 2024-01-06T00:01:07.730Z
2873060 2873060 20230821214959_58KBM IT0003 2024-01-06T00:01:07.723Z 2024-01-06T00:01:07.723Z
2872311 2872311 20230821194018_TLQ6K IT0003 2024-01-06T00:01:07.633Z 2024-01-06T00:01:07.633Z
2869459 2869459 20230821031057_u3fp0 IT0003 2024-01-06T00:01:06.010Z 2024-01-06T00:01:06.010Z
2868885 2868885 20230821022617_SKIJv IT0003 2024-01-06T00:01:05.961Z 2024-01-06T00:01:05.961Z
2868865 2868865 20230821022448_dT3wf IT0003 2024-01-06T00:01:05.959Z 2024-01-06T00:01:05.959Z
2868769 2868769 20230821022001_kksnm IT0003 2024-01-06T00:01:05.949Z 2024-01-06T00:01:05.949Z
2868623 2868623 20230821021005_d1vMN IT0003 2024-01-06T00:01:05.935Z 2024-01-06T00:01:05.935Z
2868485 2868485 20230821015657_jmAuB IT0003 2024-01-06T00:01:05.919Z 2024-01-06T00:01:05.919Z
2868146 2868146 20230821013545_YwBnV IT0003 2024-01-06T00:01:05.889Z 2024-01-06T00:01:05.889Z
2867888 2867888 20230821012040_C4Jcs IT0003 2024-01-06T00:01:05.867Z 2024-01-06T00:01:05.867Z
2867358 2867358 20230821005415_j3BHC IT0003 2024-01-06T00:01:05.827Z 2024-01-06T00:01:05.827Z
2866874 2866874 20230821003437_uUHwj IT0003 2024-01-06T00:01:05.792Z 2024-01-06T00:01:05.792Z
2866765 2866765 20230821002816_0Yhqp IT0003 2024-01-06T00:01:05.783Z 2024-01-06T00:01:05.783Z
2866729 2866729 20230821002600_w7yWr IT0003 2024-01-06T00:01:05.780Z 2024-01-06T00:01:05.780Z
2866135 2866135 20230820235034_VQCg5 IT0003 2024-01-06T00:01:05.730Z 2024-01-06T00:01:05.730Z
2865986 2865986 20230820234130_MS7mu IT0003 2024-01-06T00:01:05.717Z 2024-01-06T00:01:05.717Z
2860973 2860973 20230820031802_UvNIl IT0003 2024-01-06T00:01:03.890Z 2024-01-06T00:01:03.890Z
2860733 2860733 20230820025937_3icew IT0003 2024-01-06T00:01:03.870Z 2024-01-06T00:01:03.870Z
2860334 2860334 20230820023527_wo3rt IT0003 2024-01-06T00:01:03.834Z 2024-01-06T00:01:03.834Z
2860009 2860009 20230820021809_J63iK IT0003 2024-01-06T00:01:03.808Z 2024-01-06T00:01:03.808Z
2857866 2857866 20230820001933_BDAQt IT0003 2024-01-06T00:01:03.628Z 2024-01-06T00:01:03.628Z
2856165 2856165 20230819223322_wkx2x IT0003 2024-01-06T00:01:03.494Z 2024-01-06T00:01:03.494Z
2855201 2855201 20230819204953_Ehh6a IT0003 2024-01-06T00:01:03.409Z 2024-01-06T00:01:03.409Z
2852071 2852071 20230819024535_QrF3N IT0003 2024-01-06T00:01:01.751Z 2024-01-06T00:01:01.751Z
2852018 2852018 20230819023746_NLh7a IT0003 2024-01-06T00:01:01.744Z 2024-01-06T00:01:01.744Z
2851231 2851231 20230819005718_JwO0V IT0003 2024-01-06T00:01:01.640Z 2024-01-06T00:01:01.640Z
2851156 2851156 20230819004236_ZqKxV IT0003 2024-01-06T00:01:01.629Z 2024-01-06T00:01:01.629Z
2850940 2850940 20230818234827_xI57O IT0003 2024-01-06T00:01:01.597Z 2024-01-06T00:01:01.597Z
2850898 2850898 20230818234007_U7Irc IT0003 2024-01-06T00:01:01.592Z 2024-01-06T00:01:01.592Z
2850803 2850803 20230818232007_X2BdG IT0003 2024-01-06T00:01:01.579Z 2024-01-06T00:01:01.579Z
2850131 2850131 20230818200535_eU6Jw IT0003 2024-01-06T00:01:01.490Z 2024-01-06T00:01:01.490Z
2839466 2839466 20230817005258_4jKQa IT0003 2024-01-06T00:00:57.669Z 2024-01-06T00:00:57.669Z
2839246 2839246 20230817004247_mTbbi IT0003 2024-01-06T00:00:57.652Z 2024-01-06T00:00:57.652Z
2839067 2839067 20230817003158_MxolN IT0003 2024-01-06T00:00:57.634Z 2024-01-06T00:00:57.634Z
2838880 2838880 20230817002146_HQyJk IT0003 2024-01-06T00:00:57.619Z 2024-01-06T00:00:57.619Z
2838788 2838788 20230817001530_kx2tW IT0003 2024-01-06T00:00:57.610Z 2024-01-06T00:00:57.610Z
2838613 2838613 20230817000338_5L9cy IT0003 2024-01-06T00:00:57.591Z 2024-01-06T00:00:57.591Z
2837789 2837789 20230816231619_d2gbx IT0003 2024-01-06T00:00:57.521Z 2024-01-06T00:00:57.521Z
2837578 2837578 20230816230115_bt3E4 IT0003 2024-01-06T00:00:57.500Z 2024-01-06T00:00:57.500Z
2837169 2837169 20230816223233_Jt7Nt IT0003 2024-01-06T00:00:57.461Z 2024-01-06T00:00:57.461Z
2836678 2836678 20230816215659_m1bW3 IT0003 2024-01-06T00:00:57.415Z 2024-01-06T00:00:57.415Z
2836163 2836163 20230816211837_zMvHN IT0003 2024-01-06T00:00:57.364Z 2024-01-06T00:00:57.364Z
2836141 2836141 20230816211628_rRs3L IT0003 2024-01-06T00:00:57.362Z 2024-01-06T00:00:57.362Z
2836125 2836125 20230816211455_210NH IT0003 2024-01-06T00:00:57.360Z 2024-01-06T00:00:57.360Z
2836115 2836115 20230816211425_y4uaC IT0003 2024-01-06T00:00:57.359Z 2024-01-06T00:00:57.359Z
2835890 2835890 20230816203956_WqjE5 IT0003 2024-01-06T00:00:57.334Z 2024-01-06T00:00:57.334Z
2835667 2835667 20230816192800_A9lgN IT0003 2024-01-06T00:00:57.304Z 2024-01-06T00:00:57.304Z
2831706 2831706 20230816030723_sqGqe IT0003 2024-01-06T00:00:55.079Z 2024-01-06T00:00:55.079Z
2831665 2831665 20230816030444_095ul IT0003 2024-01-06T00:00:55.072Z 2024-01-06T00:00:55.072Z
2831316 2831316 20230816025413_2Kz7f IT0003 2024-01-06T00:00:55.030Z 2024-01-06T00:00:55.030Z
2830556 2830556 20230816023648_FJsRI IT0003 2024-01-06T00:00:54.928Z 2024-01-06T00:00:54.928Z
2830336 2830336 20230816023014_IJah8 IT0003 2024-01-06T00:00:54.899Z 2024-01-06T00:00:54.899Z
2830330 2830330 20230816022952_1iDr0 IT0003 2024-01-06T00:00:54.898Z 2024-01-06T00:00:54.898Z

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