names

40 rows where place_id = 615153

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3707432 1928618 1928618 defendant Dawndy William gent 615153 615153 Dawndy, William, of Gretyngham, gent 0
3707433 1928618 1928618 defendant Folkarde or Fowarde Thomas husbandman 615153 615153 Folkarde or Fowarde, Thomas, of Gretyngham, husbandman 1
3726503 1934555 1934555 defendant Dawndy William gent 615153 615153 Dawndy, William, of Gretyngham, gent 0
3726504 1934555 1934555 defendant Felkard Thomas husbandman 615153 615153 Felkard, Thomas, of Gretyngham, husbandman 1
3726511 1934556 1934556 defendant Dawney William gent 615153 615153 Dawney, William, of Gretyngham, gent 0
4507901 2202934 2202934 defendant Palmere William   615153 615153 Palmere, William, of Gretyngham 0
4584094 2226445 2226445 defendant Godrych Richard   615153 615153 Godrych, Richard, of Gretyngham, pedlar 0
4634704 2241705 2241705 defendant Rokelond William   615153 615153 Rokelond, William, of Gretyngham, vicar 0
4634707 2241706 2241706 defendant Rokelond William   615153 615153 Rokelond, William, of Gretyngham 0
4646139 2244944 2244944 defendant Cullyng John   615153 615153 Cullyng, John, of Gretyngham 2
4911693 2330158 2330158 defendant Hadlesey Richard   615153 615153 Hadlesey, Richard, of Gretyngham, vicar 0
5024360 2364040 2364040 defendant Wyght Anne widow 615153 615153 Wyght, Anne, of Gretyngham, widow 0
5024369 2364040 2364040 defendant Skeyton John yeoman 615153 615153 Skeyton, John, of Gretyngham, yeoman 9
5094414 2384771 2384771 defendant Kene Robert yeoman 615153 615153 Kene, Robert, of Gretyngham, yeoman 3
5126009 2394091 2394091 defendant Gardyner William yeoman 615153 615153 Gardyner, William, of Gretyngham, yeoman 0
5219954 2421548 2421548 defendant Reydon William yeoman 615153 615153 Reydon, William, of Gretyngham, yeoman 0
5240389 2427401 2427401 defendant Holme William yeoman 615153 615153 Holme, William, of Gretyngham, yeoman 0
5240390 2427401 2427401 defendant Myleham John husbandman 615153 615153 Myleham, John, of Gretyngham, husbandman 1
5240391 2427401 2427401 defendant Kene Thomas yeoman 615153 615153 Kene, Thomas, of Gretyngham, yeoman 2
5253752 2431287 2431287 defendant Brook Robert husbandman 615153 615153 Brook, Robert, of Gretyngham, husbandman 0
5258069 2432642 2432642 defendant Reydon William yeoman 615153 615153 Reydon, William, of Gretyngham, yeoman 1
5263933 2434479 2434479 defendant Reydon William yeoman 615153 615153 Reydon, William, of Gretyngham, yeoman 0
5304821 2446446 2446446 defendant Berte Robert laborer 615153 615153 Berte, Robert, of Gretyngham, laborer 2
5304950 2446483 2446483 defendant Brome William yeoman 615153 615153 Brome, William, of Gretyngham, yeoman 0
5323532 2452119 2452119 defendant Maryot William yeoman 615153 615153 Maryot, William, of Gretyngham, yeoman 0
5323533 2452119 2452119 defendant Maryot Thomas yeoman 615153 615153 Maryot, Thomas, of Gretyngham, yeoman 1
5341650 2457584 2457584 defendant Downe Robert gent 615153 615153 Downe, Robert, of Gretyngham, gent 0
5350905 2460393 2460393 defendant Reydon William yeoman 615153 615153 Reydon, William, of Gretyngham, yeoman 1
5398760 2474711 2474711 defendant Peverell Alexander husbandman 615153 615153 Peverell, Alexander, of Gretyngham, husbandman 2
5398765 2474712 2474712 defendant Peverell Alexander husbandman 615153 615153 Peverell, Alexander, of Gretyngham, husbandman 2
5417609 2480184 2480184 defendant Brook Robert tanner 615153 615153 Brook, Robert, of Gretyngham, tanner 0
5417612 2480185 2480185 defendant Brook Robert tanner 615153 615153 Brook, Robert, of Gretyngham, tanner 1
5509044 2507684 2507684 defendant Wale Ralph smith 615153 615153 Wale, Ralph, of Gretyngham, smith 2
5509599 2507836 2507836 plaintiff Gardener John   615153 615153 Gardener, John, of Gretyngham 0
5511545 2508459 2508459 defendant Holme William (legal representative) 615153 615153 Holme, William, of Gretyngham, yeoman, executors of 0
5511546 2508459 2508459 defendant Kene Thomas, senior yeoman 615153 615153 (Kene, Thomas, senior, of Gretyngham, yeoman 1
5511547 2508459 2508459 defendant Gardyner Robert yeoman 615153 615153 Gardyner, Robert, of Gretyngham, yeoman 2
5511554 2508460 2508460 defendant Broke Joan widow 615153 615153 (Broke, Joan, of Gretyngham, widow 1
5511555 2508460 2508460 defendant Fox John yeoman 615153 615153 Fox, John, of Gretyngham, yeoman 2
5636508 2555369 2555369 plaintiff Wyght William   615153 615153 Wyght, William, of Gretyngham 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);