names

41 rows where place_id = 609901

✎ 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
3680974 1920128 1920128 defendant Crosseley Edward husbandman 609901 609901 Crosseley, Edward, of Selston, husbandman 0
3758670 1944706 1944706 defendant Wyghtman John husbandman 609901 609901 Wyghtman, John, of Selston, husbandman 0
4298854 2129686 2129686 defendant Rodgen Robert yeoman 609901 609901 Rodgen, Robert, of Selston, yeoman 0
4561666 2219583 2219583 defendant Alenman John   609901 609901 Alenman, John, of Selston 0
4594558 2229556 2229556 defendant Midelham John   609901 609901 Midelham, John, of Selston 0
4631276 2240677 2240677 defendant Clerkson William   609901 609901 Clerkson, William, of Selston 3
4646823 2245135 2245135 defendant Middulham John   609901 609901 Middulham, John, of Selston 0
4667163 2255464 2255464 plaintiff Arnall John   609901 609901 Arnall, John, of Selston 0
4678959 2259026 2259026 defendant Clerk John husbandman 609901 609901 Clerk, John, of Selston, husbandman 0
4688340 2261920 2261920 defendant Clerk John, junior husbandman 609901 609901 Clerk, John, junior, of Selston, husbandman 0
4688348 2261921 2261921 defendant Gratton William gent 609901 609901 Gratton, William, of Selston, gent 0
4751612 2280959 2280959 defendant Helde William husbandman 609901 609901 Helde, William, of Selston, husbandman 0
4767250 2285745 2285745 defendant Grubber Thomas collier 609901 609901 Grubber, Thomas, of Selston, collier 0
4789635 2292827 2292827 defendant Gretton William gent 609901 609901 Gretton, William, of Selston, gent 2
4791676 2293495 2293495 defendant Rysshall Richard husbandman 609901 609901 Rysshall, Richard, of Selston, husbandman 1
4843234 2309403 2309403 defendant Gretton Elizabeth widow 609901 609901 Gretton, Elizabeth, of Selston, widow 1
4983571 2352004 2352004 defendant Helde Richard husbandman 609901 609901 Helde, Richard, of Selston, husbandman 0
5023226 2363694 2363694 defendant Brathewell Thomas butcher 609901 609901 Brathewell, Thomas, of Selston, butcher 1
5057664 2373857 2373857 defendant Robynson John   609901 609901 Robynson, John, of Selston, "bulkar" 0
5063496 2375606 2375606 defendant Saunderson Thomas husbandman 609901 609901 Saunderson, Thomas, of Selston, husbandman 2
5064173 2375825 2375825 defendant Russhall Richard husbandman 609901 609901 Russhall, Richard, of Selston, husbandman 0
5141366 2398597 2398597 defendant Badcok John   609901 609901 Badcok, John, of Selston 0
5141367 2398597 2398597 defendant Lad William   609901 609901 Lad, William, of Selston 1
5143707 2399291 2399291 defendant Harryson Thomas laborer 609901 609901 Harryson, Thomas, of Selston, laborer 0
5162963 2404895 2404895 defendant Robynssons John bulker 609901 609901 Robynssons, John, of Selston, bulker 0
5162964 2404895 2404895 defendant Vicars John husbandman 609901 609901 Vicars, John, of Selston, husbandman 1
5176824 2408909 2408909 defendant Robynsons John bulker 609901 609901 Robynsons, John, of Selston, bulker 0
5176825 2408909 2408909 defendant Vycars John husbandman 609901 609901 Vycars, John, of Selston, husbandman 1
5194206 2414036 2414036 defendant Morley Thomas butcher 609901 609901 Morley, Thomas, of Selston, butcher 0
5215002 2420110 2420110 defendant Sterelande Roger   609901 609901 Sterelande, Roger, of Selston, "bukker" 0
5257330 2432415 2432415 defendant Barker John husbandman 609901 609901 Barker, John, of Selston, husbandman 2
5257331 2432415 2432415 defendant Kays John yeoman 609901 609901 Kays, John, of Selston, yeoman 3
5257335 2432416 2432416 defendant Barker John husbandman 609901 609901 Barker, John, of Selston, husbandman 2
5294738 2443442 2443442 defendant Neubold William gent 609901 609901 Neubold, William, of Selston, gent 0
5294739 2443442 2443442 defendant Cotes Thomas husbandman 609901 609901 Cotes, Thomas, of Selston, husbandman 1
5532775 2514805 2514805 defendant Taillour Thomas husbandman 609901 609901 Taillour, Thomas, of Selston, husbandman 0
5532776 2514805 2514805 defendant Taillour John husbandman 609901 609901 Taillour, John, of Selston, husbandman 1
5532784 2514806 2514806 defendant Taillour John husbandman 609901 609901 Taillour, John, of Selston, husbandman 1
5532792 2514807 2514807 defendant Taylour John husbandman 609901 609901 Taylour, John, of Selston, husbandman 1
5576389 2527668 2527668 defendant Graunger Richard husbandman 609901 609901 Graunger, Richard, of Selston, husbandman 1
5615695 2548699 2548699 defendant Skelton William de   609901 609901 Skelton, William de, of Selston 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);