names

36 rows where place_id = 599093

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635208 1905804 1905804 defendant Prowevard Richard husbandman 599093 599093 Prowevard, Richard, of Cougham, husbandman 0
3762990 1946055 1946055 defendant Fysshe Adam tanner 599093 599093 Fysshe, Adam, of Cougham, tanner 1
3862958 1977806 1977806 defendant Russell Robert yeoman 599093 599093 Russell, Robert, of Cougham, yeoman 2
3862960 1977807 1977807 defendant Camme Thomas yeoman 599093 599093 Camme, Thomas, of Cougham, yeoman 0
3867579 1979392 1979392 defendant Barker John laborer 599093 599093 Barker, John, of Cougham, laborer 2
4323629 2138318 2138318 defendant Swanton Edward husbandman 599093 599093 Swanton, Edward, of Cougham, husbandman 1
4401954 2165247 2165247 defendant Lamman Robert husbandman 599093 599093 Lamman, Robert, of Cougham , husbandman 0
4424081 2172384 2172384 defendant Dene John   599093 599093 Dene, John, of Cougham 0
4613079 2235148 2235148 defendant Prowdeberd James   599093 599093 Prowdeberd, James, of Cougham 3
4677017 2258430 2258430 defendant Cougham Thomas husbandman 599093 599093 Cougham, Thomas, of Cougham, husbandman 4
4694156 2263673 2263673 defendant Cougham Thomas yeoman 599093 599093 Cougham, Thomas, of Cougham, yeoman 0
4696377 2264345 2264345 defendant Brid Edmund husbandman 599093 599093 Brid, Edmund, of Cougham, husbandman 0
4765444 2285178 2285178 defendant Webster Simon weaver 599093 599093 Webster, Simon, of Cougham, weaver 0
4775594 2288361 2288361 defendant Heydon Adam husbandman 599093 599093 Heydon, Adam, of Cougham, husbandman 0
4808535 2298837 2298837 plaintiff West John   599093 599093 West, John, of Cougham, parson of the church of the BM 1
4845810 2310201 2310201 defendant Wolvy Richard husbandman 599093 599093 Wolvy, Richard, of Cougham, husbandman 0
4845811 2310201 2310201 defendant Wolvy Edmund yeoman 599093 599093 Wolvy, Edmund, of Cougham, yeoman 1
4845812 2310201 2310201 defendant Proberd James husbandman 599093 599093 Proberd, James, of Cougham, husbandman 2
4845814 2310202 2310202 defendant Grene John husbandman 599093 599093 Grene, John, of Cougham, husbandman 0
4845815 2310202 2310202 defendant Brydde John husbandman 599093 599093 Brydde, John, of cougham, husbandman 1
4845816 2310202 2310202 defendant Benet Robert husbandman 599093 599093 Benet, Robert, of Cougham, husbandman 2
4881840 2321219 2321219 defendant Reve Ralph laborer 599093 599093 Reve, Ralph, of Cougham, laborer 0
4881841 2321219 2321219 defendant Mathewe Edmund laborer 599093 599093 Mathewe, Edmund, of Cougham, laborer 1
4908747 2329284 2329284 defendant Cougham Thomas yeoman 599093 599093 Cougham, Thomas, of Cougham, yeoman 1
5134784 2396674 2396674 defendant Pyngell Robert husbandman 599093 599093 Pyngell, Robert, of Cougham, husbandman 0
5196683 2414780 2414780 defendant Cougham Thomas (legal representative) 599093 599093 Cougham, Thomas, of Cougham, husbandman, executor of 4
5209756 2418590 2418590 defendant Cougham Thomas (legal representative) 599093 599093 Cougham, Thomas, of Cougham, husbandman, executor of 4
5209757 2418590 2418590 defendant Cougham Edmund   599093 599093 Cougham, Edmund, of Cougham 5
5310397 2448145 2448145 defendant Proweberd John yeoman 599093 599093 Proweberd, John, of Cougham, yeoman 0
5365383 2464847 2464847 defendant Patryk John husbandman 599093 599093 Patryk, John, of Cougham, husbandman 0
5405596 2476677 2476677 defendant Pyngyll Robert husbandman 599093 599093 Pyngyll, Robert, of Cougham, husbandman 4
5406152 2476837 2476837 defendant Pyngyll Robert husbandman 599093 599093 Pyngyll, Robert, of Cougham, husbandman 4
5419220 2480676 2480676 defendant Pyngyll Robert husbandman 599093 599093 Pyngyll, Robert, of Cougham, husbandman 3
5441332 2487324 2487324 defendant Pyngell Roger husbandman 599093 599093 Pyngell, Roger, of Cougham, husbandman 0
5447380 2489109 2489109 defendant Kelyng Robert   599093 599093 Kelyng, Robert, of Cougham, shepherd 3
5473330 2496986 2496986 defendant Pyngyll Robert husbandman 599093 599093 Pyngyll, Robert, of Cougham, husbandman 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);