participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
887 rows where station_code = "SI0004" 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 |
---|---|---|---|---|---|
4990543 | 4990543 | 20240901002952_Bu5hp | SI0004 | 2024-09-07T12:10:45.097Z | 2024-09-09T12:26:23.034Z |
4990090 | 4990090 | 20240831232408_45uI9 | SI0004 | 2024-09-07T12:10:00.079Z | 2024-09-09T12:26:10.393Z |
4990050 | 4990050 | 20240831231743_OJ8iN | SI0004 | 2024-09-07T12:09:56.859Z | 2024-09-09T12:26:09.412Z |
4989885 | 4989885 | 20240831225301_eTNek | SI0004 | 2024-09-07T12:09:45.456Z | 2024-09-09T12:26:04.805Z |
4989762 | 4989762 | 20240831222435_M5JTi | SI0004 | 2024-09-07T12:09:29.119Z | 2024-09-09T12:25:45.579Z |
4878588 | 4878588 | 20240807003203_EXjkT | SI0004 | 2024-08-19T12:14:16.429Z | 2024-08-27T12:13:46.133Z |
4878125 | 4878125 | 20240807002111_TU4mf | SI0004 | 2024-08-19T12:14:05.831Z | 2024-08-27T12:13:36.798Z |
4876942 | 4876942 | 20240806235113_oKNlL | SI0004 | 2024-08-19T12:13:06.134Z | 2024-08-27T12:12:55.464Z |
4876458 | 4876458 | 20240806234006_2fibZ | SI0004 | 2024-08-19T12:12:54.092Z | 2024-08-27T12:12:43.435Z |
4875076 | 4875076 | 20240806230527_2xRZ2 | SI0004 | 2024-08-19T12:12:00.265Z | 2024-08-27T12:12:04.912Z |
4874647 | 4874647 | 20240806225446_IoX4p | SI0004 | 2024-08-19T12:11:40.679Z | 2024-08-27T12:11:50.557Z |
4874294 | 4874294 | 20240806224500_CwChq | SI0004 | 2024-08-19T12:11:20.196Z | 2024-08-27T12:11:41.026Z |
4874229 | 4874229 | 20240806224349_14Vyr | SI0004 | 2024-08-19T12:11:18.780Z | 2024-08-27T12:11:37.732Z |
4873761 | 4873761 | 20240806223211_mFA2j | SI0004 | 2024-08-19T12:11:05.519Z | 2024-08-27T12:11:21.195Z |
4873736 | 4873736 | 20240806223144_h3cC2 | SI0004 | 2024-08-19T12:11:04.853Z | 2024-08-27T12:11:20.616Z |
4873700 | 4873700 | 20240806222928_SGFyj | SI0004 | 2024-08-19T12:11:03.791Z | 2024-08-27T12:11:19.408Z |
4873675 | 4873675 | 20240806222808_9PoTa | SI0004 | 2024-08-19T12:11:02.379Z | 2024-08-27T12:11:18.537Z |
4873209 | 4873209 | 20240806221443_kqDKu | SI0004 | 2024-08-19T12:10:38.785Z | 2024-08-27T12:11:00.585Z |
4872932 | 4872932 | 20240806220600_2jziS | SI0004 | 2024-08-19T12:10:31.999Z | 2024-08-27T12:10:53.878Z |
4872847 | 4872847 | 20240806220222_ZRkgK | SI0004 | 2024-08-19T12:10:26.467Z | 2024-08-27T12:10:50.069Z |
4825945 | 4825945 | 20240804015625_fmfCv | SI0004 | 2024-08-14T12:20:35.117Z | 2024-08-15T12:26:05.124Z |
4825926 | 4825926 | 20240804015338_4rCEH | SI0004 | 2024-08-14T12:20:33.826Z | 2024-08-15T12:26:04.075Z |
4825902 | 4825902 | 20240804015225_gdOIX | SI0004 | 2024-08-14T12:20:32.432Z | 2024-08-15T12:26:03.294Z |
4825746 | 4825746 | 20240804014002_B3HPr | SI0004 | 2024-08-14T12:20:23.503Z | 2024-08-15T12:25:59.256Z |
4825500 | 4825500 | 20240804011852_UpMpS | SI0004 | 2024-08-14T12:20:11.052Z | 2024-08-15T12:25:53.816Z |
4825288 | 4825288 | 20240804010033_5VB2w | SI0004 | 2024-08-14T12:20:01.617Z | 2024-08-15T12:25:48.581Z |
4825271 | 4825271 | 20240804005733_w1pE2 | SI0004 | 2024-08-14T12:20:00.929Z | 2024-08-15T12:25:48.232Z |
4825206 | 4825206 | 20240804005340_UvnTE | SI0004 | 2024-08-14T12:19:59.269Z | 2024-08-15T12:25:47.075Z |
4825202 | 4825202 | 20240804005249_kuajg | SI0004 | 2024-08-14T12:19:59.051Z | 2024-08-15T12:25:46.683Z |
4825046 | 4825046 | 20240804003918_kyCkZ | SI0004 | 2024-08-14T12:19:52.941Z | 2024-08-15T12:25:43.014Z |
4825006 | 4825006 | 20240804003456_FGxGl | SI0004 | 2024-08-14T12:19:49.395Z | 2024-08-15T12:25:41.981Z |
4824844 | 4824844 | 20240804002241_KTa9y | SI0004 | 2024-08-14T12:19:34.616Z | 2024-08-15T12:25:37.960Z |
4824665 | 4824665 | 20240804000638_0mRPj | SI0004 | 2024-08-14T12:19:20.364Z | 2024-08-15T12:25:33.275Z |
4824422 | 4824422 | 20240803235352_D3R2s | SI0004 | 2024-08-14T12:19:09.128Z | 2024-08-15T12:25:27.203Z |
4824415 | 4824415 | 20240803235330_ZxG2N | SI0004 | 2024-08-14T12:19:08.723Z | 2024-08-15T12:25:27.023Z |
4824410 | 4824410 | 20240803235316_EiHyT | SI0004 | 2024-08-14T12:19:08.029Z | 2024-08-15T12:25:26.600Z |
4824396 | 4824396 | 20240803235137_aIYmr | SI0004 | 2024-08-14T12:19:07.229Z | 2024-08-15T12:25:26.199Z |
4824312 | 4824312 | 20240803234414_lRgx4 | SI0004 | 2024-08-14T12:18:59.659Z | 2024-08-15T12:25:22.619Z |
4824165 | 4824165 | 20240803233508_vIAXb | SI0004 | 2024-08-14T12:18:52.673Z | 2024-08-15T12:25:18.993Z |
4824150 | 4824150 | 20240803233348_f2xBH | SI0004 | 2024-08-14T12:18:50.394Z | 2024-08-15T12:25:18.428Z |
4824058 | 4824058 | 20240803232830_UW1Pn | SI0004 | 2024-08-14T12:18:45.958Z | 2024-08-15T12:25:16.927Z |
4824032 | 4824032 | 20240803232717_ytHjV | SI0004 | 2024-08-14T12:18:44.955Z | 2024-08-15T12:25:16.597Z |
4823979 | 4823979 | 20240803232551_4GHVP | SI0004 | 2024-08-14T12:18:43.783Z | 2024-08-15T12:25:15.980Z |
4823946 | 4823946 | 20240803232323_uWBLj | SI0004 | 2024-08-14T12:18:42.385Z | 2024-08-15T12:25:15.222Z |
4823912 | 4823912 | 20240803232126_rhFyF | SI0004 | 2024-08-14T12:18:40.226Z | 2024-08-15T12:25:14.615Z |
4823757 | 4823757 | 20240803231348_EHETZ | SI0004 | 2024-08-14T12:18:34.117Z | 2024-08-15T12:25:11.426Z |
4823738 | 4823738 | 20240803231221_63gM1 | SI0004 | 2024-08-14T12:18:32.982Z | 2024-08-15T12:25:10.293Z |
4823705 | 4823705 | 20240803231024_99Uab | SI0004 | 2024-08-14T12:18:30.419Z | 2024-08-15T12:25:08.135Z |
4823675 | 4823675 | 20240803230833_MvaHm | SI0004 | 2024-08-14T12:18:28.902Z | 2024-08-15T12:25:07.260Z |
4823350 | 4823350 | 20240803224300_S3q9L | SI0004 | 2024-08-14T12:18:11.073Z | 2024-08-15T12:24:55.396Z |
4823254 | 4823254 | 20240803222938_I5v2V | SI0004 | 2024-08-14T12:18:02.671Z | 2024-08-15T12:24:51.579Z |
4823175 | 4823175 | 20240803222126_2W3nT | SI0004 | 2024-08-14T12:17:56.523Z | 2024-08-15T12:24:47.893Z |
4823128 | 4823128 | 20240803221713_y838s | SI0004 | 2024-08-14T12:17:53.671Z | 2024-08-15T12:24:46.690Z |
4823080 | 4823080 | 20240803221112_1E3zr | SI0004 | 2024-08-14T12:17:51.507Z | 2024-08-15T12:24:45.647Z |
4823073 | 4823073 | 20240803220933_zohhg | SI0004 | 2024-08-14T12:17:51.181Z | 2024-08-15T12:24:45.377Z |
4822998 | 4822998 | 20240803220226_tnvsG | SI0004 | 2024-08-14T12:17:44.370Z | 2024-08-15T12:24:43.497Z |
4822696 | 4822696 | 20240803214523_svajj | SI0004 | 2024-08-14T12:17:23.419Z | 2024-08-15T12:24:33.384Z |
4805948 | 4805948 | 20240803010939_ohEyY | SI0004 | 2024-08-12T12:18:14.239Z | 2024-08-13T12:17:27.453Z |
4805934 | 4805934 | 20240803010904_CCipj | SI0004 | 2024-08-12T12:18:12.998Z | 2024-08-13T12:17:27.261Z |
4805730 | 4805730 | 20240803004208_zElbk | SI0004 | 2024-08-12T12:18:04.707Z | 2024-08-13T12:17:21.899Z |
4805680 | 4805680 | 20240803003839_CvIkU | SI0004 | 2024-08-12T12:18:02.864Z | 2024-08-13T12:17:20.986Z |
4805640 | 4805640 | 20240803003505_G2qN6 | SI0004 | 2024-08-12T12:18:00.687Z | 2024-08-13T12:17:19.769Z |
4805628 | 4805628 | 20240803003439_nqdKo | SI0004 | 2024-08-12T12:18:00.462Z | 2024-08-13T12:17:19.674Z |
4805539 | 4805539 | 20240803002503_thFC1 | SI0004 | 2024-08-12T12:17:55.554Z | 2024-08-13T12:17:17.519Z |
4805253 | 4805253 | 20240802235214_q330h | SI0004 | 2024-08-12T12:17:36.297Z | 2024-08-13T12:17:10.828Z |
4805222 | 4805222 | 20240802234907_rs9Iy | SI0004 | 2024-08-12T12:17:33.801Z | 2024-08-13T12:17:10.423Z |
4805095 | 4805095 | 20240802233605_LYBU0 | SI0004 | 2024-08-12T12:17:23.102Z | 2024-08-13T12:17:08.898Z |
4805002 | 4805002 | 20240802232845_vffk8 | SI0004 | 2024-08-12T12:17:16.660Z | 2024-08-13T12:17:05.905Z |
4804824 | 4804824 | 20240802231141_QDCZP | SI0004 | 2024-08-12T12:17:02.451Z | 2024-08-13T12:17:03.340Z |
4357686 | 4357686 | 20240511014447_SGEtP | SI0004 | 2024-05-22T12:12:00.804Z | 2024-05-22T12:12:00.804Z |
4357679 | 4357679 | 20240511002027_HfQx7 | SI0004 | 2024-05-22T12:11:41.942Z | 2024-05-22T12:11:41.942Z |
4296434 | 4296434 | 20240505021906_qA428 | SI0004 | 2024-05-08T12:11:46.865Z | 2024-05-13T12:12:19.435Z |
4296413 | 4296413 | 20240505021710_u9KAf | SI0004 | 2024-05-08T12:11:45.166Z | 2024-05-13T12:12:18.911Z |
4296390 | 4296390 | 20240505021259_GlQsp | SI0004 | 2024-05-08T12:11:43.522Z | 2024-05-13T12:12:18.188Z |
4296326 | 4296326 | 20240505020750_EPIUG | SI0004 | 2024-05-08T12:11:41.236Z | 2024-05-13T12:12:17.154Z |
4296211 | 4296211 | 20240505020012_LmTZx | SI0004 | 2024-05-08T12:11:25.766Z | 2024-05-13T12:12:14.832Z |
4296086 | 4296086 | 20240505014845_aKc2d | SI0004 | 2024-05-08T12:11:16.960Z | 2024-05-13T12:12:12.491Z |
4295534 | 4295534 | 20240505003418_28Mrz | SI0004 | 2024-05-08T12:10:32.077Z | 2024-05-13T12:12:00.646Z |
4295515 | 4295515 | 20240505003206_CVelO | SI0004 | 2024-05-08T12:10:29.289Z | 2024-05-13T12:12:00.086Z |
4295467 | 4295467 | 20240505002339_tl7eC | SI0004 | 2024-05-08T12:10:23.586Z | 2024-05-13T12:11:58.674Z |
4295463 | 4295463 | 20240505002244_SFEjn | SI0004 | 2024-05-08T12:10:23.361Z | 2024-05-13T12:11:58.584Z |
4142879 | 4142879 | 20240404025423_Akv4z | SI0004 | 2024-04-05T12:03:37.225Z | 2024-04-12T12:19:46.435Z |
4139158 | 4139158 | 20240403022348_MntbI | SI0004 | 2024-04-04T12:06:28.822Z | 2024-04-11T12:23:45.777Z |
4139151 | 4139151 | 20240403022100_rH232 | SI0004 | 2024-04-04T12:06:27.426Z | 2024-04-11T12:23:45.750Z |
4139143 | 4139143 | 20240403021339_p693g | SI0004 | 2024-04-04T12:06:25.970Z | 2024-04-11T12:23:45.713Z |
4139102 | 4139102 | 20240403015445_JmZdj | SI0004 | 2024-04-04T12:06:20.308Z | 2024-04-11T12:23:45.485Z |
4139095 | 4139095 | 20240403014932_LTY90 | SI0004 | 2024-04-04T12:06:19.207Z | 2024-04-11T12:23:45.451Z |
4139087 | 4139087 | 20240403014752_099wG | SI0004 | 2024-04-04T12:06:17.744Z | 2024-04-11T12:23:45.404Z |
4139083 | 4139083 | 20240403014621_B2K43 | SI0004 | 2024-04-04T12:06:17.352Z | 2024-04-11T12:23:45.396Z |
4139073 | 4139073 | 20240403014342_6Ac2w | SI0004 | 2024-04-04T12:06:15.846Z | 2024-04-11T12:23:45.357Z |
4139069 | 4139069 | 20240403014200_SOAd8 | SI0004 | 2024-04-04T12:06:15.484Z | 2024-04-11T12:23:45.347Z |
4139050 | 4139050 | 20240403013540_tWAQm | SI0004 | 2024-04-04T12:06:13.775Z | 2024-04-11T12:23:45.296Z |
4139020 | 4139020 | 20240403011916_Nkbpm | SI0004 | 2024-04-04T12:06:07.539Z | 2024-04-11T12:23:45.131Z |
4139007 | 4139007 | 20240403011502_RbS8j | SI0004 | 2024-04-04T12:06:05.599Z | 2024-04-11T12:23:45.099Z |
4138998 | 4138998 | 20240403011043_zP8d3 | SI0004 | 2024-04-04T12:06:01.815Z | 2024-04-11T12:23:45.010Z |
4138968 | 4138968 | 20240403004411_U2spp | SI0004 | 2024-04-04T12:05:55.165Z | 2024-04-11T12:23:44.884Z |
4138933 | 4138933 | 20240403001150_eUfDi | SI0004 | 2024-04-04T12:05:49.325Z | 2024-04-11T12:23:44.661Z |
4138896 | 4138896 | 20240402234319_sKjdn | SI0004 | 2024-04-04T12:05:44.698Z | 2024-04-11T12:23:44.333Z |
4138839 | 4138839 | 20240402225123_3zxEV | SI0004 | 2024-04-04T12:05:36.280Z | 2024-04-11T12:23:43.946Z |
4138804 | 4138804 | 20240402221409_Snqrz | SI0004 | 2024-04-04T12:05:26.819Z | 2024-04-11T12:23:42.957Z |
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);