names

61 rows where place_id = 607411

✎ 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
3669130 1916282 1916282 defendant Birryot Richard husbandman 607411 607411 Birryot, Richard, of Camme, husbandman 0
3680869 1920098 1920098 defendant Hykkes Thomas husbandman 607411 607411 Hykkes, Thomas, of Camme, husbandman 0
3722322 1933244 1933244 defendant Wodward Walter husbandman 607411 607411 Wodward, Walter, of Camme, husbandman 0
3811906 1961628 1961628 defendant Bowar Christine widow 607411 607411 Bowar, Christine, of Camme, widow 0
3811907 1961628 1961628 defendant Bowar John tucker 607411 607411 Bowar, John, of Camme, tucker 1
3872638 1981065 1981065 plaintiff Bower Thomas weaver 607411 607411 Bower, Thomas, of Camme, weaver 0
3910592 1993856 1993856 defendant Trotman Edward clothier 607411 607411 Trotman, Edward, of Camme, clothier 0
3913313 1994786 1994786 defendant Mayle Thomas yeoman 607411 607411 Mayle, Thomas, of Camme, yeoman 0
3914252 1995111 1995111 defendant Trotman Thomas husbandman 607411 607411 Trotman, Thomas, of Camme, husbandman 1
3914254 1995111 1995111 defendant Trotman Edward tucker 607411 607411 Trotman, Edward, of Camme, tucker 3
4189823 2091936 2091936 defendant Hardinge George gent 607411 607411 Hardinge, George, of Camme, gent 0
4308182 2133010 2133010 defendant Selman William, junior   607411 607411 Selman, William, junior, of Camme, yeoman, broad weaver 0
4308183 2133010 2133010 defendant Selman John   607411 607411 Selman, John, of Camme, yeoman, his brother 1
4509993 2203611 2203611 plaintiff Bakere Stephen   607411 607411 Bakere, Stephen, of Camme 0
4522713 2207440 2207440 defendant Wither John   607411 607411 Wither, John, of Camme 4
4663157 2249943 2249943 defendant Mabbeson William chaplain 607411 607411 Mabbeson, William, of Camme, chaplain 0
4683203 2260361 2260361 defendant Gosedeye Walter laborer 607411 607411 Gosedeye, Walter, of Camme, laborer 0
4725223 2273183 2273183 defendant Smyth John husbandman 607411 607411 Smyth, John, of Camme, husbandman 1
4738080 2277013 2277013 defendant Ferrour William husbandman 607411 607411 Ferrour, William, of Camme, husbandman 1
4763172 2284467 2284467 defendant Longeford William yeoman 607411 607411 Longeford, William, of Camme, yeoman 0
4786660 2291881 2291881 defendant Buryet Robert husbandman 607411 607411 Buryet, Robert, of Camme, husbandman 0
4812170 2299920 2299920 defendant Wodeward Walter husbandman 607411 607411 Wodeward, Walter, of Camme, husbandman 0
4812171 2299920 2299920 defendant Pembrugge John husbandman 607411 607411 Pembrugge, John, of Camme, husbandman 1
4812173 2299920 2299920 defendant Clerk William husbandman 607411 607411 Clerk, William, of Camme, husbandman 3
4822039 2302968 2302968 defendant Selman John husbandman 607411 607411 Selman, John, of Camme, husbandman 1
4824367 2303683 2303683 defendant Purlewent Walter husbandman 607411 607411 Purlewent, Walter, of Camme, husbandman 1
4826522 2304330 2304330 defendant Nyghtgale Richard yeoman 607411 607411 Nyghtgale, Richard, of Camme, yeoman 0
4878369 2320182 2320182 defendant Domme or Dounne John yeoman 607411 607411 Domme or Dounne, John, of Camme, yeoman 1
4882228 2321349 2321349 defendant Smyth John husbandman 607411 607411 Smyth, John, of Camme, husbandman 0
4882229 2321349 2321349 defendant Lyonell Thomas yeoman 607411 607411 Lyonell, Thomas, of Camme, yeoman 1
4932978 2336704 2336704 defendant Plaunche John yeoman 607411 607411 Plaunche, John, of Camme, yeoman 3
4932983 2336705 2336705 defendant Plaunche John yeoman 607411 607411 Plaunche, John, of Camme, yeoman 2
4958349 2344464 2344464 defendant Donne or Doune John husbandman 607411 607411 Donne or Doune, John, of Camme, husbandman 0
4958350 2344464 2344464 defendant Plaunche John yeoman 607411 607411 Plaunche, John, of Camme, yeoman 1
5009610 2359690 2359690 defendant Nattok John husbandman 607411 607411 Nattok, John, of Camme, husbandman 0
5064766 2376001 2376001 defendant Wodeward John husbandman 607411 607411 Wodeward, John, of Camme, husbandman 0
5069291 2377302 2377302 defendant Donne or Doune John husbandman 607411 607411 Donne or Doune, John, of Camme, husbandman 0
5071537 2377983 2377983 defendant Clerk William husbandman 607411 607411 Clerk, William, of Camme, husbandman 0
5071538 2377983 2377983 defendant Donne or Doune John husbandman 607411 607411 Donne or Doune, John, of Camme, husbandman 1
5071540 2377984 2377984 defendant Clerk William husbandman 607411 607411 Clerk, William, of Camme, husbandman 0
5071541 2377984 2377984 defendant Donne or Doune John husbandman 607411 607411 Donne or Doune, John, of Camme, husbandman 1
5072409 2378236 2378236 defendant Parker John husbandman 607411 607411 Parker, John, of Camme, husbandman 0
5102340 2387099 2387099 defendant Atkyns John carpenter 607411 607411 Atkyns, John, of Camme, carpenter 12
5102342 2387099 2387099 defendant Taillour Henry husbandman 607411 607411 Taillour, Henry, of Camme, husbandman 14
5102343 2387099 2387099 defendant Rakeyn Richard husbandman 607411 607411 Rakeyn, Richard, of Camme, husbandman 15
5102344 2387099 2387099 defendant Yoman Richard husbandman 607411 607411 Yoman, Richard, of Camme, husbandman 16
5102345 2387099 2387099 defendant Solyman John   607411 607411 Solyman, John, of Camme 17
5102346 2387099 2387099 defendant Pegeler William husbandman 607411 607411 Pegeler, William, of Camme, husbandman 18
5102347 2387099 2387099 defendant Huggyns John husbandman 607411 607411 Huggyns, John, of Camme, husbandman 19
5102369 2387100 2387100 defendant Atkyns John carpenter 607411 607411 Atkyns, John, of Camme, carpenter 12
5102371 2387100 2387100 defendant Taillour Henry husbandman 607411 607411 Taillour, Henry, of Camme, husbandman 14
5102372 2387100 2387100 defendant Rawyn Richard husbandman 607411 607411 Rawyn, Richard, of Camme, husbandman 15
5102373 2387100 2387100 defendant Yoman Richard husbandman 607411 607411 Yoman, Richard, of Camme, husbandman 16
5102374 2387100 2387100 defendant Selyman John husbandman 607411 607411 Selyman, John, of Camme, husbandman 17
5102375 2387100 2387100 defendant Pegeler William husbandman 607411 607411 Pegeler, William, of Camme, husbandman 18
5102376 2387100 2387100 defendant Huggyons John husbandman 607411 607411 Huggyons, John, of Camme, husbandman 19
5111842 2389852 2389852 defendant Pegler William husbandman 607411 607411 Pegler, William, of Camme, husbandman 7
5235156 2425860 2425860 defendant Kyllyng alias Taillour John husbandman 607411 607411 Kyllyng alias Taillour, John, of Camme, husbandman 0
5235158 2425861 2425861 defendant Kyllyng alias Tailour John husbandman 607411 607411 Kyllyng alias Tailour, John, of Camme, husbandman 0
5251106 2430448 2430448 defendant Shepherd Robert husbandman 607411 607411 Shepherd, Robert, of Camme, husbandman 0
5558002 2522297 2522297 plaintiff Packer Nicholas (legal representative) 607411 607411 Packer, Nicholas, of Camme, executor of 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);