participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,173 rows where station_code = "CZ000L" 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 |
---|---|---|---|---|---|
5505125 | 5505125 | 20241108035612_tmRrr | CZ000L | 2024-11-09T14:15:46.351Z | 2024-11-09T14:16:28.707Z |
5503987 | 5503987 | 20241108003354_GUH9T | CZ000L | 2024-11-09T14:13:56.893Z | 2024-11-09T14:16:28.419Z |
5503734 | 5503734 | 20241107234106_TTgvD | CZ000L | 2024-11-09T14:13:41.515Z | 2024-11-09T14:16:28.334Z |
5502578 | 5502578 | 20241107191022_7DY6k | CZ000L | 2024-11-09T14:11:45.770Z | 2024-11-09T14:16:28.058Z |
5502364 | 5502364 | 20241107181331_56ula | CZ000L | 2024-11-09T14:11:13.578Z | 2024-11-09T14:16:28.013Z |
5502028 | 5502028 | 20241107165609_TZuzc | CZ000L | 2024-11-09T14:10:50.848Z | 2024-11-09T14:16:27.924Z |
5501937 | 5501937 | 20241107164249_yQcOm | CZ000L | 2024-11-09T14:10:46.587Z | 2024-11-09T14:16:27.908Z |
5497438 | 5497438 | 20241107034050_3z2e6 | CZ000L | 2024-11-08T14:13:46.651Z | 2024-11-09T14:18:43.053Z |
5497346 | 5497346 | 20241107032615_I7ygw | CZ000L | 2024-11-08T14:13:36.199Z | 2024-11-09T14:18:41.243Z |
5497152 | 5497152 | 20241107025005_T6Kii | CZ000L | 2024-11-08T14:13:16.432Z | 2024-11-09T14:18:36.150Z |
5497027 | 5497027 | 20241107023035_4Cmc8 | CZ000L | 2024-11-08T14:13:06.303Z | 2024-11-09T14:18:34.447Z |
5485064 | 5485064 | 20241105040024_w0SZr | CZ000L | 2024-11-06T14:17:43.130Z | 2024-11-09T14:21:19.100Z |
5484399 | 5484399 | 20241105024506_gEfBX | CZ000L | 2024-11-06T14:16:52.690Z | 2024-11-09T14:21:13.724Z |
5483934 | 5483934 | 20241105014634_Rttq2 | CZ000L | 2024-11-06T14:15:56.092Z | 2024-11-09T14:21:09.531Z |
5483391 | 5483391 | 20241105003523_j04x3 | CZ000L | 2024-11-06T14:15:10.545Z | 2024-11-09T14:21:05.168Z |
5482478 | 5482478 | 20241104222625_rm4U1 | CZ000L | 2024-11-06T14:13:15.135Z | 2024-11-09T14:20:59.723Z |
5482369 | 5482369 | 20241104215839_EWOy5 | CZ000L | 2024-11-06T14:13:05.283Z | 2024-11-09T14:20:58.609Z |
5482220 | 5482220 | 20241104212808_nDsMf | CZ000L | 2024-11-06T14:12:37.286Z | 2024-11-09T14:20:56.881Z |
5481402 | 5481402 | 20241104173036_GpdvK | CZ000L | 2024-11-06T14:10:29.362Z | 2024-11-09T14:20:45.444Z |
5481332 | 5481332 | 20241104170614_X5hWM | CZ000L | 2024-11-06T14:10:02.443Z | 2024-11-09T14:20:44.194Z |
5481326 | 5481326 | 20241104170322_tdUUE | CZ000L | 2024-11-06T14:10:00.612Z | 2024-11-09T14:20:44.035Z |
5478439 | 5478439 | 20241104041149_MrcNr | CZ000L | 2024-11-05T14:18:22.817Z | 2024-11-09T14:22:28.214Z |
5478176 | 5478176 | 20241104033221_476LK | CZ000L | 2024-11-05T14:18:02.163Z | 2024-11-09T14:22:25.585Z |
5477613 | 5477613 | 20241104021322_oDgg4 | CZ000L | 2024-11-05T14:17:09.363Z | 2024-11-09T14:22:20.080Z |
5477534 | 5477534 | 20241104020606_w4mO0 | CZ000L | 2024-11-05T14:17:01.834Z | 2024-11-09T14:22:18.745Z |
5477422 | 5477422 | 20241104015024_3iqdW | CZ000L | 2024-11-05T14:16:52.307Z | 2024-11-09T14:22:17.573Z |
5477334 | 5477334 | 20241104013922_cgED9 | CZ000L | 2024-11-05T14:16:44.574Z | 2024-11-09T14:22:16.731Z |
5477312 | 5477312 | 20241104013545_z21sB | CZ000L | 2024-11-05T14:16:42.733Z | 2024-11-09T14:22:16.478Z |
5477309 | 5477309 | 20241104013521_LB2Mb | CZ000L | 2024-11-05T14:16:42.244Z | 2024-11-09T14:22:16.459Z |
5477170 | 5477170 | 20241104011133_22M17 | CZ000L | 2024-11-05T14:16:28.792Z | 2024-11-09T14:22:15.093Z |
5476931 | 5476931 | 20241104004324_vyn2S | CZ000L | 2024-11-05T14:16:12.856Z | 2024-11-09T14:22:13.425Z |
5476906 | 5476906 | 20241104004018_AarGc | CZ000L | 2024-11-05T14:16:11.558Z | 2024-11-09T14:22:13.245Z |
5476846 | 5476846 | 20241104003318_y20rJ | CZ000L | 2024-11-05T14:16:07.519Z | 2024-11-09T14:22:12.718Z |
5476383 | 5476383 | 20241103231837_LE5se | CZ000L | 2024-11-05T14:15:14.269Z | 2024-11-09T14:22:09.053Z |
5476315 | 5476315 | 20241103230700_cmMn7 | CZ000L | 2024-11-05T14:15:03.254Z | 2024-11-09T14:22:07.758Z |
5476041 | 5476041 | 20241103221114_borrz | CZ000L | 2024-11-05T14:14:41.238Z | 2024-11-09T14:22:05.008Z |
5475976 | 5475976 | 20241103220300_1D3m2 | CZ000L | 2024-11-05T14:14:36.889Z | 2024-11-09T14:22:04.369Z |
5475948 | 5475948 | 20241103215931_GBrUu | CZ000L | 2024-11-05T14:14:35.313Z | 2024-11-09T14:22:04.085Z |
5475857 | 5475857 | 20241103214150_hiSlK | CZ000L | 2024-11-05T14:14:23.348Z | 2024-11-09T14:22:02.963Z |
5475714 | 5475714 | 20241103210913_qqRbC | CZ000L | 2024-11-05T14:14:03.126Z | 2024-11-09T14:22:01.528Z |
5475695 | 5475695 | 20241103210411_Ruzi0 | CZ000L | 2024-11-05T14:14:01.653Z | 2024-11-09T14:22:01.209Z |
5475650 | 5475650 | 20241103205502_IErKJ | CZ000L | 2024-11-05T14:13:55.646Z | 2024-11-09T14:22:00.680Z |
5475517 | 5475517 | 20241103202210_TH6W6 | CZ000L | 2024-11-05T14:13:45.523Z | 2024-11-09T14:21:59.521Z |
5475257 | 5475257 | 20241103193801_R7GY2 | CZ000L | 2024-11-05T14:12:55.124Z | 2024-11-09T14:21:56.881Z |
5475065 | 5475065 | 20241103190052_Ibl0A | CZ000L | 2024-11-05T14:12:28.838Z | 2024-11-09T14:21:55.529Z |
5475024 | 5475024 | 20241103185212_uclmg | CZ000L | 2024-11-05T14:12:25.505Z | 2024-11-09T14:21:55.271Z |
5474994 | 5474994 | 20241103184716_NXiIX | CZ000L | 2024-11-05T14:12:22.764Z | 2024-11-09T14:21:55.091Z |
5474966 | 5474966 | 20241103184250_oys8f | CZ000L | 2024-11-05T14:12:20.297Z | 2024-11-09T14:21:54.812Z |
5474920 | 5474920 | 20241103183713_se4OL | CZ000L | 2024-11-05T14:12:16.730Z | 2024-11-09T14:21:54.300Z |
5474516 | 5474516 | 20241103173342_D7epj | CZ000L | 2024-11-05T14:11:11.854Z | 2024-11-09T14:21:47.603Z |
5474513 | 5474513 | 20241103173336_qipTy | CZ000L | 2024-11-05T14:11:11.611Z | 2024-11-09T14:21:47.513Z |
5474463 | 5474463 | 20241103172436_KkdVz | CZ000L | 2024-11-05T14:11:07.013Z | 2024-11-09T14:21:46.995Z |
5474440 | 5474440 | 20241103171932_Eo6FM | CZ000L | 2024-11-05T14:11:05.280Z | 2024-11-09T14:21:46.568Z |
5468977 | 5468977 | 20241103021843_mWrfk | CZ000L | 2024-11-04T14:15:20.130Z | 2024-11-09T14:23:00.559Z |
5468802 | 5468802 | 20241103015008_Zzad2 | CZ000L | 2024-11-04T14:15:04.639Z | 2024-11-09T14:22:59.694Z |
5468701 | 5468701 | 20241103012948_375Ze | CZ000L | 2024-11-04T14:14:56.574Z | 2024-11-09T14:22:59.359Z |
5468514 | 5468514 | 20241103005059_uXqf4 | CZ000L | 2024-11-04T14:14:17.703Z | 2024-11-09T14:22:58.639Z |
5468349 | 5468349 | 20241103001618_N8s3O | CZ000L | 2024-11-04T14:13:59.978Z | 2024-11-09T14:22:58.089Z |
5468341 | 5468341 | 20241103001439_Zi0JN | CZ000L | 2024-11-04T14:13:58.805Z | 2024-11-09T14:22:58.042Z |
5468329 | 5468329 | 20241103001214_qjKYD | CZ000L | 2024-11-04T14:13:57.854Z | 2024-11-09T14:22:58.016Z |
5468260 | 5468260 | 20241103000012_lo0ZD | CZ000L | 2024-11-04T14:13:50.927Z | 2024-11-09T14:22:57.775Z |
5468222 | 5468222 | 20241102235309_2NOhG | CZ000L | 2024-11-04T14:13:46.863Z | 2024-11-09T14:22:57.505Z |
5468092 | 5468092 | 20241102232730_18Epw | CZ000L | 2024-11-04T14:13:15.973Z | 2024-11-09T14:22:57.011Z |
5467936 | 5467936 | 20241102225829_a2YZE | CZ000L | 2024-11-04T14:12:59.098Z | 2024-11-09T14:22:56.082Z |
5467899 | 5467899 | 20241102225258_M32rR | CZ000L | 2024-11-04T14:12:55.877Z | 2024-11-09T14:22:55.917Z |
5467879 | 5467879 | 20241102224835_5TWTE | CZ000L | 2024-11-04T14:12:53.827Z | 2024-11-09T14:22:55.851Z |
5467860 | 5467860 | 20241102224741_OwIgl | CZ000L | 2024-11-04T14:12:45.992Z | 2024-11-09T14:22:55.817Z |
5467758 | 5467758 | 20241102223131_xSvne | CZ000L | 2024-11-04T14:12:28.441Z | 2024-11-09T14:22:55.588Z |
5467682 | 5467682 | 20241102221657_9L3MC | CZ000L | 2024-11-04T14:12:20.857Z | 2024-11-09T14:22:55.394Z |
5467457 | 5467457 | 20241102212243_FxtKV | CZ000L | 2024-11-04T14:11:34.672Z | 2024-11-09T14:22:54.666Z |
5467449 | 5467449 | 20241102211829_84At3 | CZ000L | 2024-11-04T14:11:33.186Z | 2024-11-09T14:22:54.640Z |
5467321 | 5467321 | 20241102204423_JhdgM | CZ000L | 2024-11-04T14:11:17.658Z | 2024-11-09T14:22:54.105Z |
5467302 | 5467302 | 20241102204144_ADchB | CZ000L | 2024-11-04T14:11:15.649Z | 2024-11-09T14:22:54.067Z |
5466952 | 5466952 | 20241102192851_b2pjF | CZ000L | 2024-11-04T14:10:21.937Z | 2024-11-09T14:22:52.854Z |
5466946 | 5466946 | 20241102192751_y2YcX | CZ000L | 2024-11-04T14:10:21.094Z | 2024-11-09T14:22:52.842Z |
5466788 | 5466788 | 20241102185705_TJ2PH | CZ000L | 2024-11-04T14:09:48.891Z | 2024-11-09T14:22:52.360Z |
5466776 | 5466776 | 20241102185219_3TiNT | CZ000L | 2024-11-04T14:09:46.120Z | 2024-11-09T14:22:52.280Z |
5466696 | 5466696 | 20241102183627_J3EZ6 | CZ000L | 2024-11-04T14:09:34.721Z | 2024-11-09T14:22:51.963Z |
5466667 | 5466667 | 20241102182904_3Hmys | CZ000L | 2024-11-04T14:09:31.595Z | 2024-11-09T14:22:51.909Z |
5466587 | 5466587 | 20241102181013_6g42M | CZ000L | 2024-11-04T14:09:23.366Z | 2024-11-09T14:22:51.451Z |
5466166 | 5466166 | 20241102163926_MZ2yX | CZ000L | 2024-11-04T14:08:08.571Z | 2024-11-09T14:22:49.760Z |
5450919 | 5450919 | 20241031214103_QrzGu | CZ000L | 2024-11-02T12:16:16.381Z | 2024-11-09T14:24:19.921Z |
5431265 | 5431265 | 20241029004531_UP5O8 | CZ000L | 2024-10-31T12:19:48.298Z | 2024-11-06T14:27:23.085Z |
5431029 | 5431029 | 20241029001808_2PAJP | CZ000L | 2024-10-31T12:19:29.429Z | 2024-11-06T14:27:22.531Z |
5430655 | 5430655 | 20241028231547_lr0ed | CZ000L | 2024-10-31T12:18:46.830Z | 2024-11-06T14:27:20.954Z |
5430628 | 5430628 | 20241028231257_XGzv6 | CZ000L | 2024-10-31T12:18:44.370Z | 2024-11-06T14:27:20.745Z |
5430546 | 5430546 | 20241028230135_OkeWZ | CZ000L | 2024-10-31T12:18:34.590Z | 2024-11-06T14:27:20.481Z |
5430483 | 5430483 | 20241028224051_FNC3z | CZ000L | 2024-10-31T12:18:27.079Z | 2024-11-06T14:27:20.251Z |
5430325 | 5430325 | 20241028220719_j9D2Z | CZ000L | 2024-10-31T12:18:07.586Z | 2024-11-06T14:27:19.536Z |
5429015 | 5429015 | 20241028183507_02Iny | CZ000L | 2024-10-31T12:15:52.080Z | 2024-11-06T14:27:14.905Z |
5428553 | 5428553 | 20241028173207_u7YXy | CZ000L | 2024-10-31T12:15:15.897Z | 2024-11-06T14:27:13.879Z |
5387118 | 5387118 | 20241025020147_CICI6 | CZ000L | 2024-10-27T12:20:53.435Z | 2024-11-02T12:28:32.134Z |
5387087 | 5387087 | 20241025015859_Hcwnc | CZ000L | 2024-10-27T12:20:51.995Z | 2024-11-02T12:28:32.109Z |
5385274 | 5385274 | 20241024221713_3Xvhm | CZ000L | 2024-10-27T12:18:39.928Z | 2024-11-02T12:28:29.438Z |
5385050 | 5385050 | 20241024214144_xM2SD | CZ000L | 2024-10-27T12:18:17.475Z | 2024-11-02T12:28:28.986Z |
5384983 | 5384983 | 20241024213028_8rFr0 | CZ000L | 2024-10-27T12:18:07.301Z | 2024-11-02T12:28:28.861Z |
5384518 | 5384518 | 20241024201621_a8dBR | CZ000L | 2024-10-27T12:17:09.482Z | 2024-11-02T12:28:27.290Z |
5384328 | 5384328 | 20241024195620_5v2cD | CZ000L | 2024-10-27T12:16:57.067Z | 2024-11-02T12:28:26.956Z |
5384168 | 5384168 | 20241024194327_WHoKU | CZ000L | 2024-10-27T12:16:50.550Z | 2024-11-02T12:28:26.811Z |
5383935 | 5383935 | 20241024191618_8eQ3L | CZ000L | 2024-10-27T12:16:29.187Z | 2024-11-02T12:28:26.576Z |
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);