names

35 rows where place_id = 591337

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604108 1868951 1868951 defendant Piers George gent 591337 591337 Piers, George, of Ewhurst, gent 0
3647997 1909775 1909775 defendant A Barnys John husbandman 591337 591337 A Barnys, John, of Ewhurst, husbandman 3
3648004 1909776 1909776 defendant Abarnys John husbandman 591337 591337 Abarnys, John, of Ewhurst, husbandman 3
3725170 1934160 1934160 defendant Brygham Thomas   591337 591337 Brygham, Thomas, of Ewhurst, "freccher" 1
3725177 1934161 1934161 defendant Brygham Thomas fletcher 591337 591337 Brygham, Thomas, of Ewhurst, fletcher 1
3739855 1938679 1938679 defendant Dendy John husbandman 591337 591337 Dendy, John, of Ewhurst, husbandman 0
3745227 1940415 1940415 defendant Overyngton John husbandman 591337 591337 Overyngton, John, of Ewhurst, husbandman 0
3745228 1940415 1940415 defendant Overyngton Richard husbandman 591337 591337 Overyngton, Richard, of Ewhurst, husbandman 1
3745229 1940415 1940415 defendant Harryes Robert sawyer 591337 591337 Harryes, Robert, of Ewhurst, sawyer 2
3830618 1967457 1967457 defendant Cicill Nicholas clerk 591337 591337 Cicill, Nicholas, of Ewhurst, clerk 0
3850142 1973635 1973635 defendant Reynold John tailor 591337 591337 Reynold, John, of Ewhurst, tailor 1
3863603 1978016 1978016 defendant Overyngton Robert husbandman 591337 591337 Overyngton, Robert, of Ewhurst, husbandman 1
3918746 1996599 1996599 defendant Overyngton Robert husbandman 591337 591337 Overyngton, Robert, of Ewhurst, husbandman 1
3963338 2011778 2011778 defendant Colgate Stephen husbandman 591337 591337 Colgate, Stephen, of Ewhurst, husbandman 0
4191305 2092524 2092524 defendant Dalton John husbandman 591337 591337 Dalton, John, of Ewhurst, husbandman 0
4240025 2109637 2109637 defendant Sayer Thomas yeoman 591337 591337 Sayer, Thomas, of Ewhurst, or of Kyrdforde, Sussex, yeoman 0
4279519 2122755 2122755 defendant Mower John husbandman 591337 591337 Mower, John, of Ewhurst, husbandman 0
4279520 2122755 2122755 defendant Wrighte William husbandman 591337 591337 Wrighte, William, of Ewhurst, husbandman 1
4364147 2152232 2152232 defendant Snellynge John husbandman 591337 591337 Snellynge, John, of Ewhurst, husbandman 1
4376538 2156677 2156677 defendant Snellynge John yeoman 591337 591337 Snellynge, John, of Ewhurst, yeoman 0
4394006 2162596 2162596 defendant Longhurste John, junior yeoman 591337 591337 Longhurste, John, junior, of Ewhurst, yeoman 0
4396067 2163261 2163261 defendant Sitterne Henry clerk 591337 591337 Sitterne, Henry, of Ewhurst, clerk 0
4396068 2163261 2163261 defendant Nye George yeoman 591337 591337 Nye, George, of Ewhurst, yeoman 1
4396069 2163261 2163261 defendant Streat John yeoman 591337 591337 Streat John, of Ewhurst, yeoman 2
4396070 2163261 2163261 defendant More John husbandman 591337 591337 More, John, of Ewhurst, husbandman 3
4396075 2163262 2163262 defendant Wryte William husbandman 591337 591337 Wryte, William, of Ewhurst, husbandman 3
5158289 2403548 2403548 defendant Burgoyn Thomas yeoman 591337 591337 Burgoyn, Thomas, of Ewhurst, yeoman 2
5158290 2403548 2403548 defendant Crafford Alan husbandman 591337 591337 Crafford, Alan, of Ewhurst, husbandman 3
5194155 2414024 2414024 defendant Burgoyn Thomas gent 591337 591337 Burgoyn, Thomas, of Ewhurst, gent 2
5194156 2414024 2414024 defendant Bras Thomas yeoman 591337 591337 Bras, Thomas, of Ewhurst, yeoman 3
5194157 2414024 2414024 defendant Crafford Alan husbandman 591337 591337 Crafford, Alan, of Ewhurst, husbandman 4
5208578 2418237 2418237 defendant Burgoyn Thomas yeoman 591337 591337 Burgoyn, Thomas, of Ewhurst, yeoman 2
5208579 2418237 2418237 defendant Crafford Alan husbandman 591337 591337 Crafford, Alan, of Ewhurst, husbandman 3
5391885 2472756 2472756 defendant Boket William wheeler 591337 591337 Boket, William, of Ewhurst, wheeler 1
5409525 2477813 2477813 defendant Hebbynge Robert, sen carpenter 591337 591337 Hebbynge, Robert, sen, of Ewhurst, carpenter 1

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