participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,772 rows where station_code = "NZ003V" 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 |
---|---|---|---|---|---|
5573270 | 5573270 | 20241119095604_hNubf | NZ003V | 2024-11-22T14:19:47.689Z | 2024-11-22T14:19:47.689Z |
5560765 | 5560765 | 20241120141711_Xv6mP | NZ003V | 2024-11-21T14:09:43.413Z | 2024-11-22T14:19:21.729Z |
5560737 | 5560737 | 20241120141106_iKvm0 | NZ003V | 2024-11-21T14:09:40.997Z | 2024-11-22T14:19:21.724Z |
5560720 | 5560720 | 20241120140324_0SWBl | NZ003V | 2024-11-21T14:09:35.906Z | 2024-11-22T14:19:21.720Z |
5560716 | 5560716 | 20241120140233_jHreh | NZ003V | 2024-11-21T14:09:34.938Z | 2024-11-22T14:19:21.720Z |
5560480 | 5560480 | 20241120125525_FsPec | NZ003V | 2024-11-21T14:08:56.298Z | 2024-11-22T14:19:21.667Z |
5560430 | 5560430 | 20241120125119_FOVg1 | NZ003V | 2024-11-21T14:08:50.538Z | 2024-11-22T14:19:21.657Z |
5560403 | 5560403 | 20241120124741_yzZ3D | NZ003V | 2024-11-21T14:08:47.799Z | 2024-11-22T14:19:21.652Z |
5560378 | 5560378 | 20241120124519_1asLO | NZ003V | 2024-11-21T14:08:46.197Z | 2024-11-22T14:19:21.648Z |
5560170 | 5560170 | 20241120121203_zw35q | NZ003V | 2024-11-21T14:08:11.117Z | 2024-11-22T14:19:21.603Z |
5560139 | 5560139 | 20241120120727_tw0Ul | NZ003V | 2024-11-21T14:08:07.422Z | 2024-11-22T14:19:21.597Z |
5560049 | 5560049 | 20241120115143_whclI | NZ003V | 2024-11-21T14:07:56.175Z | 2024-11-22T14:19:21.575Z |
5560034 | 5560034 | 20241120114853_LzrF4 | NZ003V | 2024-11-21T14:07:54.172Z | 2024-11-22T14:19:21.573Z |
5559957 | 5559957 | 20241120113858_DBKMm | NZ003V | 2024-11-21T14:07:41.313Z | 2024-11-22T14:19:21.557Z |
5559889 | 5559889 | 20241120113029_MKXDy | NZ003V | 2024-11-21T14:07:28.899Z | 2024-11-22T14:19:21.544Z |
5559774 | 5559774 | 20241120111642_3xSIm | NZ003V | 2024-11-21T14:07:10.218Z | 2024-11-22T14:19:21.522Z |
5559571 | 5559571 | 20241120104423_Iy2rA | NZ003V | 2024-11-21T14:06:38.022Z | 2024-11-22T14:19:21.476Z |
5559529 | 5559529 | 20241120103910_5LVu4 | NZ003V | 2024-11-21T14:06:32.334Z | 2024-11-22T14:19:21.466Z |
5559319 | 5559319 | 20241120100306_90CW1 | NZ003V | 2024-11-21T14:05:57.868Z | 2024-11-22T14:19:21.416Z |
5559165 | 5559165 | 20241120093306_fZEQN | NZ003V | 2024-11-21T14:05:31.395Z | 2024-11-22T14:19:21.378Z |
5555761 | 5555761 | 20241119154402_t7kjI | NZ003V | 2024-11-20T14:06:33.459Z | 2024-11-22T14:20:13.633Z |
5555744 | 5555744 | 20241119152357_W0KUq | NZ003V | 2024-11-20T14:06:31.335Z | 2024-11-22T14:20:13.390Z |
5555715 | 5555715 | 20241119145708_KiK3P | NZ003V | 2024-11-20T14:06:27.968Z | 2024-11-22T14:20:12.744Z |
5555704 | 5555704 | 20241119145145_quLU4 | NZ003V | 2024-11-20T14:06:27.037Z | 2024-11-22T14:20:12.591Z |
5555667 | 5555667 | 20241119143229_Tk2T5 | NZ003V | 2024-11-20T14:06:22.563Z | 2024-11-22T14:20:12.168Z |
5555660 | 5555660 | 20241119142415_CLJJM | NZ003V | 2024-11-20T14:06:21.292Z | 2024-11-22T14:20:11.883Z |
5555611 | 5555611 | 20241119140711_3k8TV | NZ003V | 2024-11-20T14:06:07.320Z | 2024-11-22T14:20:10.873Z |
5555588 | 5555588 | 20241119135930_joalQ | NZ003V | 2024-11-20T14:06:03.586Z | 2024-11-22T14:20:10.571Z |
5555582 | 5555582 | 20241119135705_f4TGT | NZ003V | 2024-11-20T14:06:02.834Z | 2024-11-22T14:20:10.457Z |
5555577 | 5555577 | 20241119135540_avNKI | NZ003V | 2024-11-20T14:06:02.109Z | 2024-11-22T14:20:10.323Z |
5555540 | 5555540 | 20241119134429_rCHJk | NZ003V | 2024-11-20T14:05:56.358Z | 2024-11-22T14:20:09.261Z |
5555526 | 5555526 | 20241119134144_C5Uvk | NZ003V | 2024-11-20T14:05:55.361Z | 2024-11-22T14:20:09.108Z |
5555492 | 5555492 | 20241119133302_B6t3m | NZ003V | 2024-11-20T14:05:51.573Z | 2024-11-22T14:20:07.510Z |
5555475 | 5555475 | 20241119132536_vXEXX | NZ003V | 2024-11-20T14:05:43.797Z | 2024-11-22T14:20:07.108Z |
5555458 | 5555458 | 20241119132151_guhPz | NZ003V | 2024-11-20T14:05:41.375Z | 2024-11-22T14:20:06.804Z |
5555441 | 5555441 | 20241119131504_yews8 | NZ003V | 2024-11-20T14:05:38.445Z | 2024-11-22T14:20:06.510Z |
5555427 | 5555427 | 20241119131057_Zr2Gp | NZ003V | 2024-11-20T14:05:36.361Z | 2024-11-22T14:20:05.945Z |
5555420 | 5555420 | 20241119130908_jGAl3 | NZ003V | 2024-11-20T14:05:35.426Z | 2024-11-22T14:20:05.758Z |
5555399 | 5555399 | 20241119130339_3J2nY | NZ003V | 2024-11-20T14:05:29.928Z | 2024-11-22T14:20:05.372Z |
5555382 | 5555382 | 20241119130124_NBcrF | NZ003V | 2024-11-20T14:05:24.127Z | 2024-11-22T14:20:05.019Z |
5555341 | 5555341 | 20241119125044_6EPs2 | NZ003V | 2024-11-20T14:05:14.841Z | 2024-11-22T14:20:04.475Z |
5555333 | 5555333 | 20241119124750_PKhzS | NZ003V | 2024-11-20T14:05:13.033Z | 2024-11-22T14:20:04.307Z |
5555296 | 5555296 | 20241119123620_qEZPI | NZ003V | 2024-11-20T14:05:07.183Z | 2024-11-22T14:20:03.339Z |
5555289 | 5555289 | 20241119123548_1OXUq | NZ003V | 2024-11-20T14:05:06.823Z | 2024-11-22T14:20:03.218Z |
5555224 | 5555224 | 20241119121959_KBC3d | NZ003V | 2024-11-20T14:04:52.175Z | 2024-11-22T14:20:01.761Z |
5551932 | 5551932 | 20241118154258_Zhoda | NZ003V | 2024-11-19T14:05:48.903Z | 2024-11-22T14:22:13.067Z |
5551180 | 5551180 | 20241118124029_P9mVl | NZ003V | 2024-11-19T14:04:03.784Z | 2024-11-22T14:22:09.003Z |
5550923 | 5550923 | 20241118115000_UktmI | NZ003V | 2024-11-19T14:03:29.417Z | 2024-11-22T14:22:06.886Z |
5550884 | 5550884 | 20241118114207_CaqVZ | NZ003V | 2024-11-19T14:03:19.040Z | 2024-11-22T14:22:06.437Z |
5550699 | 5550699 | 20241118111102_bKOnK | NZ003V | 2024-11-19T14:02:56.316Z | 2024-11-22T14:22:04.933Z |
5550583 | 5550583 | 20241118105157_sdOQe | NZ003V | 2024-11-19T14:02:41.548Z | 2024-11-22T14:22:04.120Z |
5550324 | 5550324 | 20241118100752_oCJjW | NZ003V | 2024-11-19T14:02:11.778Z | 2024-11-22T14:22:01.447Z |
5550167 | 5550167 | 20241118094308_UvXA1 | NZ003V | 2024-11-19T14:01:40.742Z | 2024-11-22T14:21:59.193Z |
5550107 | 5550107 | 20241118093020_0YfpY | NZ003V | 2024-11-19T14:01:35.038Z | 2024-11-22T14:21:58.514Z |
5550049 | 5550049 | 20241118091746_G7HsO | NZ003V | 2024-11-19T14:01:30.097Z | 2024-11-22T14:21:57.265Z |
5547335 | 5547335 | 20241117154332_An29S | NZ003V | 2024-11-18T14:05:32.005Z | 2024-11-22T14:22:39.006Z |
5547295 | 5547295 | 20241117152757_8plme | NZ003V | 2024-11-18T14:05:26.303Z | 2024-11-22T14:22:38.371Z |
5547231 | 5547231 | 20241117151203_a50kG | NZ003V | 2024-11-18T14:05:18.898Z | 2024-11-22T14:22:38.103Z |
5547207 | 5547207 | 20241117150518_uwB0v | NZ003V | 2024-11-18T14:05:16.418Z | 2024-11-22T14:22:37.933Z |
5547198 | 5547198 | 20241117150458_HjEyT | NZ003V | 2024-11-18T14:05:16.044Z | 2024-11-22T14:22:37.894Z |
5547195 | 5547195 | 20241117150421_KKJA3 | NZ003V | 2024-11-18T14:05:15.751Z | 2024-11-22T14:22:37.893Z |
5547172 | 5547172 | 20241117150336_RrsAn | NZ003V | 2024-11-18T14:05:13.581Z | 2024-11-22T14:22:37.828Z |
5547061 | 5547061 | 20241117143101_DfQhn | NZ003V | 2024-11-18T14:04:52.463Z | 2024-11-22T14:22:36.624Z |
5547002 | 5547002 | 20241117140750_q7fw0 | NZ003V | 2024-11-18T14:04:41.187Z | 2024-11-22T14:22:36.324Z |
5546972 | 5546972 | 20241117134937_fhqMc | NZ003V | 2024-11-18T14:04:35.397Z | 2024-11-22T14:22:35.979Z |
5546942 | 5546942 | 20241117133234_04zSv | NZ003V | 2024-11-18T14:04:31.127Z | 2024-11-22T14:22:35.638Z |
5546932 | 5546932 | 20241117132626_5zf27 | NZ003V | 2024-11-18T14:04:29.420Z | 2024-11-22T14:22:35.547Z |
5546907 | 5546907 | 20241117132119_3khF2 | NZ003V | 2024-11-18T14:04:26.854Z | 2024-11-22T14:22:35.352Z |
5546894 | 5546894 | 20241117131851_MtupN | NZ003V | 2024-11-18T14:04:25.417Z | 2024-11-22T14:22:35.304Z |
5546874 | 5546874 | 20241117131058_dCd2t | NZ003V | 2024-11-18T14:04:23.352Z | 2024-11-22T14:22:35.242Z |
5546847 | 5546847 | 20241117130200_zO0UG | NZ003V | 2024-11-18T14:04:20.908Z | 2024-11-22T14:22:34.985Z |
5546813 | 5546813 | 20241117124857_IUN8B | NZ003V | 2024-11-18T14:04:16.460Z | 2024-11-22T14:22:34.744Z |
5546769 | 5546769 | 20241117124012_Zl3zX | NZ003V | 2024-11-18T14:04:12.312Z | 2024-11-22T14:22:34.572Z |
5546646 | 5546646 | 20241117120255_0FUJR | NZ003V | 2024-11-18T14:03:43.930Z | 2024-11-22T14:22:33.635Z |
5546616 | 5546616 | 20241117115638_Whida | NZ003V | 2024-11-18T14:03:39.724Z | 2024-11-22T14:22:33.407Z |
5546547 | 5546547 | 20241117113020_3gl3Y | NZ003V | 2024-11-18T14:03:27.445Z | 2024-11-22T14:22:32.557Z |
5546488 | 5546488 | 20241117111144_xdEo9 | NZ003V | 2024-11-18T14:03:13.001Z | 2024-11-22T14:22:32.264Z |
5546456 | 5546456 | 20241117110428_4fkAW | NZ003V | 2024-11-18T14:03:08.571Z | 2024-11-22T14:22:32.116Z |
5546444 | 5546444 | 20241117110043_2lMu4 | NZ003V | 2024-11-18T14:03:07.567Z | 2024-11-22T14:22:32.045Z |
5546436 | 5546436 | 20241117105714_CpUya | NZ003V | 2024-11-18T14:03:06.627Z | 2024-11-22T14:22:32.006Z |
5546404 | 5546404 | 20241117104622_Yzo3I | NZ003V | 2024-11-18T14:03:01.944Z | 2024-11-22T14:22:31.803Z |
5546242 | 5546242 | 20241117100406_wCqgI | NZ003V | 2024-11-18T14:02:33.022Z | 2024-11-22T14:22:30.492Z |
5546111 | 5546111 | 20241117091632_R1T5D | NZ003V | 2024-11-18T14:02:06.438Z | 2024-11-22T14:22:29.195Z |
5544806 | 5544806 | 20241116153903_WB3cw | NZ003V | 2024-11-17T14:02:10.122Z | 2024-11-22T14:23:06.314Z |
5544787 | 5544787 | 20241116152148_5YrIz | NZ003V | 2024-11-17T14:02:06.610Z | 2024-11-22T14:23:06.293Z |
5544754 | 5544754 | 20241116150352_Zvh1D | NZ003V | 2024-11-17T14:02:01.108Z | 2024-11-22T14:23:06.151Z |
5544740 | 5544740 | 20241116145646_e67MM | NZ003V | 2024-11-17T14:01:59.306Z | 2024-11-22T14:23:06.102Z |
5544729 | 5544729 | 20241116145118_mNBEH | NZ003V | 2024-11-17T14:01:56.623Z | 2024-11-22T14:23:05.936Z |
5544703 | 5544703 | 20241116143138_mHX1y | NZ003V | 2024-11-17T14:01:52.917Z | 2024-11-22T14:23:05.867Z |
5544672 | 5544672 | 20241116140218_bYy43 | NZ003V | 2024-11-17T14:01:49.247Z | 2024-11-22T14:23:05.350Z |
5544612 | 5544612 | 20241116130328_AJuWr | NZ003V | 2024-11-17T14:01:40.722Z | 2024-11-22T14:23:04.827Z |
5544520 | 5544520 | 20241116121041_R3sR2 | NZ003V | 2024-11-17T14:01:24.033Z | 2024-11-22T14:23:03.823Z |
5536128 | 5536128 | 20241112154546_0PakV | NZ003V | 2024-11-14T14:09:13.019Z | 2024-11-21T14:25:56.916Z |
5536105 | 5536105 | 20241112154033_3gB8T | NZ003V | 2024-11-14T14:09:11.870Z | 2024-11-21T14:25:56.725Z |
5535751 | 5535751 | 20241112140711_U3Xne | NZ003V | 2024-11-14T14:08:41.319Z | 2024-11-21T14:25:52.811Z |
5520418 | 5520418 | 20241111154201_zxGBc | NZ003V | 2024-11-12T14:06:17.136Z | 2024-11-20T14:25:08.586Z |
5520410 | 5520410 | 20241111154055_M5TUi | NZ003V | 2024-11-12T14:06:16.546Z | 2024-11-20T14:25:08.585Z |
5520389 | 5520389 | 20241111153239_TxCuT | NZ003V | 2024-11-12T14:06:14.816Z | 2024-11-20T14:25:07.728Z |
5520375 | 5520375 | 20241111153014_DmsQQ | NZ003V | 2024-11-12T14:06:13.923Z | 2024-11-20T14:25:07.638Z |
5520362 | 5520362 | 20241111152921_JUCck | NZ003V | 2024-11-12T14:06:13.021Z | 2024-11-20T14:25:07.624Z |
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);