names

49 rows where place_id = 612852

✎ 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
3695337 1924766 1924766 defendant Tydman Thomas husbandman 612852 612852 Tydman, Thomas, of Shelford, husbandman 1
3730034 1935634 1935634 defendant Carter John husbandman 612852 612852 Carter, John, of Shelford, husbandman 3
4294050 2127950 2127950 defendant Whalhead Richard husbandman 612852 612852 Whalhead, Richard, of Shelford, husbandman 0
4432494 2174933 2174933 defendant Birnys John de, senior   612852 612852 Birnys, John de, senior, of Shelford 0
4476181 2193211 2193211 defendant Rendour John clerk 612852 612852 Rendour, John, of Shelford, clerk 2
4505892 2202352 2202352 defendant Plasterer Roger   612852 612852 Plasterer, Roger, of Shelford 0
4529908 2209643 2209643 defendant Spode Robert   612852 612852 Spode, Robert, of Shelford 0
4534977 2211220 2211220 plaintiff or Prior William   612852 612852 or Prior, William, of Shelford 1
4548207 2215381 2215381 defendant Miller Thomas   612852 612852 Miller, Thomas, of Shelford 1
4569083 2221917 2221917 defendant Okkeld William   612852 612852 Okkeld, William, of Shelford 3
4611009 2234513 2234513 defendant Rust Robert   612852 612852 Rust, Robert, of Shelford 0
4659402 2248803 2248803 defendant Bykerstaf Ralph yeoman 612852 612852 Bykerstaf, Ralph, of Shelford, yeoman 0
4671701 2256795 2256795 defendant Spede John husbandman 612852 612852 Spede, John, of Shelford, husbandman 1
4671702 2256795 2256795 defendant Spede William husbandman 612852 612852 Spede, William, of Shelford, husbandman 2
4683371 2260399 2260399 defendant Deye John, senior husbandman 612852 612852 Deye, John, senior, of Shelford, husbandman 4
4709127 2268221 2268221 plaintiff Patesle Thomas (legal representative) 612852 612852 Patesle, Thomas, of Shelford, parson & clerk, executors of 0
4719158 2271340 2271340 defendant Spondon John husbandman 612852 612852 Spondon, John, of Shelford, husbandman 1
4734662 2275996 2275996 defendant Neweman Thomas husbandman 612852 612852 Neweman, Thomas, of Shelford, husbandman 1
4741762 2278085 2278085 defendant Spede John ploughman 612852 612852 Spede, John, of Shelford, ploughman 0
4790945 2293260 2293260 defendant Grantham Isabel widow 612852 612852 Grantham, Isabel, of Shelford, widow 0
4790946 2293260 2293260 defendant Grantham Etheldred spinster 612852 612852 Grantham, Etheldred, of Shelford, spinster 1
4791877 2293563 2293563 defendant Tuttebury John husbandman 612852 612852 Tuttebury, John, of Shelford, husbandman 0
4826094 2304193 2304193 defendant Barbour Henry husbandman 612852 612852 Barbour, Henry, of Shelford, husbandman 0
4833670 2306538 2306538 defendant Aayryk William husbandman 612852 612852 Aayryk, William, of Shelford, husbandman 0
4865601 2316208 2316208 defendant Spede John husbandman 612852 612852 Spede, John, of Shelford, husbandman 0
4868530 2317131 2317131 defendant Carter John husbandman 612852 612852 Carter, John, of Shelford, husbandman 0
4925583 2334437 2334437 defendant Carter alias Cheys John husbandman 612852 612852 Carter alias Cheys, John, of Shelford, husbandman 0
4950993 2342274 2342274 defendant Carter alias Choys John husbandman 612852 612852 Carter alias Choys, John, of Shelford, husbandman 0
4953364 2342970 2342970 defendant Gybon Thomas laborer 612852 612852 Gybon, Thomas, of Shelford, laborer 4
5046123 2370469 2370469 defendant Breton Adam husbandman 612852 612852 Breton, Adam, of Shelford, husbandman 1
5103386 2387419 2387419 defendant Sonman or Souman John husbandman 612852 612852 Sonman or Souman, John, of Shelford, husbandman 1
5165718 2405718 2405718 plaintiff Bottesford John   612852 612852 Bottesford, John, of Shelford, prior 0
5284392 2440454 2440454 defendant Flexman Rober carpenter 612852 612852 Flexman, Rober, of Shelford, carpenter 0
5284398 2440455 2440455 defendant Flexman Robert carter 612852 612852 Flexman, Robert, of Shelford, carter 0
5331431 2454479 2454479 defendant Penyngton Henry yeoman 612852 612852 Penyngton, Henry, of Shelford, yeoman 2
5331432 2454479 2454479 defendant Spenser Richard husbandman 612852 612852 Spenser, Richard, of Shelford, husbandman 3
5331438 2454480 2454480 defendant Spenser Richard husbandman 612852 612852 Spenser, Richard, of Shelford, husbandman 2
5331441 2454480 2454480 defendant Henfray John husbandman 612852 612852 together with Henfray, John, of Shelford, husbandman 5
5347062 2459238 2459238 defendant Suman John, senior husbandman 612852 612852 Suman, John, senior, of Shelford, husbandman 1
5347063 2459238 2459238 defendant Suman John, junior husbandman 612852 612852 Suman, John, junior, of Shelford, husbandman 2
5353105 2461049 2461049 defendant Jakelyn John carter 612852 612852 Jakelyn, John, of Shelford, carter 4
5507318 2507185 2507185 defendant Rosell William gent 612852 612852 Rosell, William, of Shelford, gent 1
5552855 2520886 2520886 defendant Parsons Thomas gent 612852 612852 Parsons, Thomas, of Shelford, gent 0
5552856 2520886 2520886 defendant Felebrome Thomas yeoman 612852 612852 Felebrome, Thomas, of Shelford, yeoman 1
5552857 2520886 2520886 defendant Crokeston Nicholas husbandman 612852 612852 Crokeston, Nicholas, of Shelford, husbandman 2
5552860 2520887 2520887 defendant Parsons Thomas gent 612852 612852 Parsons, Thomas, of Shelford, gent 0
5552861 2520887 2520887 defendant Felebrome Thomas yeoman 612852 612852 Felebrome, Thomas, of Shelford, yeoman 1
5552862 2520887 2520887 defendant Crokeston Nicholas husbandman 612852 612852 Crokeston, Nicholas, of Shelford, husbandman 2
5632627 2554226 2554226 defendant Colermaker Lawrence   612852 612852 Colermaker, Lawrence, of Shelford, collar maker 4

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