participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
48 rows where station_code = "IL000A" 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 |
---|---|---|---|---|---|
5128579 | 5128579 | 20240917020705_mdbrC | IL000A | 2024-09-19T12:10:45.568Z | 2024-09-20T12:10:56.463Z |
5104250 | 5104250 | 20240913020102_7vdO8 | IL000A | 2024-09-17T12:11:30.815Z | 2024-09-20T12:20:33.575Z |
5099370 | 5099370 | 20240913210557_mF3lG | IL000A | 2024-09-17T12:02:49.496Z | 2024-09-20T12:18:19.216Z |
5099336 | 5099336 | 20240913210337_EWyjm | IL000A | 2024-09-17T12:02:47.749Z | 2024-09-20T12:18:18.908Z |
5098752 | 5098752 | 20240913192004_3PIfr | IL000A | 2024-09-17T12:01:30.324Z | 2024-09-20T12:18:06.961Z |
5091929 | 5091929 | 20240912022850_IBY9T | IL000A | 2024-09-16T12:13:31.528Z | 2024-09-20T12:21:49.422Z |
5087179 | 5087179 | 20240912231423_kX1cb | IL000A | 2024-09-16T12:06:45.399Z | 2024-09-20T12:20:14.788Z |
5084850 | 5084850 | 20240912202128_cn1jA | IL000A | 2024-09-16T12:03:01.744Z | 2024-09-20T12:19:59.189Z |
5077669 | 5077669 | 20240911010934_wHKyc | IL000A | 2024-09-15T12:14:57.390Z | 2024-09-19T12:21:39.491Z |
5076663 | 5076663 | 20240910235755_CPuWL | IL000A | 2024-09-15T12:13:53.201Z | 2024-09-19T12:21:37.448Z |
5076128 | 5076128 | 20240910230816_GFKjn | IL000A | 2024-09-15T12:13:18.746Z | 2024-09-19T12:21:36.471Z |
5064765 | 5064765 | 20240910015948_ZVZlE | IL000A | 2024-09-14T12:16:00.321Z | 2024-09-18T12:15:17.291Z |
5063993 | 5063993 | 20240909231643_HqFJi | IL000A | 2024-09-14T12:14:37.777Z | 2024-09-18T12:15:15.152Z |
5063980 | 5063980 | 20240909231341_Nt3cy | IL000A | 2024-09-14T12:14:35.634Z | 2024-09-18T12:15:15.103Z |
5063626 | 5063626 | 20240909220007_8m09o | IL000A | 2024-09-14T12:14:09.635Z | 2024-09-18T12:15:14.308Z |
5063600 | 5063600 | 20240909215508_9E7lx | IL000A | 2024-09-14T12:14:08.413Z | 2024-09-18T12:15:14.287Z |
5062916 | 5062916 | 20240909190125_6Rn4t | IL000A | 2024-09-14T12:13:02.770Z | 2024-09-18T12:15:12.494Z |
5062852 | 5062852 | 20240909184202_nqTWC | IL000A | 2024-09-14T12:12:58.673Z | 2024-09-18T12:15:12.309Z |
5060396 | 5060396 | 20240910202707_SEzts | IL000A | 2024-09-14T12:08:44.440Z | 2024-09-19T12:21:32.337Z |
5054092 | 5054092 | 20240908020856_m3RtX | IL000A | 2024-09-13T12:16:29.247Z | 2024-09-16T12:21:13.942Z |
5053494 | 5053494 | 20240908004537_Zh3hQ | IL000A | 2024-09-13T12:16:06.382Z | 2024-09-16T12:21:11.642Z |
5052844 | 5052844 | 20240907221957_LomOv | IL000A | 2024-09-13T12:15:31.715Z | 2024-09-16T12:21:08.216Z |
5047005 | 5047005 | 20240909021317_2Eer0 | IL000A | 2024-09-13T12:08:07.192Z | 2024-09-17T12:19:00.704Z |
5046264 | 5046264 | 20240908222515_dc65i | IL000A | 2024-09-13T12:06:15.915Z | 2024-09-17T12:18:58.834Z |
5045794 | 5045794 | 20240908192658_tq6pH | IL000A | 2024-09-13T12:04:58.279Z | 2024-09-17T12:18:57.366Z |
5039623 | 5039623 | 20240906013542_K29Q2 | IL000A | 2024-09-12T12:15:39.240Z | 2024-09-14T12:23:03.790Z |
5039113 | 5039113 | 20240905232256_zW2DE | IL000A | 2024-09-12T12:15:15.951Z | 2024-09-14T12:23:00.115Z |
5039031 | 5039031 | 20240905230828_taGix | IL000A | 2024-09-12T12:15:13.295Z | 2024-09-14T12:22:59.881Z |
5038396 | 5038396 | 20240905195504_EoOUV | IL000A | 2024-09-12T12:14:38.088Z | 2024-09-14T12:22:55.930Z |
5032999 | 5032999 | 20240907021231_Xo0hC | IL000A | 2024-09-12T12:08:42.280Z | 2024-09-15T12:21:28.771Z |
5032628 | 5032628 | 20240907012250_ca2MN | IL000A | 2024-09-12T12:07:46.329Z | 2024-09-15T12:21:27.166Z |
5032278 | 5032278 | 20240907003923_gy6bD | IL000A | 2024-09-12T12:07:02.794Z | 2024-09-15T12:21:25.789Z |
5032184 | 5032184 | 20240907002430_uqTtN | IL000A | 2024-09-12T12:06:42.583Z | 2024-09-15T12:21:25.468Z |
5031404 | 5031404 | 20240906214253_0mrDO | IL000A | 2024-09-12T12:04:42.642Z | 2024-09-15T12:21:22.217Z |
5030817 | 5030817 | 20240906185151_qynUq | IL000A | 2024-09-12T12:03:09.328Z | 2024-09-15T12:21:19.879Z |
5025282 | 5025282 | 20240906013542_Ia52g | IL000A | 2024-09-11T12:06:08.565Z | 2024-09-11T12:16:32.557Z |
5024706 | 5024706 | 20240905232256_YmoQf | IL000A | 2024-09-11T12:04:32.057Z | 2024-09-11T12:16:32.271Z |
5024614 | 5024614 | 20240905230828_9SwmJ | IL000A | 2024-09-11T12:04:14.715Z | 2024-09-11T12:16:32.228Z |
5019730 | 5019730 | 20240904234325_cFDhs | IL000A | 2024-09-10T12:13:20.583Z | 2024-09-13T12:19:53.624Z |
5019323 | 5019323 | 20240904223203_PxQY7 | IL000A | 2024-09-10T12:12:37.049Z | 2024-09-13T12:19:51.390Z |
5018673 | 5018673 | 20240904192958_EhKz3 | IL000A | 2024-09-10T12:11:10.760Z | 2024-09-13T12:19:48.470Z |
5008423 | 5008423 | 20240903234220_Hq13u | IL000A | 2024-09-09T12:06:43.683Z | 2024-09-12T12:19:17.546Z |
5007580 | 5007580 | 20240903214717_Mj2G5 | IL000A | 2024-09-09T12:05:54.818Z | 2024-09-12T12:19:13.946Z |
5006513 | 5006513 | 20240903174522_Bq6VH | IL000A | 2024-09-09T12:04:43.455Z | 2024-09-12T12:19:08.521Z |
4998026 | 4998026 | 20240903020535_0YcQG | IL000A | 2024-09-08T12:07:04.647Z | 2024-09-11T12:21:10.597Z |
4997017 | 4997017 | 20240902223418_icQy8 | IL000A | 2024-09-08T12:05:36.021Z | 2024-09-11T12:21:00.136Z |
4996727 | 4996727 | 20240902204341_E9Sah | IL000A | 2024-09-08T12:05:12.753Z | 2024-09-11T12:20:57.597Z |
4995818 | 4995818 | 20240902175735_RAHPw | IL000A | 2024-09-08T12:04:06.099Z | 2024-09-11T12:20:48.612Z |
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);