names

45 rows where place_id = 600336

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640657 1907518 1907518 defendant Daniell Thomas clerk 600336 600336 Daniell, Thomas, of Otford, clerk 0
3679643 1919700 1919700 defendant Bottowe Edmund husbandman 600336 600336 Bottowe, Edmund, of Otford, husbandman 3
3711428 1929879 1929879 defendant Roger William husbandman 600336 600336 Roger, William, of Otford, husbandman 2
3738524 1938259 1938259 plaintiff Moulton Robert yeoman 600336 600336 Moulton, Robert, of Otford, yeoman 0
3738526 1938260 1938260 plaintiff Moulton Robert yeoman 600336 600336 Moulton, Robert, of Otford, yeoman 0
3738529 1938260 1938260 defendant Calverley James yeoman 600336 600336 Calverley, James, of Otford, yeoman 2
3751182 1942297 1942297 plaintiff Moulton Robert yeoman 600336 600336 Moulton, Robert, of Otford, yeoman 0
3767323 1947425 1947425 plaintiff Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3785100 1953128 1953128 plaintiff Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3787704 1953938 1953938 defendant Multon Robert, senior yeoman 600336 600336 Multon, Robert, senior, of Otford, yeoman 1
3801687 1958423 1958423 plaintiff Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3801689 1958424 1958424 plaintiff Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3808119 1960433 1960433 defendant Multon Robert, junior yeoman 600336 600336 Multon, Robert, junior, of Otford, yeoman 0
3817345 1963334 1963334 defendant Hammyng John, senior husbandman 600336 600336 Hammyng, John, senior, of Otford, husbandman 0
3817347 1963335 1963335 defendant Hammyng John, senior husbandman 600336 600336 Hammyng, John, senior, of Otford, husbandman 0
3823566 1965274 1965274 defendant Hammyng John, senior husbandman 600336 600336 Hammyng, John, senior, of Otford, husbandman 0
3823568 1965275 1965275 defendant Hammyng John, senior husbandman 600336 600336 Hammyng, John, senior, of Otford, husbandman 0
3834543 1968741 1968741 defendant Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3838003 1969796 1969796 defendant Whyte Richard husbandman 600336 600336 Whyte, Richard, of Otford, husbandman 0
3838005 1969797 1969797 defendant Whyte Richard husbandman 600336 600336 Whyte, Richard, of Otford, husbandman 0
3850114 1973626 1973626 defendant Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3865001 1978495 1978495 defendant Multon Robert yeoman 600336 600336 Multon, Robert, of Otford, yeoman 0
3874372 1981653 1981653 defendant Langley Edmund laborer 600336 600336 Langley, Edmund, of Otford, laborer 1
4003276 2025929 2025929 defendant Wybarne Hugh tailor 600336 600336 Wybarne, Hugh, of Otford, tailor 0
4024150 2033342 2033342 plaintiff Berysford Michael gent 600336 600336 Berysford, Michael, of Otford, gent 0
4028740 2034927 2034927 defendant Collyn Giles barber surgeon 600336 600336 Collyn, Giles, of Otford, barber surgeon 2
4028746 2034928 2034928 defendant Collyn Giles barber surgeon 600336 600336 Collyn, Giles, of Otford, barber surgeon 2
4696946 2264523 2264523 defendant Eynloth William butcher 600336 600336 Eynloth, William, of Otford, butcher 0
4762929 2284389 2284389 defendant Roweshawe John   600336 600336 Roweshawe, John, of Otford, park man 0
4776498 2288644 2288644 defendant Dene Robert chapman 600336 600336 Dene, Robert, of Otford, chapman 0
4831824 2305972 2305972 defendant Cook Stephen husbandman 600336 600336 Cook, Stephen, of Otford, husbandman 0
4966834 2347003 2347003 defendant Dryver John husbandman 600336 600336 Dryver, John, of Otford, husbandman 0
5061039 2374875 2374875 defendant Dryver John, senior husbandman 600336 600336 Dryver, John, senior, of Otford, husbandman 3
5196570 2414748 2414748 defendant More John yeoman 600336 600336 More, John, of Otford, yeoman 1
5209703 2418577 2418577 defendant More John yeoman 600336 600336 More, John, of Otford, yeoman 1
5484492 2500279 2500279 defendant Hammyng John husbandman 600336 600336 Hammyng, John, of Otford, husbandman 3
5496817 2503973 2503973 defendant Brewer John husbandman 600336 600336 Brewer, John, of Otford, husbandman 4
5498758 2504571 2504571 defendant Walker John yeoman 600336 600336 Walker, John, of Otford, yeoman 0
5498760 2504572 2504572 defendant Walker John yeoman 600336 600336 Walker, John, of Otford, yeoman 0
5500389 2505061 2505061 defendant Hammyng John husbandman 600336 600336 Hammyng, John, of Otford, husbandman 0
5500390 2505061 2505061 defendant Stevenson John husbandman 600336 600336 Stevenson, John, of Otford, husbandman 1
5500391 2505061 2505061 defendant Dowepark John laborer 600336 600336 Dowepark, John, of Otford, laborer 2
5511742 2508525 2508525 defendant Arnold John laborer 600336 600336 Arnold, John, of Otford, laborer 0
5634311 2554719 2554719 defendant Oure John husbandman 600336 600336 Oure, John, of Otford, husbandman 0
5634314 2554719 2554719 defendant Barker William husbandman 600336 600336 Barker, William, of Otford, husbandman 3

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