names

48 rows where place_id = 592658

✎ 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
3608434 1870297 1870297 defendant Rede John barber 592658 592658 Rede, John, of Cliff juxta Lewes, barber 0
3608435 1870297 1870297 defendant Allard John yeoman 592658 592658 Allard, John, of Cliff juxta Lewes, yeoman 1
3608446 1870302 1870302 defendant Rede John barber 592658 592658 Rede, John, of Cliff juxta Lewes, barber 0
3608447 1870302 1870302 defendant Allard John yeoman 592658 592658 Allard, John, of Cliff juxta Lewes, yeoman 1
3712508 1930228 1930228 defendant Downer Peter beer brewer 592658 592658 Downer, Peter, of Cliff juxta Lewes, beer brewer 0
3791760 1955266 1955266 defendant Underdoun Thomas husbandman 592658 592658 Underdoun, Thomas, of Cliff juxta Lewes, husbandman 2
3811973 1961652 1961652 defendant Coltherst Thomas laborer 592658 592658 Coltherst, Thomas, of Cliff juxta Lewes, laborer 1
4095216 2058611 2058611 defendant Watson Thomas yeoman 592658 592658 Watson, Thomas, of Cliff juxta Lewes, yeoman 0
4095218 2058612 2058612 defendant Watson Thomas yeoman 592658 592658 Watson, Thomas, of Cliff juxta Lewes, yeoman 0
4098767 2059889 2059889 defendant Pollye Henry yeoman 592658 592658 Pollye, Henry, of Cliff juxta Lewes, yeoman 1
4107065 2062820 2062820 defendant Glanfylde John husbandman 592658 592658 Glanfylde, John, of Cliff juxta Lewes, husbandman 3
4186159 2090645 2090645 defendant Iden Richard carpenter 592658 592658 Iden, Richard, of Cliff juxta Lewes, carpenter 2
4186168 2090647 2090647 defendant Hover Christopher clerk 592658 592658 Hover, Christopher, of Cliff juxta Lewes, clerk 2
4195300 2093904 2093904 defendant Foster Nicholas   592658 592658 Foster, Nicholas, of Cliff juxta Lewes, slate layer 2
4230327 2106097 2106097 defendant Page John   592658 592658 Page, John, of Cliff juxta Lewes shoemaker 0
4238098 2108928 2108928 defendant Daryngton John butcher 592658 592658 Daryngton, John, of Cliff juxta Lewes, butcher 3
4262614 2117162 2117162 defendant Stone Thomas butcher 592658 592658 Stone, Thomas, of Cliff juxta Lewes, butcher 1
4312518 2134511 2134511 defendant Myllard William yeoman 592658 592658 Myllard, William, of Cliff juxta Lewes, yeoman 1
4314675 2135247 2135247 defendant Cartredge William baker 592658 592658 Cartredge, William, of Cliff juxta Lewes, yeoman, baker 0
4315097 2135395 2135395 defendant Flynte Richard metalman 592658 592658 Flynte, Richard, of Cliff juxta Lewes, yeoman, metalman 0
4320982 2137433 2137433 defendant Sherwood Walter innholder 592658 592658 Sherwood, Walter, of Cliff juxta Lewes, innholder 2
4320983 2137433 2137433 defendant Pycknoll Thomas yeoman 592658 592658 Pycknoll, Thomas, of Cliff juxta Lewes, yeoman 3
4328081 2139708 2139708 defendant Cartredge William baker 592658 592658 Cartredge, William, of Cliff juxta Lewes, yeoman, baker 0
4330896 2140634 2140634 defendant Foster Nicholas   592658 592658 Foster, Nicholas, of Cliff juxta Lewes, slate layer 0
4358234 2150114 2150114 defendant Foster Nicholas   592658 592658 Foster, Nicholas, of Cliff juxta Lewes, mason 0
4358944 2150364 2150364 defendant Earle John yeoman 592658 592658 Earle, John, of Cliff juxta lewes, yeoman 1
4359518 2150562 2150562 defendant Parson Thomas yeoman 592658 592658 Parson, Thomas, of Cliff juxta Lewes, yeoman 1
4359520 2150562 2150562 defendant Jenner Roger bargeman 592658 592658 Jenner, Roger, of Cliff juxta Lewes, bargeman 3
4361220 2151176 2151176 defendant Foster Nicholas   592658 592658 Foster, Nicholas, of Cliff juxta Lewes, mason 0
4363937 2152161 2152161 defendant Davye Thomas butcher 592658 592658 Davye, Thomas, of Cliff juxta Lewes, butcher 0
4363938 2152161 2152161 defendant Stone Thomas, junior butcher 592658 592658 Stone, Thomas, junior, of Cliff juxta Lewes, butcher 1
4363939 2152161 2152161 defendant Pyckenall Thomas husbandman 592658 592658 Pyckenall, Thomas, of Cliff juxta Lewes, husbandman 2
4369248 2154064 2154064 defendant Bottynge Thomas tanner 592658 592658 Bottynge, Thomas, of Cliff juxta Lewes, tanner 0
4369249 2154064 2154064 defendant Bottynge John glover 592658 592658 Bottynge, John, of Cliff juxta Lewes, glover 1
4371335 2154814 2154814 defendant Page John shoemaker 592658 592658 Page, John, of Cliff juxta Lewes, shoemaker 0
4386559 2160179 2160179 defendant Seekes Samuel glover 592658 592658 Seekes, Samuel, of Cliff juxta Lewes, glover 0
4396948 2163549 2163549 defendant Bottyng Thomas tanner 592658 592658 Bottyng, Thomas, of Cliff juxta Lewes, tanner 0
4396951 2163550 2163550 defendant Bottynge John glover 592658 592658 Bottynge, John, of Cliff juxta Lewes, glover 0
4396954 2163551 2163551 defendant Bottynge Thomas tanner 592658 592658 Bottynge, Thomas, of Cliff juxta Lewes, tanner 0
4396957 2163552 2163552 defendant Bottynge John glover 592658 592658 Bottynge, John, of Cliff juxta Lewes, glover 0
4409626 2167817 2167817 defendant Picknett Richard innkeeper 592658 592658 Picknett, Richard, of Cliff juxta Lewes, innkeeper 0
4817916 2301686 2301686 defendant atte Hurst Richard glover 592658 592658 atte Hurst, Richard, of Cliff near Lewes, glover 1
5286560 2441079 2441079 defendant Stonyng John butcher 592658 592658 Stonyng, John, of Cliff juxta Lewes, butcher 0
5287647 2441414 2441414 defendant Galop James laborer 592658 592658 Galop, James, of Cliff juxta Lewes, laborer 3
5349619 2460015 2460015 plaintiff Chaloner Thomas gent 592658 592658 Chaloner, Thomas, of Cliff juxta Lewes, gent 0
5349621 2460016 2460016 plaintiff Chaloner Thomas gent 592658 592658 Chaloner, Thomas, of Cliff juxta Lewes, gent 0
5419045 2480623 2480623 defendant Wodefold Margaret widow 592658 592658 (Wodefold, Margaret, of Cliff near Lewes, widow 1
5583014 2529762 2529762 defendant Williamson Cornelius brewer 592658 592658 Williamson, Cornelius, of of Cliff juxta Lewes, brewer 0

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);