names

54 rows where place_id = 609399

✎ 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
3678255 1919254 1919254 defendant Massyngberd Thomas esq 609399 609399 Massyngberd, Thomas, of Braytoft, esq 0
3720833 1932809 1932809 plaintiff Johnson William   609399 609399 Johnson, William, of Braytoft 0
3734525 1937044 1937044 defendant Johnson William husbandman 609399 609399 Johnson, William, of Braytoft, husbandman 0
3766162 1947070 1947070 defendant Waltham Thomas yeoman 609399 609399 Waltham, Thomas, of Braytoft, yeoman 0
3766163 1947070 1947070 defendant Bek Thomas yeoman 609399 609399 Bek, Thomas, of Braytoft, yeoman 1
3781564 1951970 1951970 defendant Jakson Thomas   609399 609399 Jakson, Thomas, of Braytoft, freemason 0
3789357 1954492 1954492 defendant Whityng Thomas husbandman 609399 609399 Whityng, Thomas, of Braytoft, husbandman 1
3793555 1955844 1955844 defendant Bocher Thomas husbandman 609399 609399 Bocher, Thomas, of Braytoft, husbandman 0
3816063 1962925 1962925 defendant Jakson William   609399 609399 Jakson, William, of Braytoft, freemason 0
3843647 1971546 1971546 defendant Cruche Roger yeoman 609399 609399 Cruche, Roger, of Braytoft, yeoman 3
3843901 1971631 1971631 defendant Cruche Roger yeoman 609399 609399 Cruche, Roger, of Braytoft, yeoman 3
3863659 1978030 1978030 defendant Johnson alias Jenken William yeoman 609399 609399 Johnson alias Jenken, William, of Braytoft, yeoman 0
3864148 1978196 1978196 defendant Ingoldesby Robert husbandman 609399 609399 Ingoldesby, Robert, of Braytoft, husbandman 0
4103809 2061635 2061635 defendant Massyngberd John gent 609399 609399 Massyngberd, John, of Braytoft, gent 1
4464529 2189574 2189574 defendant Herre Thomas   609399 609399 Herre, Thomas, of Braytoft 1
4501725 2201140 2201140 defendant Calseby William de   609399 609399 Calseby, William de, of Braytoft 0
4511471 2204033 2204033 defendant Stokton Richard de   609399 609399 Stokton, Richard de, of Braytoft 0
4555522 2217658 2217658 defendant Calceby William   609399 609399 Calceby, William, of Braytoft 0
4566989 2221235 2221235 defendant Calseby William   609399 609399 Calseby, William, of Braytoft 3
4591984 2228847 2228847 plaintiff Myte Walter   609399 609399 Myte, Walter, of Braytoft 0
4592759 2229074 2229074 defendant Sokton John   609399 609399 Sokton, John, of Braytoft, formerly servant of Richard Sokton 0
4602146 2231893 2231893 defendant Whityng Robert   609399 609399 Whityng, Robert, of Braytoft 0
4606697 2233206 2233206 defendant Jonson William   609399 609399 Jonson, William, of Braytoft 0
4621283 2237643 2237643 defendant Stokton Richard   609399 609399 Stokton, Richard, of Braytoft 0
4666603 2251033 2251033 defendant Tynk John laborer 609399 609399 Tynk, John, of Braytoft, laborer 0
4666605 2251034 2251034 defendant Tynke John laborer 609399 609399 Tynke, John, of Braytoft, laborer 0
4668196 2255763 2255763 defendant Webster William laborer 609399 609399 Webster, William, of Braytoft, laborer 0
4668197 2255763 2255763 defendant Webster Robert husbandman 609399 609399 Webster, Robert, of Braytoft, husbandman 1
4705299 2267030 2267030 defendant Stokton Richard husbandman 609399 609399 Stokton, Richard, of Braytoft, husbandman 0
4729517 2274443 2274443 defendant Tynk John husbandman 609399 609399 Tynk, John, of Braytoft, husbandman 3
4729518 2274443 2274443 defendant Carter John husbandman 609399 609399 Carter, John, of Braytoft, husbandman 4
4739074 2277312 2277312 defendant Watkynson Robert chaplain 609399 609399 Watkynson, Robert, of Braytoft, chaplain 0
4752975 2281320 2281320 defendant Stokton Richard shoemaker 609399 609399 Stokton, Richard, of Braytoft, shoemaker 3
4774951 2288162 2288162 defendant Braytoft John esq 609399 609399 Braytoft, John, of Braytoft, esq 0
4834797 2306885 2306885 defendant Muryell John gent 609399 609399 Muryell, John, of Braytoft, gent 0
4900018 2326642 2326642 defendant Braytoft John husbandman 609399 609399 Braytoft, John, of Braytoft, husbandman 2
4925747 2334487 2334487 defendant Jonson Philip husbandman 609399 609399 Jonson, Philip, of Braytoft, husbandman 0
4944001 2340089 2340089 defendant Gretam John smith 609399 609399 Gretam, John, of Braytoft, smith 3
4944002 2340089 2340089 defendant Jonson Philip husbandman 609399 609399 Jonson, Philip, of Braytoft, husbandman 4
4944907 2340398 2340398 plaintiff Medycroft Robert esq 609399 609399 Medycroft, Robert, of Braytoft, esq 1
4996188 2355717 2355717 defendant Williamson John husbandman 609399 609399 Williamson, John, of Braytoft, husbandman 0
5035035 2367108 2367108 defendant Redehede Thomas thatcher 609399 609399 Redehede, Thomas, of Braytoft, thatcher 0
5040893 2368896 2368896 defendant Sutton William husbandman 609399 609399 Sutton, William, of Braytoft, husbandman 0
5194633 2414163 2414163 defendant Whityng William husbandman 609399 609399 Whityng, William, of Braytoft, husbandman 1
5236128 2426151 2426151 defendant Thorp Robert husbandman 609399 609399 Thorp, Robert, of Braytoft, husbandman 2
5245320 2428792 2428792 defendant Jankynson Philip husbandman 609399 609399 Jankynson, Philip, of Braytoft, husbandman 1
5352249 2460801 2460801 defendant Spencer Walter husbandman 609399 609399 Spencer, Walter, of Braytoft, husbandman 3
5352250 2460801 2460801 defendant Spencer John husbandman 609399 609399 Spencer, John, of Braytoft, husbandman 4
5370610 2466394 2466394 defendant Tyler John husbandman 609399 609399 Tyler, John, of Braytoft, husbandman 0
5371101 2466549 2466549 defendant Tiler Thomas husbandman 609399 609399 Tiler, Thomas, of Braytoft, husbandman 4
5551704 2520540 2520540 defendant Massyngberd Thomas gent 609399 609399 Massyngberd, Thomas, of Braytoft, gent 0
5564985 2524345 2524345 defendant Jenkynson William husbandman 609399 609399 Jenkynson, William, of Braytoft, husbandman 4
5625701 2551981 2551981 defendant Stokton Richard shoemaker 609399 609399 Stokton, Richard, of Braytoft, shoemaker 2
5626183 2552157 2552157 defendant Butiler John yeoman 609399 609399 Butiler, John, of Braytoft, yeoman 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);