names

192 rows where place_id = 603850

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655973 1912119 1912119 plaintiff Burlas Walter   603850 603850 Burlas, Walter, of Cornwall 0
3658472 1912902 1912902 plaintiff Eyre James esq & Sheriff 603850 603850 Eyre, James, of Cornwall, esq & Sheriff 0
3666970 1915613 1915613 defendant Mose Richard husbandman 603850 603850 Mose, Richard, of Cornwall, husbandman 2
3717852 1931886 1931886 plaintiff Enys Nicholas (legal representative) 603850 603850 Enys, Nicholas, of Cornwall, gent, executor of 0
3728206 1935084 1935084 defendant Code Richard (legal representative) 603850 603850 Code, Richard, of Cornwall, esq, executrix of 0
3832520 1968089 1968089 defendant Calwoodlegh John (legal representative) 603850 603850 Calwoodlegh, John, of Cornwall, gent, executor of 0
3978915 2017210 2017210 plaintiff Morrys John gent 603850 603850 Morrys, John, of Cornwall, gent 0
4340101 2143803 2143803 defendant Hender John esq 603850 603850 Hender, John, of Cornwall, esq 1
4418326 2170614 2170614 defendant Bosvenon Alan   603850 603850 Bosvenon, Alan, of Cornwall 0
4442660 2182654 2182654 defendant Servyngton Richard   603850 603850 Servyngton, Richard, of Cornwall 0
4442664 2182655 2182655 defendant Servyngton Richard   603850 603850 Servyngton, Richard, of Cornwall 0
4450370 2185073 2185073 defendant Lorymer Michael   603850 603850 Lorymer, Michael, of Cornwall 1
4450371 2185073 2185073 defendant Crofton John   603850 603850 Crofton, John, of Cornwall 2
4454220 2186335 2186335 defendant Bokelly Nicholas   603850 603850 Bokelly, Nicholas, of Cornwall 0
4454222 2186336 2186336 defendant Bokelly Nicholas   603850 603850 Bokelly, Nicholas, of Cornwall 0
4454224 2186337 2186337 defendant Bokelly Nicholas   603850 603850 Bokelly, Nicholas, of Cornwall 0
4457949 2187505 2187505 defendant Lercedekene Warin   603850 603850 Lercedekene, Warin, of Cornwall, knight 0
4457951 2187506 2187506 defendant Lercedekene Warin   603850 603850 Lercedekene, Warin, of Cornwall, knight 0
4474611 2192720 2192720 defendant Ilcombe Henry   603850 603850 Ilcombe, Henry, of Cornwall, knight 0
4474613 2192721 2192721 defendant Ilcombe Henry   603850 603850 Ilcombe, Henry, of Cornwall, knight 0
4480774 2194653 2194653 defendant Palmer William   603850 603850 Palmer, William, of Cornwall 0
4481442 2194889 2194889 defendant Herle John   603850 603850 Herle, John, of Cornwall, formerly sheriff 0
4481446 2194890 2194890 defendant Herle John   603850 603850 Herle, John, of Cornwall, formerly sheriff 0
4481450 2194891 2194891 defendant Herle John   603850 603850 Herle, John, of Cornwall, formerly sheriff 0
4482050 2195097 2195097 plaintiff Martyn Geoffrey   603850 603850 Martyn, Geoffrey, of Cornwall 0
4486647 2196536 2196536 plaintiff Savage John esq 603850 603850 Savage, John, of Cornwall, esq 0
4489739 2197505 2197505 defendant Whalesbrowe Benedict   603850 603850 Whalesbrowe, Benedict, of Cornwall, parson of St Mannan's church 2
4493106 2198544 2198544 defendant Tregois William   603850 603850 Tregois, William, of Cornwall 0
4497558 2199881 2199881 defendant Ilcombe Henry   603850 603850 Ilcombe, Henry, of Cornwall, knight 0
4503725 2201730 2201730 defendant Langurdewe John   603850 603850 Langurdewe, John, of Cornwall 0
4512319 2204293 2204293 defendant Lanyeyn Ralph   603850 603850 Lanyeyn, Ralph, of Cornwall 0
4513210 2204555 2204555 defendant Jones John   603850 603850 Jones, John, of Cornwall 5
4514707 2205015 2205015 defendant Tame Richard   603850 603850 Tame, Richard, of Cornwall 2
4516824 2205668 2205668 defendant Lanhyer John   603850 603850 Lanhyer, John, of Cornwall 0
4516826 2205668 2205668 defendant Monk (illegible) esq 603850 603850 Monk, _, of Cornwall, esq 2
4516835 2205669 2205669 defendant Menehere Walter   603850 603850 Menehere, Walter, of Cornwall 3
4528772 2209284 2209284 plaintiff Megre John   603850 603850 Megre, John, of Cornwall 0
4528773 2209284 2209284 defendant Ilcombe Henry   603850 603850 Ilcombe, Henry, of Cornwall, knight 0
4530357 2209781 2209781 defendant Gelys John   603850 603850 Gelys, John, of Cornwall 2
4530361 2209782 2209782 defendant Gelys John   603850 603850 Gelys, John, of Cornwall 2
4532083 2210300 2210300 defendant Langurdow John   603850 603850 Langurdow, John, of Cornwall 0
4539288 2212545 2212545 defendant Mate David   603850 603850 Mate, David, of Cornwall 3
4539403 2212582 2212582 defendant Trewyt_sa Philip   603850 603850 Trewyt_sa, Philip, of Cornwall 0
4549504 2215790 2215790 defendant Tretthian Thomas   603850 603850 Tretthian, Thomas, of Cornwall 0
4553577 2217049 2217049 defendant Gerveys Henry   603850 603850 Gerveys, Henry, of Cornwall 4
4553578 2217049 2217049 defendant Bodolget John   603850 603850 Bodolget, John, of Cornwall 5
4553584 2217050 2217050 defendant Gerveys Henry   603850 603850 Gerveys, Henry, of Cornwall 4
4553585 2217050 2217050 defendant Bodolget John   603850 603850 Bodolget, John, of Cornwall 5
4556470 2217965 2217965 defendant Hille John   603850 603850 Hille, John, of Cornwall 3
4560186 2219132 2219132 defendant Lenoye John   603850 603850 Lenoye, John, of Cornwall 0
4567977 2221552 2221552 defendant Peupons Thomas   603850 603850 Peupons, Thomas, of Cornwall 0
4569725 2222114 2222114 defendant Bodrugan William   603850 603850 Bodrugan, William, of Cornwall 4
4569821 2222133 2222133 defendant Bodrugan William   603850 603850 Bodrugan, William, of Cornwall 3
4569824 2222134 2222134 defendant Treverbyn James esq 603850 603850 Treverbyn, James, of Cornwall, esq 1
4571281 2222594 2222594 defendant Cartere John   603850 603850 Cartere, John, of Cornwall 0
4575022 2223710 2223710 defendant Trevhelek William esq 603850 603850 Trevhelek, William, of Cornwall, esq 2
4575027 2223711 2223711 defendant Trevhelek William esq 603850 603850 Trevhelek, William, of Cornwall, esq 2
4576094 2224021 2224021 defendant Basset John esq 603850 603850 Basset, John, of Cornwall, esq 0
4579359 2225024 2225024 defendant Lanhir John   603850 603850 Lanhir, John, of Cornwall 0
4579366 2225025 2225025 defendant Lanhire John   603850 603850 Lanhire, John, of Cornwall 0
4581442 2225663 2225663 defendant Curteys John   603850 603850 Curteys, John, of Cornwall 0
4581447 2225663 2225663 defendant Cornyssh John esq 603850 603850 Cornyssh, John, of Cornwall, esq 5
4582467 2225957 2225957 defendant Cartere John   603850 603850 Cartere, John, of Cornwall 2
4582553 2225985 2225985 defendant Colyn Thomas esq 603850 603850 Colyn, Thomas, of Cornwall, esq 3
4582561 2225986 2225986 defendant Colyn Thomas esq 603850 603850 Colyn, Thomas, of Cornwall, esq 6
4586558 2227205 2227205 defendant Hunter John   603850 603850 Hunter, John, of Cornwall 2
4588751 2227864 2227864 defendant Herman Pollerus   603850 603850 Herman, Pollerus, of Cornwall 0
4591870 2228811 2228811 defendant Lenoye John   603850 603850 Lenoye, John, of Cornwall 0
4593705 2229304 2229304 defendant Gerveys John   603850 603850 Gerveys, John, of Cornwall 0
4593707 2229305 2229305 defendant Jerveys John esq 603850 603850 Jerveys, John, of Cornwall, esq 0
4594324 2229481 2229481 defendant St Aubyn Guy (legal representative) 603850 603850 St Aubyn, Guy, of Cornwall, executors of 0
4596631 2230182 2230182 defendant Halom James   603850 603850 Halom, James, of Cornwall 0
4598652 2230816 2230816 defendant Hery John   603850 603850 Hery, John, of Cornwall 4
4600756 2231465 2231465 defendant Tremayn Richard esq 603850 603850 Tremayn, Richard, of Cornwall, esq 0
4600759 2231465 2231465 defendant Trevaynon Robert   603850 603850 Trevaynon, Robert, of Cornwall, esq, adminstrators of 3
4602677 2232049 2232049 defendant Myles John   603850 603850 Myles, John, of Cornwall 5
4603244 2232218 2232218 defendant Polmerough John esq 603850 603850 Polmerough, John, of Cornwall, esq 2
4603253 2232220 2232220 defendant polmorough John   603850 603850 polmorough, John, of Cornwall 3
4603256 2232220 2232220 defendant Arundell John   603850 603850 Arundell, John, of Cornwall, knight 6
4608401 2233738 2233738 defendant Scarlet John   603850 603850 Scarlet, John, of Cornwall 3
4608438 2233748 2233748 defendant Scarlet John   603850 603850 Scarlet, John, of Cornwall 3
4608446 2233749 2233749 defendant Juyl Katherine   603850 603850 Juyl, Katherine, of Cornwall 3
4609064 2233936 2233936 plaintiff Bromford Nicholas   603850 603850 Bromford, Nicholas, of Cornwall 0
4609066 2233937 2233937 plaintiff Bromford Nicholas   603850 603850 Bromford, Nicholas, of Cornwall 0
4610630 2234391 2234391 defendant St Aubyn John esq 603850 603850 St Aubyn, John, of Cornwall, esq 0
4610633 2234392 2234392 defendant St Aubyn John   603850 603850 St Aubyn, John, of Cornwall 0
4612239 2234890 2234890 defendant Lanhier John   603850 603850 Lanhier, John, of Cornwall 0
4612479 2234970 2234970 defendant Arundell John   603850 603850 Arundell, John, of Cornwall, knight 0
4612958 2235111 2235111 defendant Hille John esq 603850 603850 Hille, John, of Cornwall, esq 2
4617906 2236602 2236602 defendant Polmorva John esq 603850 603850 Polmorva, John, of Cornwall, esq 1
4623344 2238272 2238272 defendant Cheynduyt John esq 603850 603850 Cheynduyt, John, of Cornwall, esq 0
4624430 2238625 2238625 defendant Bromford Nicholas   603850 603850 Bromford, Nicholas, of Cornwall 0
4624432 2238626 2238626 defendant Bromford Nicholas   603850 603850 Bromford, Nicholas, of Cornwall 0
4624787 2238733 2238733 defendant Joselyn Walter   603850 603850 Joselyn, Walter, of Cornwall 0
4624788 2238733 2238733 defendant Bodygood Henry   603850 603850 Bodygood, Henry, of Cornwall 1
4626069 2239112 2239112 defendant St Aubyn Guy (legal representative) 603850 603850 St Aubyn, Guy, of Cornwall, executors of 0
4626457 2239224 2239224 defendant Flaunak Richard   603850 603850 Flaunak, Richard, of Cornwall 0
4630416 2240422 2240422 defendant Baudyn William   603850 603850 Baudyn, William, of Cornwall 1
4630419 2240423 2240423 defendant Baudyn William   603850 603850 Baudyn, William, of Cornwall 1
4631024 2240596 2240596 defendant Gorlyn Henry   603850 603850 Gorlyn, Henry, of Cornwall 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);