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,595 rows where station_code = "IT0007" 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
7307240 7307240 20250801022531_5huuO IT0007 2025-08-03T12:21:41.765Z 2025-08-09T13:07:07.502Z
7307214 7307214 20250801022429_iO7a0 IT0007 2025-08-03T12:21:40.300Z 2025-08-09T13:07:07.439Z
7307156 7307156 20250801022212_iqeKz IT0007 2025-08-03T12:21:38.002Z 2025-08-09T13:07:06.701Z
7306919 7306919 20250801021259_SDZxL IT0007 2025-08-03T12:21:17.161Z 2025-08-09T13:07:04.723Z
7306740 7306740 20250801020553_h8tmo IT0007 2025-08-03T12:21:07.991Z 2025-08-09T13:07:01.398Z
7306727 7306727 20250801020447_bfEbJ IT0007 2025-08-03T12:21:07.230Z 2025-08-09T13:07:01.349Z
7306289 7306289 20250801014624_owVbS IT0007 2025-08-03T12:20:38.601Z 2025-08-09T13:06:55.304Z
7306275 7306275 20250801014614_qg7fN IT0007 2025-08-03T12:20:38.133Z 2025-08-09T13:06:55.217Z
7306207 7306207 20250801014226_3GRHj IT0007 2025-08-03T12:20:32.798Z 2025-08-09T13:06:54.722Z
7305753 7305753 20250801012437_bBUug IT0007 2025-08-03T12:20:02.732Z 2025-08-09T13:06:50.196Z
7305698 7305698 20250801012151_pUqKC IT0007 2025-08-03T12:20:00.560Z 2025-08-09T13:06:47.654Z
7305153 7305153 20250801010333_KBUU3 IT0007 2025-08-03T12:19:31.578Z 2025-08-09T13:06:36.736Z
7305096 7305096 20250801010018_3lr93 IT0007 2025-08-03T12:19:19.917Z 2025-08-09T13:06:35.407Z
7305003 7305003 20250801005725_E3MPM IT0007 2025-08-03T12:19:17.213Z 2025-08-09T13:06:32.828Z
7304766 7304766 20250801004425_AHbyf IT0007 2025-08-03T12:19:05.775Z 2025-08-09T13:06:30.164Z
7304480 7304480 20250801003107_1hQ95 IT0007 2025-08-03T12:18:52.011Z 2025-08-09T13:06:25.982Z
7303648 7303648 20250731235148_Vq7sb IT0007 2025-08-03T12:17:51.631Z 2025-08-09T13:06:22.737Z
7303330 7303330 20250731233844_gw9pp IT0007 2025-08-03T12:17:28.865Z 2025-08-09T13:06:20.072Z
7302989 7302989 20250731232158_mwWyc IT0007 2025-08-03T12:17:08.399Z 2025-08-09T13:06:15.827Z
7302889 7302889 20250731231703_dh8TY IT0007 2025-08-03T12:17:03.983Z 2025-08-09T13:06:09.028Z
7302877 7302877 20250731231550_JJm34 IT0007 2025-08-03T12:17:02.810Z 2025-08-09T13:06:08.781Z
7302865 7302865 20250731231549_tbq1R IT0007 2025-08-03T12:16:56.983Z 2025-08-09T13:06:08.754Z
7300608 7300608 20250731224550_0Tt47 IT0007 2025-08-02T12:25:08.179Z 2025-08-09T13:05:54.680Z
7300356 7300356 20250731223154_FMYhe IT0007 2025-08-02T12:25:00.097Z 2025-08-09T13:05:50.850Z
7299318 7299318 20250731213645_Kqplr IT0007 2025-08-02T12:24:45.882Z 2025-08-09T13:05:29.796Z
7298632 7298632 20250731205545_vVa03 IT0007 2025-08-02T12:24:36.968Z 2025-08-02T12:24:36.968Z
6025052 6025052 20250129234534_Qdu3L IT0007 2025-01-31T14:20:50.593Z 2025-02-07T14:59:18.124Z
6018261 6018261 20250130002959_RM0Y3 IT0007 2025-01-31T14:00:36.522Z 2025-02-08T15:07:46.282Z
5979943 5979943 20250122024035_jlWaR IT0007 2025-01-23T14:21:08.772Z 2025-01-30T14:33:50.598Z
5949737 5949737 20250113021040_nPITk IT0007 2025-01-14T14:07:52.526Z 2025-01-21T14:20:05.600Z
5937168 5937168 20250108022801_qe1SY IT0007 2025-01-09T14:20:58.998Z 2025-01-16T14:22:49.218Z
5937085 5937085 20250108015522_oODTo IT0007 2025-01-09T14:20:41.188Z 2025-01-16T14:22:28.009Z
5922275 5922275 20250104045612_z8n5p IT0007 2025-01-06T14:22:51.535Z 2025-01-12T14:30:50.824Z
5922185 5922185 20250104044107_7BrsJ IT0007 2025-01-06T14:22:37.652Z 2025-01-12T14:30:44.300Z
5921951 5921951 20250104034703_qkcwt IT0007 2025-01-06T14:22:06.084Z 2025-01-12T14:30:29.229Z
5921884 5921884 20250104033323_3nnvP IT0007 2025-01-06T14:22:01.613Z 2025-01-12T14:30:25.426Z
5921500 5921500 20250104023613_sM5uV IT0007 2025-01-06T14:21:28.783Z 2025-01-12T14:29:59.785Z
5921407 5921407 20250104022434_wsuEd IT0007 2025-01-06T14:21:11.377Z 2025-01-12T14:29:51.860Z
5921272 5921272 20250104015957_w4ksg IT0007 2025-01-06T14:20:54.659Z 2025-01-12T14:29:42.626Z
5919973 5919973 20250103230834_9TPx1 IT0007 2025-01-06T14:18:53.443Z 2025-01-12T14:28:39.314Z
5919342 5919342 20250103220002_3Uuc2 IT0007 2025-01-06T14:18:01.810Z 2025-01-12T14:28:08.673Z
5870232 5870232 20241228042642_qFEQ9 IT0007 2024-12-29T14:15:32.158Z 2025-01-05T14:37:02.525Z
5870022 5870022 20241228035842_hcEzB IT0007 2024-12-29T14:14:51.610Z 2025-01-05T14:36:55.974Z
5868734 5868734 20241228000915_kRPEq IT0007 2024-12-29T14:10:12.989Z 2025-01-05T14:36:09.576Z
5868399 5868399 20241227222246_KhHVg IT0007 2024-12-29T14:08:29.552Z 2025-01-05T14:35:58.106Z
5868330 5868330 20241227220519_ml2pr IT0007 2024-12-29T14:08:16.743Z 2025-01-05T14:35:56.011Z
5868112 5868112 20241227210548_X3tZ6 IT0007 2024-12-29T14:07:22.643Z 2025-01-05T14:35:49.044Z
5867435 5867435 20241227184004_wzH4t IT0007 2024-12-29T14:04:41.090Z 2025-01-05T14:35:29.775Z
5863209 5863209 20241227045513_TMIfv IT0007 2024-12-28T14:16:20.625Z 2025-01-04T14:42:18.931Z
5862727 5862727 20241227034656_SVzwH IT0007 2024-12-28T14:14:45.713Z 2025-01-04T14:42:04.609Z
5862180 5862180 20241227021633_uiVqo IT0007 2024-12-28T14:12:52.220Z 2025-01-04T14:41:46.127Z
5861990 5861990 20241227012626_xgVbY IT0007 2024-12-28T14:12:00.452Z 2025-01-04T14:41:38.791Z
5861566 5861566 20241227000057_BJhXs IT0007 2024-12-28T14:10:07.852Z 2025-01-04T14:41:25.852Z
5856642 5856642 20241226051237_LnGCa IT0007 2024-12-27T14:11:03.876Z 2025-01-03T14:30:27.266Z
5856627 5856627 20241226050805_d0deO IT0007 2024-12-27T14:10:55.302Z 2025-01-03T14:30:26.395Z
5856528 5856528 20241226044820_Ob9l0 IT0007 2024-12-27T14:10:40.145Z 2025-01-03T14:30:20.566Z
5856407 5856407 20241226042457_r1srA IT0007 2024-12-27T14:10:13.846Z 2025-01-03T14:30:11.555Z
5856371 5856371 20241226041712_ZchQQ IT0007 2024-12-27T14:10:08.253Z 2025-01-03T14:30:02.327Z
5856159 5856159 20241226033517_PgqPW IT0007 2024-12-27T14:09:14.471Z 2025-01-03T14:29:48.180Z
5855583 5855583 20241226014207_PxcTU IT0007 2024-12-27T14:07:10.529Z 2025-01-03T14:28:57.162Z
5855439 5855439 20241226010152_qf2pq IT0007 2024-12-27T14:06:37.125Z 2025-01-03T14:28:35.081Z
5855045 5855045 20241225230222_PGG51 IT0007 2024-12-27T14:04:54.530Z 2025-01-03T14:28:00.405Z
5854278 5854278 20241225171734_io6q6 IT0007 2024-12-27T14:01:24.483Z 2025-01-03T14:26:56.753Z
5852879 5852879 20241225040745_f1Qyv IT0007 2024-12-26T14:08:08.347Z 2025-01-02T14:33:46.123Z
5852694 5852694 20241225025159_9LQ8e IT0007 2024-12-26T14:07:21.076Z 2025-01-02T14:33:30.857Z
5852222 5852222 20241224222920_11x42 IT0007 2024-12-26T14:05:25.103Z 2025-01-02T14:33:11.684Z
5852186 5852186 20241224214840_7QrUX IT0007 2024-12-26T14:05:16.831Z 2025-01-02T14:33:10.415Z
5851782 5851782 20241224180943_t2QSc IT0007 2024-12-26T14:02:50.977Z 2025-01-02T14:32:30.995Z
5847825 5847825 20241224050809_FvQXF IT0007 2024-12-25T14:09:29.149Z 2025-01-01T14:31:36.256Z
5847424 5847424 20241224015338_f5Scm IT0007 2024-12-25T14:07:50.203Z 2025-01-01T14:31:01.709Z
5831756 5831756 20241221035528_8a9za IT0007 2024-12-23T14:24:53.418Z 2024-12-23T14:31:07.607Z
5831377 5831377 20241221024755_qa7Kz IT0007 2024-12-23T14:23:57.300Z 2024-12-23T14:30:40.449Z
5830998 5830998 20241221015846_OxMyd IT0007 2024-12-23T14:23:13.808Z 2024-12-23T14:30:15.329Z
5829199 5829199 20241220201513_z8Zew IT0007 2024-12-23T14:19:59.033Z 2024-12-23T14:28:34.279Z
5825698 5825698 20241222033632_acyL2 IT0007 2024-12-23T14:11:14.712Z 2024-12-30T14:37:40.116Z
5825565 5825565 20241222031559_h6yDs IT0007 2024-12-23T14:11:01.251Z 2024-12-30T14:37:33.047Z
5825533 5825533 20241222031215_bTxo7 IT0007 2024-12-23T14:10:56.686Z 2024-12-30T14:37:30.888Z
5824598 5824598 20241222012420_s0tg3 IT0007 2024-12-23T14:07:44.588Z 2024-12-30T14:36:45.164Z
5822820 5822820 20241221212118_Pmft0 IT0007 2024-12-23T14:02:51.086Z 2024-12-30T14:35:34.255Z
5822795 5822795 20241221211656_LVctW IT0007 2024-12-23T14:02:46.366Z 2024-12-30T14:35:32.106Z
5822190 5822190 20241221174113_TvBvh IT0007 2024-12-23T14:00:22.594Z 2024-12-30T14:34:16.635Z
5818299 5818299 20241219033609_NvbbF IT0007 2024-12-20T14:06:32.758Z 2024-12-27T14:30:04.029Z
5808930 5808930 20241217021638_wkP2U IT0007 2024-12-18T14:04:44.826Z 2024-12-25T14:34:21.454Z
5808846 5808846 20241217014451_vLOJ2 IT0007 2024-12-18T14:04:24.288Z 2024-12-25T14:34:19.454Z
5808378 5808378 20241216233932_9UfC2 IT0007 2024-12-18T14:02:18.960Z 2024-12-25T14:34:05.321Z
5808317 5808317 20241216230736_67yMa IT0007 2024-12-18T14:02:03.735Z 2024-12-25T14:34:02.191Z
5767280 5767280 20241212051503_xC6qs IT0007 2024-12-13T14:05:38.497Z 2024-12-20T14:37:55.880Z
5767174 5767174 20241212045001_ENWQh IT0007 2024-12-13T14:05:13.703Z 2024-12-20T14:37:53.690Z
5767064 5767064 20241212042849_L7bn3 IT0007 2024-12-13T14:04:37.882Z 2024-12-20T14:37:50.716Z
5766717 5766717 20241212031257_mYrP9 IT0007 2024-12-13T14:03:30.876Z 2024-12-20T14:37:44.054Z
5766570 5766570 20241212024726_3a5OK IT0007 2024-12-13T14:02:51.756Z 2024-12-20T14:37:40.651Z
5766458 5766458 20241212021717_flQiX IT0007 2024-12-13T14:02:29.580Z 2024-12-20T14:37:35.127Z
5766433 5766433 20241212021101_1mVZF IT0007 2024-12-13T14:02:15.100Z 2024-12-20T14:37:34.331Z
5766324 5766324 20241212012449_85y2z IT0007 2024-12-13T14:01:46.686Z 2024-12-20T14:37:32.276Z
5766158 5766158 20241212002644_L7v06 IT0007 2024-12-13T14:01:05.865Z 2024-12-20T14:37:29.285Z
5766135 5766135 20241212000712_s0Snr IT0007 2024-12-13T14:01:00.329Z 2024-12-20T14:37:28.819Z
5766056 5766056 20241211231259_RPo3h IT0007 2024-12-13T14:00:39.096Z 2024-12-20T14:37:27.327Z
5766006 5766006 20241211222606_KEom6 IT0007 2024-12-13T14:00:26.399Z 2024-12-20T14:37:24.124Z
5766004 5766004 20241211222522_VYejM IT0007 2024-12-13T14:00:25.882Z 2024-12-20T14:37:24.089Z
5730062 5730062 20241206231354_pBEzy IT0007 2024-12-08T14:26:50.548Z 2024-12-08T14:26:50.548Z

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