participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
310 rows where station_code = "IL0003" sorted by created_at descending
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 |
---|---|---|---|---|---|
4997659 | 4997659 | 20240903005821_iw1Pl | IL0003 | 2024-09-08T12:06:35.515Z | 2024-09-11T12:21:07.293Z |
4784411 | 4784411 | 20240801232628_vMSch | IL0003 | 2024-08-10T12:15:01.429Z | 2024-08-11T12:14:28.818Z |
4778469 | 4778469 | 20240731225813_LRx45 | IL0003 | 2024-08-07T12:13:46.164Z | 2024-08-10T12:21:06.034Z |
4726701 | 4726701 | 20240728182740_UWeQ5 | IL0003 | 2024-07-31T12:12:36.699Z | 2024-08-05T12:20:24.101Z |
4655409 | 4655409 | 20240717003510_a82Kq | IL0003 | 2024-07-18T12:05:53.676Z | 2024-07-25T12:14:01.907Z |
4478855 | 4478855 | 20240617232343_EiElc | IL0003 | 2024-06-19T12:07:18.552Z | 2024-06-26T12:14:47.851Z |
4333492 | 4333492 | 20240508231111_dsdop | IL0003 | 2024-05-18T12:09:57.436Z | 2024-05-19T12:14:49.471Z |
4321430 | 4321430 | 20240507213740_DoM38 | IL0003 | 2024-05-16T12:08:28.602Z | 2024-05-17T12:11:57.316Z |
4320553 | 4320553 | 20240507200328_jgor3 | IL0003 | 2024-05-16T12:07:40.646Z | 2024-05-17T12:11:42.124Z |
4309377 | 4309377 | 20240506214927_JR8sp | IL0003 | 2024-05-14T12:08:57.385Z | 2024-05-16T12:13:16.238Z |
4230659 | 4230659 | 20240421225852_eFvNi | IL0003 | 2024-04-23T12:09:37.480Z | 2024-04-29T12:18:56.472Z |
4226514 | 4226514 | 20240421235346_IW7gi | IL0003 | 2024-04-23T12:00:33.546Z | 2024-04-30T12:16:45.939Z |
4219465 | 4219465 | 20240420020442_lQS4z | IL0003 | 2024-04-21T12:01:47.336Z | 2024-04-28T12:21:16.723Z |
4194409 | 4194409 | 20240415214639_WdhmO | IL0003 | 2024-04-17T12:01:17.208Z | 2024-04-24T12:22:56.609Z |
4142657 | 4142657 | 20240403212740_6nnX3 | IL0003 | 2024-04-05T12:02:52.588Z | 2024-04-12T12:19:44.471Z |
4108444 | 4108444 | 20240323021432_sQQOP | IL0003 | 2024-03-24T12:05:01.893Z | 2024-03-31T12:16:54.311Z |
4063025 | 4063025 | 20240312005333_PgVWD | IL0003 | 2024-03-13T12:04:57.751Z | 2024-03-20T12:21:37.086Z |
4060895 | 4060895 | 20240310214755_6Ot0D | IL0003 | 2024-03-12T12:07:08.273Z | 2024-03-19T12:22:37.235Z |
4034275 | 4034275 | 20240305233603_pEHdH | IL0003 | 2024-03-07T14:06:10.979Z | 2024-03-14T12:25:03.661Z |
4011950 | 4011950 | 20240229224333_Gn9ll | IL0003 | 2024-03-02T14:06:36.463Z | 2024-03-09T14:17:43.386Z |
4003243 | 4003243 | 20240226020823_ZUV0L | IL0003 | 2024-02-27T14:02:14.822Z | 2024-03-05T14:18:53.044Z |
3995186 | 3995186 | 20240221022256_RcHHa | IL0003 | 2024-02-22T14:06:05.174Z | 2024-02-29T14:14:42.599Z |
3939247 | 3939247 | 20240209015459_fbg9d | IL0003 | 2024-02-10T14:05:43.206Z | 2024-02-17T14:26:14.852Z |
3935714 | 3935714 | 20240207215758_Fl4GZ | IL0003 | 2024-02-09T14:05:22.191Z | 2024-02-16T14:18:28.748Z |
3931451 | 3931451 | 20240207032809_H0c1U | IL0003 | 2024-02-08T14:04:39.999Z | 2024-02-15T14:18:36.879Z |
3905415 | 3905415 | 20240201000508_5YvPF | IL0003 | 2024-02-02T14:03:07.047Z | 2024-02-09T14:20:00.136Z |
3873330 | 3873330 | 20240120022255_8oXJn | IL0003 | 2024-01-23T14:08:35.617Z | 2024-01-28T14:19:23.560Z |
3873153 | 3873153 | 20240120015311_r9a4c | IL0003 | 2024-01-23T14:08:22.404Z | 2024-01-28T14:19:15.848Z |
3831330 | 3831330 | 20240116000253_aWot0 | IL0003 | 2024-01-18T14:00:14.429Z | 2024-01-25T14:20:53.702Z |
3807257 | 3807257 | 20240111013926_26Q0g | IL0003 | 2024-01-14T14:16:51.543Z | 2024-01-19T14:28:13.594Z |
3792121 | 3792121 | 20240110024755_0w3r7 | IL0003 | 2024-01-13T14:00:27.610Z | 2024-01-19T14:26:23.669Z |
3792023 | 3792023 | 20240110020604_fSQvc | IL0003 | 2024-01-12T14:17:04.432Z | 2024-01-18T14:26:09.332Z |
3783782 | 3783782 | 20240108234846_PKvby | IL0003 | 2024-01-11T14:12:27.275Z | 2024-01-17T14:23:39.911Z |
3769899 | 3769899 | 20240107031540_kWsnE | IL0003 | 2024-01-09T14:14:19.529Z | 2024-01-15T14:24:30.487Z |
3768499 | 3768499 | 20240106223715_bPmeV | IL0003 | 2024-01-09T14:11:57.125Z | 2024-01-15T14:24:23.114Z |
3733271 | 3733271 | 20240102221219_9gZvT | IL0003 | 2024-01-06T00:06:12.227Z | 2024-01-11T14:38:17.499Z |
3726446 | 3726446 | 20231231155651_wsNdu | IL0003 | 2024-01-06T00:06:08.889Z | 2024-01-09T14:31:20.781Z |
3724591 | 3724591 | 20231230160623_gPW9J | IL0003 | 2024-01-06T00:06:07.327Z | 2024-01-08T14:25:20.200Z |
3716106 | 3716106 | 20231226021753_dcKCN | IL0003 | 2024-01-06T00:05:59.623Z | 2024-01-06T00:05:59.623Z |
3704785 | 3704785 | 20231221234706_npshR | IL0003 | 2024-01-06T00:05:52.022Z | 2024-01-06T00:05:52.022Z |
3704694 | 3704694 | 20231221220355_Phpwq | IL0003 | 2024-01-06T00:05:52.002Z | 2024-01-06T00:05:52.002Z |
3688311 | 3688311 | 20231219033935_yB3EZ | IL0003 | 2024-01-06T00:05:41.058Z | 2024-01-06T00:05:41.058Z |
3687795 | 3687795 | 20231219013232_4QwWb | IL0003 | 2024-01-06T00:05:40.902Z | 2024-01-06T00:05:40.902Z |
3687717 | 3687717 | 20231219011159_SnRvt | IL0003 | 2024-01-06T00:05:40.879Z | 2024-01-06T00:05:40.879Z |
3687204 | 3687204 | 20231218220849_sUKXb | IL0003 | 2024-01-06T00:05:40.718Z | 2024-01-06T00:05:40.718Z |
3682534 | 3682534 | 20231218012601_BgpYo | IL0003 | 2024-01-06T00:05:38.308Z | 2024-01-06T00:05:38.308Z |
3674469 | 3674469 | 20231217023212_2YmXW | IL0003 | 2024-01-06T00:05:36.008Z | 2024-01-06T00:05:36.008Z |
3674019 | 3674019 | 20231217002752_CTBLB | IL0003 | 2024-01-06T00:05:35.939Z | 2024-01-06T00:05:35.939Z |
3673686 | 3673686 | 20231216224410_66IXL | IL0003 | 2024-01-06T00:05:35.890Z | 2024-01-06T00:05:35.890Z |
3664908 | 3664908 | 20231216001046_EzPB3 | IL0003 | 2024-01-06T00:05:33.650Z | 2024-01-06T00:05:33.650Z |
3664776 | 3664776 | 20231215234035_GXqyT | IL0003 | 2024-01-06T00:05:33.631Z | 2024-01-06T00:05:33.631Z |
3664023 | 3664023 | 20231215210810_3gS65 | IL0003 | 2024-01-06T00:05:33.538Z | 2024-01-06T00:05:33.538Z |
3663917 | 3663917 | 20231215204318_6Zvdj | IL0003 | 2024-01-06T00:05:33.524Z | 2024-01-06T00:05:33.524Z |
3651029 | 3651029 | 20231215032145_uT63Y | IL0003 | 2024-01-06T00:05:30.493Z | 2024-01-06T00:05:30.493Z |
3649335 | 3649335 | 20231215020313_iWcsm | IL0003 | 2024-01-06T00:05:30.264Z | 2024-01-06T00:05:30.264Z |
3649327 | 3649327 | 20231215020302_ylCK3 | IL0003 | 2024-01-06T00:05:30.263Z | 2024-01-06T00:05:30.263Z |
3649059 | 3649059 | 20231215014944_gn202 | IL0003 | 2024-01-06T00:05:30.223Z | 2024-01-06T00:05:30.223Z |
3648122 | 3648122 | 20231215005735_szGTT | IL0003 | 2024-01-06T00:05:30.087Z | 2024-01-06T00:05:30.087Z |
3648050 | 3648050 | 20231215005353_Mjrcw | IL0003 | 2024-01-06T00:05:30.076Z | 2024-01-06T00:05:30.076Z |
3647801 | 3647801 | 20231215003918_vbEdM | IL0003 | 2024-01-06T00:05:30.039Z | 2024-01-06T00:05:30.039Z |
3647786 | 3647786 | 20231215003826_wJPsO | IL0003 | 2024-01-06T00:05:30.037Z | 2024-01-06T00:05:30.037Z |
3647154 | 3647154 | 20231215001112_TCEwU | IL0003 | 2024-01-06T00:05:29.950Z | 2024-01-06T00:05:29.950Z |
3646920 | 3646920 | 20231214235904_GoUkw | IL0003 | 2024-01-06T00:05:29.917Z | 2024-01-06T00:05:29.917Z |
3645936 | 3645936 | 20231214231417_I2I9A | IL0003 | 2024-01-06T00:05:29.776Z | 2024-01-06T00:05:29.776Z |
3645503 | 3645503 | 20231214225132_vP2yZ | IL0003 | 2024-01-06T00:05:29.714Z | 2024-01-06T00:05:29.714Z |
3645479 | 3645479 | 20231214225018_E34dm | IL0003 | 2024-01-06T00:05:29.710Z | 2024-01-06T00:05:29.710Z |
3645154 | 3645154 | 20231214222822_BY3xT | IL0003 | 2024-01-06T00:05:29.663Z | 2024-01-06T00:05:29.663Z |
3644914 | 3644914 | 20231214221157_JIejy | IL0003 | 2024-01-06T00:05:29.630Z | 2024-01-06T00:05:29.630Z |
3644874 | 3644874 | 20231214220947_UQ0ol | IL0003 | 2024-01-06T00:05:29.625Z | 2024-01-06T00:05:29.625Z |
3644445 | 3644445 | 20231214213613_yozul | IL0003 | 2024-01-06T00:05:29.563Z | 2024-01-06T00:05:29.563Z |
3643764 | 3643764 | 20231214204117_MdfIx | IL0003 | 2024-01-06T00:05:29.471Z | 2024-01-06T00:05:29.471Z |
3643314 | 3643314 | 20231214195545_MISfQ | IL0003 | 2024-01-06T00:05:29.407Z | 2024-01-06T00:05:29.407Z |
3583571 | 3583571 | 20231212160340_MCuvF | IL0003 | 2024-01-06T00:05:17.296Z | 2024-01-06T00:05:17.296Z |
3578215 | 3578215 | 20231212033334_Tczyq | IL0003 | 2024-01-06T00:05:15.218Z | 2024-01-06T00:05:15.218Z |
3578042 | 3578042 | 20231212022104_IfTU9 | IL0003 | 2024-01-06T00:05:15.194Z | 2024-01-06T00:05:15.194Z |
3577927 | 3577927 | 20231212010629_T48Uf | IL0003 | 2024-01-06T00:05:15.175Z | 2024-01-06T00:05:15.175Z |
3577566 | 3577566 | 20231211230613_RYUIT | IL0003 | 2024-01-06T00:05:15.120Z | 2024-01-06T00:05:15.120Z |
3577515 | 3577515 | 20231211225243_HELDZ | IL0003 | 2024-01-06T00:05:15.112Z | 2024-01-06T00:05:15.112Z |
3576479 | 3576479 | 20231211190553_ZzDza | IL0003 | 2024-01-06T00:05:15.000Z | 2024-01-06T00:05:15.000Z |
3466762 | 3466762 | 20231124005849_VUd5m | IL0003 | 2024-01-06T00:04:41.007Z | 2024-01-06T00:04:41.007Z |
3466333 | 3466333 | 20231123213006_0f5jG | IL0003 | 2024-01-06T00:04:39.703Z | 2024-01-06T00:04:39.703Z |
3466157 | 3466157 | 20231123205636_CyyuL | IL0003 | 2024-01-06T00:04:39.688Z | 2024-01-06T00:04:39.688Z |
3455477 | 3455477 | 20231122003927_HiSeA | IL0003 | 2024-01-06T00:04:37.259Z | 2024-01-06T00:04:37.259Z |
3448193 | 3448193 | 20231121024120_uPq5j | IL0003 | 2024-01-06T00:04:35.276Z | 2024-01-06T00:04:35.276Z |
3429488 | 3429488 | 20231119030046_smWD2 | IL0003 | 2024-01-06T00:04:30.863Z | 2024-01-06T00:04:30.863Z |
3420818 | 3420818 | 20231118024926_096iR | IL0003 | 2024-01-06T00:04:28.568Z | 2024-01-06T00:04:28.568Z |
3411640 | 3411640 | 20231116235628_tZ8rz | IL0003 | 2024-01-06T00:04:26.343Z | 2024-01-06T00:04:26.343Z |
3355966 | 3355966 | 20231109235422_VUqeU | IL0003 | 2024-01-06T00:04:11.224Z | 2024-01-06T00:04:11.224Z |
3355453 | 3355453 | 20231109222247_wGEQ9 | IL0003 | 2024-01-06T00:04:11.146Z | 2024-01-06T00:04:11.146Z |
3341974 | 3341974 | 20231108022028_T8DpI | IL0003 | 2024-01-06T00:04:05.022Z | 2024-01-06T00:04:05.022Z |
3329301 | 3329301 | 20231107011558_rosLh | IL0003 | 2024-01-06T00:03:59.623Z | 2024-01-06T00:03:59.623Z |
3319240 | 3319240 | 20231106024138_Ycf23 | IL0003 | 2024-01-06T00:03:55.651Z | 2024-01-06T00:03:55.651Z |
3318685 | 3318685 | 20231106014616_tn7SX | IL0003 | 2024-01-06T00:03:55.581Z | 2024-01-06T00:03:55.581Z |
3312694 | 3312694 | 20231104211703_EGcQz | IL0003 | 2024-01-06T00:03:49.917Z | 2024-01-06T00:03:49.917Z |
3277726 | 3277726 | 20231025234734_B06m1 | IL0003 | 2024-01-06T00:03:27.681Z | 2024-01-06T00:03:27.681Z |
3221585 | 3221585 | 20231021003138_2j8PF | IL0003 | 2024-01-06T00:03:08.880Z | 2024-01-06T00:03:08.880Z |
3221140 | 3221140 | 20231020202140_32QAN | IL0003 | 2024-01-06T00:03:06.821Z | 2024-01-06T00:03:06.821Z |
3206817 | 3206817 | 20231019021743_nLGlp | IL0003 | 2024-01-06T00:03:01.171Z | 2024-01-06T00:03:01.171Z |
3200218 | 3200218 | 20231018002407_3oHTU | IL0003 | 2024-01-06T00:02:57.113Z | 2024-01-06T00:02:57.113Z |
3199990 | 3199990 | 20231017231205_r5QJa | IL0003 | 2024-01-06T00:02:55.253Z | 2024-01-06T00:02:55.253Z |
Advanced export
JSON shape: default, array, newline-delimited
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);