names

50 rows where place_id = 592202

✎ 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
3606910 1869825 1869825 defendant Ryder William (legal representative) 592202 592202 Ryder, William, of Hapton, husbandman, executors of 2
3606911 1869825 1869825 defendant Ryder Agnes widow 592202 592202 (Ryder, Agnes, of Hapton, widow 3
3606912 1869825 1869825 defendant Ryder William husbandman 592202 592202 Ryder, William, of Hapton, husbandman 4
3609410 1870605 1870605 defendant Grene John yeoman 592202 592202 Grene, John, of Hapton, yeoman 0
3645719 1909065 1909065 defendant Ryder Thomas husbandman 592202 592202 Ryder, Thomas, of Hapton, husbandman 0
3647906 1909742 1909742 defendant Hotte John husbandman 592202 592202 Hotte, John, of Hapton, husbandman 1
3711836 1930016 1930016 defendant Felde Humphrey husbandman 592202 592202 Felde, Humphrey, of Hapton, husbandman 3
3746576 1940843 1940843 defendant Pratte Richard husbandman 592202 592202 Pratte, Richard, of Hapton, husbandman 2
3749927 1941893 1941893 defendant Martyn Thomas husbandman 592202 592202 Martyn, Thomas, of Hapton, husbandman 0
3749928 1941893 1941893 defendant Ederyche Peter husbandman 592202 592202 Ederyche, Peter, of Hapton, husbandman 1
3758163 1944540 1944540 defendant Broun Thomas husbandman 592202 592202 Broun, Thomas, of Hapton, husbandman 0
3767539 1947484 1947484 defendant Martyn Thomas husbandman 592202 592202 Martyn, Thomas, of Hapton, husbandman 3
3775726 1950157 1950157 defendant Ederich Peter Husbandman 592202 592202 Ederich, Peter, of Hapton, Husbandman 0
3793311 1955767 1955767 defendant Brown Thomas husbandman 592202 592202 Brown, Thomas, of Hapton, husbandman 0
3873760 1981445 1981445 defendant Edryche Peter husbandman 592202 592202 Edryche, Peter, of Hapton, husbandman 0
3875465 1982038 1982038 defendant Martyn John husbandman 592202 592202 Martyn, John, of Hapton, husbandman 4
3949830 2007017 2007017 defendant Marten Peter yeoman 592202 592202 Marten, Peter, of Hapton, yeoman 0
4217708 2101683 2101683 defendant Birde Thomas carpenter 592202 592202 Birde, Thomas, of Hapton, carpenter 2
4277030 2121898 2121898 defendant Reighnould Robert clerk 592202 592202 Reighnould, Robert, of Hapton, clerk 0
4289464 2126290 2126290 defendant Nulman or Lulman Ralph (legal representative) 592202 592202 Nulman or Lulman, Ralph, of Hapton, ploughwright, executors of 0
4289465 2126290 2126290 defendant Fen Thomas yeoman 592202 592202 (Fen, Thomas, of Hapton, yeoman 1
4325319 2138849 2138849 defendant Seaman Thomas husbandman 592202 592202 Seaman, Thomas, of Hapton, husbandman 0
4326740 2139298 2139298 defendant Bullyngton Stephen husbandman 592202 592202 Bullyngton, Stephen, of Hapton, husbandman 0
4340361 2143890 2143890 defendant Fenne Elias tailor 592202 592202 Fenne, Elias, of Hapton, tailor 0
4346907 2146169 2146169 defendant Martyn Richard yeoman 592202 592202 Martyn, Richard, of Hapton, yeoman 0
4386908 2160288 2160288 defendant Anger John glover 592202 592202 Anger, John, of Hapton, glover 3
4432785 2175008 2175008 defendant Sire Edmund   592202 592202 Sire, Edmund, of Hapton 4
4685166 2260961 2260961 defendant Kemsy Robert husbandman 592202 592202 Kemsy, Robert, of Hapton, husbandman 3
4782998 2290702 2290702 defendant Grene Edmund yeoman 592202 592202 Grene, Edmund, of Hapton, yeoman 0
4785848 2291606 2291606 defendant Grene Edmund yeoman 592202 592202 Grene, Edmund, of Hapton, yeoman 0
4786466 2291814 2291814 defendant Grene Edmund yeoman 592202 592202 Grene, Edmund, of Hapton, yeoman 2
4795213 2294652 2294652 defendant Kensy Robert yeoman 592202 592202 Kensy, Robert, of Hapton, yeoman 0
4825968 2304155 2304155 defendant Hille William butcher 592202 592202 Hille, William, of Hapton, butcher 0
4830173 2305480 2305480 defendant Edryche Thomas husbandman 592202 592202 Edryche, Thomas, of Hapton, husbandman 0
4857054 2313587 2313587 defendant Edryche Thomas husbandman 592202 592202 Edryche, Thomas, of Hapton, or of Funhale, husbandman 0
4932286 2336500 2336500 defendant Hunne Roger yeoman 592202 592202 Hunne, Roger, of Hapton, yeoman 1
4955643 2343654 2343654 defendant Hobbys William husbandman 592202 592202 Hobbys, William, of Hapton, husbandman 1
4993091 2354817 2354817 plaintiff Randolf Richard, sen   592202 592202 Randolf, Richard, sen, of Hapton 3
5015702 2361478 2361478 defendant Grene William husbandman 592202 592202 Grene, William, of Hapton, husbandman 2
5079162 2380254 2380254 defendant Hot Thomas husbandman 592202 592202 Hot, Thomas, of Hapton, husbandman 0
5233032 2425241 2425241 defendant Hotte Richard husbandman 592202 592202 Hotte, Richard, of Hapton, husbandman 2
5270100 2436359 2436359 defendant Grene William yeoman 592202 592202 Grene, William, of Hapton, yeoman 9
5272235 2436954 2436954 defendant Pavy Robert husbandman 592202 592202 Pavy, Robert, of Hapton, husbandman 0
5286803 2441149 2441149 defendant Pavy Robert husbandman 592202 592202 Pavy, Robert, of Hapton, husbandman 0
5319948 2451051 2451051 defendant Grene John yeoman or singleman 592202 592202 Grene, John, of Hapton, yeoman or singleman 3
5319949 2451051 2451051 defendant Brewyn Ralph husbandman 592202 592202 Brewyn, Ralph, of Hapton, husbandman 4
5323554 2452125 2452125 defendant Hunne John yeoman 592202 592202 Hunne, John, of Hapton, yeoman 3
5511526 2508453 2508453 defendant Hunne John husbandman 592202 592202 Hunne, John, of Hapton, husbandman 0
5511527 2508453 2508453 defendant Grene John husbandman 592202 592202 Grene, John, of Hapton, husbandman 1
5562366 2523594 2523594 defendant Johnson Geoffrey husbandman 592202 592202 Johnson, Geoffrey, of Hapton, husbandman 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);