names

48 rows where place_id = 587146

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590593 1864700 1864700 defendant Draper Nicholas tucker 587146 587146 Draper, Nicholas, of Milton Damerell, tucker 0
3611201 1871179 1871179 defendant Langedon John yeoman 587146 587146 Langedon, John, of Milton Damerell, yeoman 0
3634040 1905445 1905445 defendant Hurde Robert   587146 587146 Hurde, Robert, of Milton Damerell, franklin 0
3664946 1914981 1914981 defendant Hurd Robert   587146 587146 Hurd, Robert, of Milton Damerell, frankelyn 1
3719320 1932330 1932330 defendant Colles Hugh gent 587146 587146 Colles, Hugh, of Milton Damerell, gent 3
3881012 1983917 1983917 defendant Colles Humphrey gent 587146 587146 Colles, Humphrey, of Milton Damerell, gent 3
4666103 2250864 2250864 defendant Person William husbandman 587146 587146 Person, William, of Milton Damerell, husbandman 6
4965149 2346501 2346501 defendant Dyrworthy William husbandman 587146 587146 Dyrworthy, William, of Milton Damerell, husbandman 1
5057903 2373935 2373935 defendant Hurde Walter husbandman 587146 587146 Hurde, Walter, of Milton Damerell, husbandman 0
5057905 2373935 2373935 defendant Chenals or Chevals Peter smith 587146 587146 Chenals or Chevals, Peter, of Milton Damerell, smith 2
5117417 2391526 2391526 defendant Don Roger husbandman 587146 587146 Don, Roger,of Milton Damerell, husbandman 1
5158393 2403576 2403576 defendant Don Roger husbandman 587146 587146 Don, Roger, of Milton Damerell, husbandman 2
5171436 2407370 2407370 defendant Donne Robert husbandman 587146 587146 Donne, Robert, of Milton Damerell, husbandman 1
5171440 2407371 2407371 defendant Donne Robert husbandman 587146 587146 Donne, Robert, of Milton Damerell, husbandman 1
5189853 2412777 2412777 defendant Torner Walter husbandman 587146 587146 Torner, Walter, of Milton Damerell, husbandman 1
5189856 2412778 2412778 defendant Turner Walter husbandman 587146 587146 Turner, Walter, of Milton Damerell, husbandman 1
5189859 2412779 2412779 defendant Turner Walter husbandman 587146 587146 Turner, Walter, of Milton Damerell, husbandman 1
5197449 2414997 2414997 defendant Dunne Roger husbandman 587146 587146 Dunne, Roger, of Milton Damerell, husbandman 1
5197451 2414997 2414997 defendant Dourake William husbandman 587146 587146 Dourake, William, of Milton Damerell, husbandman 3
5206681 2417690 2417690 defendant Turner Walter husbandman 587146 587146 Turner, Walter, of Milton Damerell, husbandman 1
5206686 2417692 2417692 defendant Turner Walter husbandman 587146 587146 Turner, Walter, of Milton Damerell, husbandman 1
5208678 2418261 2418261 defendant Don Roger husbandman 587146 587146 Don, Roger, of Milton Damerell, husbandman 1
5210097 2418686 2418686 defendant Dunne Rober husbandman 587146 587146 Dunne, Rober, of Milton Damerell, husbandman 1
5210099 2418686 2418686 defendant Dourake William husbandman 587146 587146 Dourake, William, of Milton Damerell, husbandman 3
5210110 2418688 2418688 defendant Liberdon Thomas husbandman 587146 587146 Liberdon, Thomas, of Milton Damerell, husbandman 2
5218125 2421037 2421037 defendant Sandy William husbandman 587146 587146 Sandy, William, of Milton Damerell, husbandman 1
5221683 2422038 2422038 defendant Draper Thomas husbandman 587146 587146 Draper, Thomas, of Milton Damerell, husbandman 2
5224879 2422949 2422949 defendant Dunne Roger husbandman 587146 587146 Dunne, Roger, of Milton Damerell, husbandman 0
5224881 2422949 2422949 defendant Tourner Walter husbandman 587146 587146 Tourner, Walter, of Milton Damerell, husbandman 2
5224882 2422949 2422949 defendant Kenne John husbandman 587146 587146 Kenne, John, of Milton Damerell, or of Neweton St Petroc, husbandman 3
5224883 2422949 2422949 defendant Reve John smith 587146 587146 Reve, John, of Milton Damerell, smith 4
5234761 2425755 2425755 defendant Dunne Roger husbandman 587146 587146 Dunne, Roger, of Milton Damerell, husbandman 0
5234763 2425755 2425755 defendant Tourner Walter husbandman 587146 587146 Tourner, Walter, of Milton Damerell, husbandman 2
5252293 2430827 2430827 defendant Dunne Roger husbandman 587146 587146 Dunne, Roger, of Milton Damerell, husbandman 2
5313067 2448941 2448941 defendant Huyrd Walter yeoman 587146 587146 Huyrd, Walter, of Milton Damerell, yeoman 0
5333736 2455164 2455164 defendant Dirworthy Rose widow 587146 587146 Dirworthy, Rose, of Milton Damerell, widow 0
5333737 2455164 2455164 defendant Torner Robert   587146 587146 Torner, Robert, of Milton Damerell, groom 1
5349286 2459904 2459904 defendant Stapilhill Richard yeoman 587146 587146 Stapilhill, Richard, of Milton Damerell, yeoman 2
5399653 2474986 2474986 defendant Draper Englesia widow 587146 587146 Draper, Englesia, of Milton Damerell, widow 2
5412691 2478743 2478743 defendant Draper Englesia widow 587146 587146 Draper, Englesia, of Milton Damerell, widow 2
5412695 2478744 2478744 defendant Draper Englesia widow 587146 587146 Draper, Englesia, of Milton Damerell, widow 2
5447106 2489024 2489024 defendant Dene John yeoman 587146 587146 Dene, John, of Milton Damerell, yeoman 0
5471656 2496471 2496471 defendant Doune John husbandman 587146 587146 Doune, John, of Milton Damerell, husbandman 0
5480063 2499025 2499025 defendant Gay Richard husbandman 587146 587146 Gay, Richard, of Milton Damerell, husbandman 0
5520570 2511259 2511259 defendant Baggebeare Stephen husbandman 587146 587146 Baggebeare, Stephen, of Milton Damerell, husbandman 1
5530006 2513891 2513891 defendant Bukpit Richard husbandman 587146 587146 Bukpit, Richard, of Milton Damerell, husbandman 1
5562360 2523592 2523592 defendant Herde Robert gent 587146 587146 Herde, Robert, of Milton Damerell, gent 0
5562756 2523693 2523693 defendant Knyght William husbandman 587146 587146 Knyght, William, of Milton Damerell, 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);