names

61 rows where place_id = 615902

✎ 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
3711413 1929874 1929874 defendant Chetey Walter yeoman 615902 615902 Chetey, Walter, of Bramley, yeoman 0
3713991 1930674 1930674 defendant George John husbandman 615902 615902 George, John, of Bramley, husbandman 0
3962414 2011444 2011444 defendant Hunt Anne widow 615902 615902 Hunt, Anne, of Bramley, widow 0
3993236 2022324 2022324 defendant Manne William yeoman 615902 615902 Manne, William, of Bramley, yeoman 1
4003870 2026149 2026149 defendant Garfurth Richard yeoman 615902 615902 Garfurth, Richard, of Bramley, yeoman 1
4076547 2051911 2051911 defendant Manne William husbandman 615902 615902 Manne, William, of Bramley, husbandman 0
4078058 2052455 2052455 defendant Jore Thomas yeoman 615902 615902 Jore, Thomas, of Bramley, yeoman 0
4095926 2058875 2058875 defendant Puttock Henry sherman 615902 615902 Puttock, Henry, of Bramley, yeoman, sherman 0
4117686 2066621 2066621 defendant Eyre Thomas husbandman 615902 615902 Eyre, Thomas, of Bramley, husbandman 1
4117691 2066622 2066622 defendant Eyre Thomas husbandman 615902 615902 Eyre, Thomas, of Bramley, husbandman 1
4146044 2076769 2076769 defendant Babbe John yeoman 615902 615902 Babbe, John, of Bramley, yeoman 0
4183467 2089697 2089697 defendant Babbe John yeoman 615902 615902 Babbe, John, of Bramley, yeoman 0
4184860 2090213 2090213 defendant Hewet John cooper 615902 615902 Hewet, John, of Bramley, cooper 3
4261945 2116946 2116946 defendant Walker Christopher clothier 615902 615902 Walker, Christopher, of Bramley, clothier 2
4280818 2123195 2123195 defendant Hewett Thomas laborer 615902 615902 Hewett, Thomas, of Bramley, laborer 0
4359815 2150673 2150673 defendant Musgrave Thomas clothier 615902 615902 Musgrave, Thomas, of Bramley, clothier 0
4359816 2150673 2150673 defendant Musgrave Richard clothier 615902 615902 Musgrave, Richard, of Bramley, clothier 1
4392137 2161993 2161993 defendant Dryan Walter husbandman 615902 615902 Dryan, Walter, of Bramley, husbandman 1
4406242 2166653 2166653 defendant Pepper Thomas clothier 615902 615902 Pepper, Thomas, of Bramley, clothier 1
4516978 2205718 2205718 plaintiff Couper John   615902 615902 Couper, John, of Bramley 0
4533415 2210719 2210719 defendant Skynner John   615902 615902 Skynner, John, of Bramley 3
4533416 2210719 2210719 defendant Couper Thomas   615902 615902 Couper, Thomas, of Bramley 4
4621745 2237781 2237781 defendant Symson William   615902 615902 Symson, William, of Bramley 0
4621749 2237782 2237782 defendant Symson William   615902 615902 Symson, William, of Bramley 0
4650835 2246263 2246263 defendant Symson William   615902 615902 Symson, William, of Bramley 2
4675070 2257812 2257812 defendant Eyre Hugh husbandman 615902 615902 Eyre, Hugh, of Bramley, husbandman 0
4685967 2261197 2261197 defendant Noresson William   615902 615902 Noresson, William, of Bramley, wright 0
4787290 2292095 2292095 defendant Miller Stephen miller 615902 615902 Miller, Stephen, of Bramley, miller 0
4866380 2316452 2316452 defendant Symson William, junior husbandman 615902 615902 Symson, William, junior, of Bramley, husbandman 3
4870598 2317777 2317777 defendant Yole William   615902 615902 Yole, William, of Bramley, wright 3
4928960 2335484 2335484 defendant Bollyngton John carpenter 615902 615902 Bollyngton, John, of Bramley, carpenter 0
4928963 2335484 2335484 defendant Yole William carpenter 615902 615902 Yole, William, of Bramley, carpenter 3
4954380 2343277 2343277 defendant Nurysson William carpenter 615902 615902 Nurysson, William, of Bramley, carpenter 0
4954381 2343277 2343277 defendant Sclater Thomas slater 615902 615902 Sclater, Thomas, of Bramley, slater 1
4960647 2345148 2345148 defendant Taillour John yeoman 615902 615902 Taillour, John, of Bramley, yeoman 5
4960663 2345151 2345151 defendant Taillour John yeoman 615902 615902 Taillour, John, of Bramley, yeoman 2
4964960 2346435 2346435 defendant Somerton Thomas husbandman 615902 615902 Somerton, Thomas, of Bramley, husbandman 0
5105843 2388153 2388153 defendant Smyth Robert smith 615902 615902 Smyth, Robert, of Bramley, smith 2
5105850 2388154 2388154 defendant Smyth Robert smith 615902 615902 Smyth, Robert, of Bramley, smith 2
5155624 2402801 2402801 defendant Stephen Simon miller 615902 615902 Stephen, Simon, of Bramley, miller 0
5159412 2403871 2403871 defendant Hauke William husbandman 615902 615902 Hauke, William, of Bramley, husbandman 0
5159413 2403871 2403871 defendant Holand William husbandman 615902 615902 Holand, William, of Bramley, husbandman 1
5159414 2403871 2403871 defendant Cosyn Richard laborer 615902 615902 Cosyn, Richard, of Bramley, laborer 2
5159415 2403871 2403871 defendant Symson William husbandman 615902 615902 Symson, William, of Bramley, husbandman 3
5172173 2407582 2407582 defendant Stephen Simon miller 615902 615902 Stephen, Simon, of Bramley, miller 0
5174558 2408261 2408261 defendant Hauke William husbandman 615902 615902 Hauke, William, of Bramley, husbandman 0
5174559 2408261 2408261 defendant Holand William husbandman 615902 615902 Holand, William, of Bramley, husbandman 1
5174560 2408261 2408261 defendant Cosyn Richard laborer 615902 615902 Cosyn, Richard, of Bramley, laborer 2
5174561 2408261 2408261 defendant Symson William husbandman 615902 615902 Symson, William, of Bramley, husbandman 3
5174562 2408261 2408261 defendant Eyre William husbandman 615902 615902 Eyre, William, of Bramley, husbandman 4
5177897 2409241 2409241 defendant Edward John fuller 615902 615902 Edward, John, of Bramley, fuller 4
5191360 2413211 2413211 defendant Stephen Simon miller 615902 615902 Stephen, Simon, of Bramley, miller 0
5201145 2416095 2416095 defendant Edward John fuller 615902 615902 Edward, John, of Bramley, fuller 4
5275110 2437798 2437798 defendant Holand William   615902 615902 Holand, William, of Bramley 3
5275115 2437799 2437799 defendant Holand William smith 615902 615902 Holand, William, of Bramley, smith 3
5282171 2439851 2439851 defendant Wright Richard shoemaker 615902 615902 Wright, Richard, of Bramley, shoemaker 0
5282172 2439851 2439851 defendant Claxton John   615902 615902 Claxton, John, of Bramley, cook 1
5436047 2485721 2485721 defendant Lytelwerk Ingram yeoman 615902 615902 Lytelwerk, Ingram, of Bramley, yeoman 2
5487335 2501112 2501112 defendant Wylkynson Brian yeoman 615902 615902 Wylkynson, Brian, of Bramley, yeoman 2
5542975 2517923 2517923 defendant Martyn Stephen husbandman 615902 615902 Martyn, Stephen, of Bramley, husbandman 1
5558657 2522483 2522483 defendant Lytilwark Ingelram yeoman 615902 615902 Lytilwark, Ingelram, of Bramley, yeoman 3

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