participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
937 rows where station_code = "RU0014" 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 |
---|---|---|---|---|---|
2229735 | 2229735 | 20230124161715_WyOt9 | RU0014 | 2024-01-05T23:54:41.086Z | 2024-01-05T23:54:41.086Z |
2226693 | 2226693 | 20230123174256_jRuyI | RU0014 | 2024-01-05T23:54:38.102Z | 2024-01-05T23:54:38.102Z |
1760880 | 1760880 | 20221011200347_anGja | RU0014 | 2024-01-05T23:51:00.300Z | 2024-01-05T23:51:00.300Z |
1760878 | 1760878 | 20221011200107_z2Uw5 | RU0014 | 2024-01-05T23:51:00.299Z | 2024-01-05T23:51:00.299Z |
1760654 | 1760654 | 20221011180124_HI5R3 | RU0014 | 2024-01-05T23:51:00.273Z | 2024-01-05T23:51:00.273Z |
1751549 | 1751549 | 20221008015503_7KJJd | RU0014 | 2024-01-05T23:50:53.125Z | 2024-01-05T23:50:53.125Z |
1750524 | 1750524 | 20221007203930_tUn93 | RU0014 | 2024-01-05T23:50:53.034Z | 2024-01-05T23:50:53.034Z |
1750270 | 1750270 | 20221007180046_XfWRq | RU0014 | 2024-01-05T23:50:53.005Z | 2024-01-05T23:50:53.005Z |
1750229 | 1750229 | 20221007160024_d9VLP | RU0014 | 2024-01-05T23:50:52.999Z | 2024-01-05T23:50:52.999Z |
1747383 | 1747383 | 20221006220508_BFNBS | RU0014 | 2024-01-05T23:50:51.117Z | 2024-01-05T23:50:51.117Z |
1726251 | 1726251 | 20221002002127_D52HH | RU0014 | 2024-01-05T23:50:40.926Z | 2024-01-05T23:50:40.926Z |
1726135 | 1726135 | 20221001234438_ShEUO | RU0014 | 2024-01-05T23:50:40.909Z | 2024-01-05T23:50:40.909Z |
1726107 | 1726107 | 20221001233610_895KA | RU0014 | 2024-01-05T23:50:40.905Z | 2024-01-05T23:50:40.905Z |
1725979 | 1725979 | 20221001230908_idtI7 | RU0014 | 2024-01-05T23:50:40.891Z | 2024-01-05T23:50:40.891Z |
1725562 | 1725562 | 20221001202056_5HyVR | RU0014 | 2024-01-05T23:50:40.834Z | 2024-01-05T23:50:40.834Z |
1725507 | 1725507 | 20221001193411_ZcrPm | RU0014 | 2024-01-05T23:50:40.826Z | 2024-01-05T23:50:40.826Z |
1725420 | 1725420 | 20221001183327_HGtKy | RU0014 | 2024-01-05T23:50:40.813Z | 2024-01-05T23:50:40.813Z |
1725403 | 1725403 | 20221001181555_3I38e | RU0014 | 2024-01-05T23:50:40.810Z | 2024-01-05T23:50:40.810Z |
1725393 | 1725393 | 20221001180458_4VDLd | RU0014 | 2024-01-05T23:50:40.809Z | 2024-01-05T23:50:40.809Z |
1725384 | 1725384 | 20221001175613_l2dLs | RU0014 | 2024-01-05T23:50:40.807Z | 2024-01-05T23:50:40.807Z |
1725345 | 1725345 | 20221001162605_iK2hR | RU0014 | 2024-01-05T23:50:40.802Z | 2024-01-05T23:50:40.802Z |
1725339 | 1725339 | 20221001161721_ohmDi | RU0014 | 2024-01-05T23:50:40.801Z | 2024-01-05T23:50:40.801Z |
1720557 | 1720557 | 20220930223733_KQuWB | RU0014 | 2024-01-05T23:50:39.030Z | 2024-01-05T23:50:39.030Z |
1720187 | 1720187 | 20220930193746_L63wc | RU0014 | 2024-01-05T23:50:38.983Z | 2024-01-05T23:50:38.983Z |
1720092 | 1720092 | 20220930181808_cR3ES | RU0014 | 2024-01-05T23:50:38.969Z | 2024-01-05T23:50:38.969Z |
1720096 | 1720096 | 20220930181957_ei8sE | RU0014 | 2024-01-05T23:50:38.969Z | 2024-01-05T23:50:38.969Z |
1713615 | 1713615 | 20220929215106_W5bf6 | RU0014 | 2024-01-05T23:50:37.120Z | 2024-01-05T23:50:37.120Z |
1713600 | 1713600 | 20220929214920_WablH | RU0014 | 2024-01-05T23:50:37.119Z | 2024-01-05T23:50:37.119Z |
1700668 | 1700668 | 20220926235554_5j3HY | RU0014 | 2024-01-05T23:50:31.214Z | 2024-01-05T23:50:31.214Z |
1700382 | 1700382 | 20220926215338_nqywJ | RU0014 | 2024-01-05T23:50:31.172Z | 2024-01-05T23:50:31.172Z |
1700356 | 1700356 | 20220926213502_fMdR4 | RU0014 | 2024-01-05T23:50:31.167Z | 2024-01-05T23:50:31.167Z |
1700314 | 1700314 | 20220926211444_qoi3j | RU0014 | 2024-01-05T23:50:31.158Z | 2024-01-05T23:50:31.158Z |
1700045 | 1700045 | 20220926191755_kYruM | RU0014 | 2024-01-05T23:50:31.054Z | 2024-01-05T23:50:31.054Z |
1699965 | 1699965 | 20220926175446_MqYtR | RU0014 | 2024-01-05T23:50:31.034Z | 2024-01-05T23:50:31.034Z |
1699929 | 1699929 | 20220926165602_spUBX | RU0014 | 2024-01-05T23:50:31.025Z | 2024-01-05T23:50:31.025Z |
1697488 | 1697488 | 20220925215807_T1Jk7 | RU0014 | 2024-01-05T23:50:28.962Z | 2024-01-05T23:50:28.962Z |
1697404 | 1697404 | 20220925202524_BT5yZ | RU0014 | 2024-01-05T23:50:28.950Z | 2024-01-05T23:50:28.950Z |
1692120 | 1692120 | 20220924220023_jfp4L | RU0014 | 2024-01-05T23:50:26.991Z | 2024-01-05T23:50:26.991Z |
1691828 | 1691828 | 20220924203909_thnFR | RU0014 | 2024-01-05T23:50:26.960Z | 2024-01-05T23:50:26.960Z |
1691629 | 1691629 | 20220924191511_kVXZk | RU0014 | 2024-01-05T23:50:26.938Z | 2024-01-05T23:50:26.938Z |
1691606 | 1691606 | 20220924183023_D8msK | RU0014 | 2024-01-05T23:50:26.935Z | 2024-01-05T23:50:26.935Z |
1691581 | 1691581 | 20220924180530_XMlLZ | RU0014 | 2024-01-05T23:50:26.931Z | 2024-01-05T23:50:26.931Z |
1669141 | 1669141 | 20220918192340_JfjlN | RU0014 | 2024-01-05T23:50:15.270Z | 2024-01-05T23:50:15.270Z |
1669126 | 1669126 | 20220918185052_NvsJs | RU0014 | 2024-01-05T23:50:15.268Z | 2024-01-05T23:50:15.268Z |
1669109 | 1669109 | 20220918172846_EDojY | RU0014 | 2024-01-05T23:50:15.265Z | 2024-01-05T23:50:15.265Z |
1666119 | 1666119 | 20220917225923_u82T7 | RU0014 | 2024-01-05T23:50:13.565Z | 2024-01-05T23:50:13.565Z |
1666086 | 1666086 | 20220917225101_O1VM3 | RU0014 | 2024-01-05T23:50:13.561Z | 2024-01-05T23:50:13.561Z |
1665662 | 1665662 | 20220917204000_fBNel | RU0014 | 2024-01-05T23:50:13.514Z | 2024-01-05T23:50:13.514Z |
1665493 | 1665493 | 20220917184115_02AbN | RU0014 | 2024-01-05T23:50:13.493Z | 2024-01-05T23:50:13.493Z |
1665481 | 1665481 | 20220917173151_VvFIz | RU0014 | 2024-01-05T23:50:13.491Z | 2024-01-05T23:50:13.491Z |
1665471 | 1665471 | 20220917164050_0dAT9 | RU0014 | 2024-01-05T23:50:13.489Z | 2024-01-05T23:50:13.489Z |
1656318 | 1656318 | 20220915213834_WmYnV | RU0014 | 2024-01-05T23:50:09.989Z | 2024-01-05T23:50:09.989Z |
1654098 | 1654098 | 20220914205409_W28fi | RU0014 | 2024-01-05T23:50:08.466Z | 2024-01-05T23:50:08.466Z |
1651557 | 1651557 | 20220912165921_mnuwX | RU0014 | 2024-01-05T23:50:05.817Z | 2024-01-05T23:50:05.817Z |
1651560 | 1651560 | 20220912172218_2DkJV | RU0014 | 2024-01-05T23:50:05.817Z | 2024-01-05T23:50:05.817Z |
1651540 | 1651540 | 20220912162143_oilwZ | RU0014 | 2024-01-05T23:50:05.814Z | 2024-01-05T23:50:05.814Z |
1650674 | 1650674 | 20220911212453_3ct0W | RU0014 | 2024-01-05T23:50:04.501Z | 2024-01-05T23:50:04.501Z |
1650499 | 1650499 | 20220911183604_YjGjE | RU0014 | 2024-01-05T23:50:04.476Z | 2024-01-05T23:50:04.476Z |
1650501 | 1650501 | 20220911184223_LNZ5h | RU0014 | 2024-01-05T23:50:04.476Z | 2024-01-05T23:50:04.476Z |
1650486 | 1650486 | 20220911173528_C12p1 | RU0014 | 2024-01-05T23:50:04.474Z | 2024-01-05T23:50:04.474Z |
1649368 | 1649368 | 20220910191101_q8AmM | RU0014 | 2024-01-05T23:50:03.212Z | 2024-01-05T23:50:03.212Z |
1649364 | 1649364 | 20220910190156_I3jCO | RU0014 | 2024-01-05T23:50:03.211Z | 2024-01-05T23:50:03.211Z |
1648730 | 1648730 | 20220909210915_WEM9J | RU0014 | 2024-01-05T23:50:01.933Z | 2024-01-05T23:50:01.933Z |
1647832 | 1647832 | 20220908231235_SmcPj | RU0014 | 2024-01-05T23:50:00.633Z | 2024-01-05T23:50:00.633Z |
1647750 | 1647750 | 20220908204021_yEr7K | RU0014 | 2024-01-05T23:50:00.621Z | 2024-01-05T23:50:00.621Z |
1647732 | 1647732 | 20220908201104_C3ZBv | RU0014 | 2024-01-05T23:50:00.619Z | 2024-01-05T23:50:00.619Z |
1647678 | 1647678 | 20220908180343_9u2B9 | RU0014 | 2024-01-05T23:50:00.611Z | 2024-01-05T23:50:00.611Z |
1646558 | 1646558 | 20220907204557_Z7tHx | RU0014 | 2024-01-05T23:49:59.310Z | 2024-01-05T23:49:59.310Z |
1633007 | 1633007 | 20220903181336_Ng3nM | RU0014 | 2024-01-05T23:49:50.047Z | 2024-01-05T23:49:50.047Z |
1630342 | 1630342 | 20220903000716_Uqi1A | RU0014 | 2024-01-05T23:49:49.719Z | 2024-01-05T23:49:49.719Z |
1626695 | 1626695 | 20220902004617_l6EAF | RU0014 | 2024-01-05T23:49:47.940Z | 2024-01-05T23:49:47.940Z |
1625730 | 1625730 | 20220901185954_x3f3X | RU0014 | 2024-01-05T23:49:47.811Z | 2024-01-05T23:49:47.811Z |
1622609 | 1622609 | 20220901005313_uy2RC | RU0014 | 2024-01-05T23:49:46.201Z | 2024-01-05T23:49:46.201Z |
1620940 | 1620940 | 20220831191459_HyxmH | RU0014 | 2024-01-05T23:49:45.991Z | 2024-01-05T23:49:45.991Z |
1616290 | 1616290 | 20220830203913_8xFzO | RU0014 | 2024-01-05T23:49:43.727Z | 2024-01-05T23:49:43.727Z |
1616045 | 1616045 | 20220830172046_1CKOI | RU0014 | 2024-01-05T23:49:43.667Z | 2024-01-05T23:49:43.667Z |
1612811 | 1612811 | 20220830011508_5MbyM | RU0014 | 2024-01-05T23:49:40.717Z | 2024-01-05T23:49:40.717Z |
1612376 | 1612376 | 20220830002606_pLEGA | RU0014 | 2024-01-05T23:49:40.670Z | 2024-01-05T23:49:40.670Z |
1611884 | 1611884 | 20220829232052_Cd6b2 | RU0014 | 2024-01-05T23:49:40.617Z | 2024-01-05T23:49:40.617Z |
1611459 | 1611459 | 20220829221333_rzAue | RU0014 | 2024-01-05T23:49:40.567Z | 2024-01-05T23:49:40.567Z |
1610703 | 1610703 | 20220829183317_C0lpR | RU0014 | 2024-01-05T23:49:40.481Z | 2024-01-05T23:49:40.481Z |
1607891 | 1607891 | 20220828231121_yQ1Yo | RU0014 | 2024-01-05T23:49:38.584Z | 2024-01-05T23:49:38.584Z |
1607830 | 1607830 | 20220828224221_TH5eV | RU0014 | 2024-01-05T23:49:38.574Z | 2024-01-05T23:49:38.574Z |
1607555 | 1607555 | 20220828204041_NsDOW | RU0014 | 2024-01-05T23:49:38.533Z | 2024-01-05T23:49:38.533Z |
1602646 | 1602646 | 20220827210429_AipMk | RU0014 | 2024-01-05T23:49:36.652Z | 2024-01-05T23:49:36.652Z |
1602454 | 1602454 | 20220827192058_ckW3A | RU0014 | 2024-01-05T23:49:36.628Z | 2024-01-05T23:49:36.628Z |
1602448 | 1602448 | 20220827191142_hTJAa | RU0014 | 2024-01-05T23:49:36.627Z | 2024-01-05T23:49:36.627Z |
1602436 | 1602436 | 20220827183053_2KZ21 | RU0014 | 2024-01-05T23:49:36.625Z | 2024-01-05T23:49:36.625Z |
1602428 | 1602428 | 20220827181229_tbAOy | RU0014 | 2024-01-05T23:49:36.624Z | 2024-01-05T23:49:36.624Z |
1598505 | 1598505 | 20220826203652_UonY5 | RU0014 | 2024-01-05T23:49:33.059Z | 2024-01-05T23:49:33.059Z |
1598412 | 1598412 | 20220826192451_Qtd8J | RU0014 | 2024-01-05T23:49:33.028Z | 2024-01-05T23:49:33.028Z |
1594453 | 1594453 | 20220825191909_md8Sj | RU0014 | 2024-01-05T23:49:30.095Z | 2024-01-05T23:49:30.095Z |
1594405 | 1594405 | 20220825181010_a2YBI | RU0014 | 2024-01-05T23:49:30.080Z | 2024-01-05T23:49:30.080Z |
1592371 | 1592371 | 20220824220332_JLEMe | RU0014 | 2024-01-05T23:49:27.009Z | 2024-01-05T23:49:27.009Z |
1592304 | 1592304 | 20220824214417_g0CQk | RU0014 | 2024-01-05T23:49:26.971Z | 2024-01-05T23:49:26.971Z |
1589912 | 1589912 | 20220823232552_aS123 | RU0014 | 2024-01-05T23:49:24.447Z | 2024-01-05T23:49:24.447Z |
1589463 | 1589463 | 20220823210651_TLfQS | RU0014 | 2024-01-05T23:49:24.383Z | 2024-01-05T23:49:24.383Z |
1589345 | 1589345 | 20220823184112_I3rUH | RU0014 | 2024-01-05T23:49:24.363Z | 2024-01-05T23:49:24.363Z |
1589337 | 1589337 | 20220823175959_viKQp | RU0014 | 2024-01-05T23:49:24.361Z | 2024-01-05T23:49:24.361Z |
1587379 | 1587379 | 20220823011609_UCVSF | RU0014 | 2024-01-05T23:49:22.626Z | 2024-01-05T23:49:22.626Z |
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);