names

60 rows where place_id = 594708

✎ 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
3617259 1873022 1873022 defendant Hanam Richard tucker 594708 594708 Hanam, Richard, of Wryngton, tucker 0
3629982 1904229 1904229 defendant Whyte Thomas husbandman 594708 594708 Whyte, Thomas, of Wryngton, husbandman 1
3753470 1943023 1943023 defendant Browne John husbandman 594708 594708 Browne, John, of Wryngton, husbandman 0
3771899 1948903 1948903 defendant Wever Richard yeoman 594708 594708 Wever, Richard, of Wryngton, yeoman 0
3847138 1972657 1972657 defendant Beston John husbandman 594708 594708 Beston, John, of Wryngton, husbandman 1
3937467 2002867 2002867 defendant Smythes John yeoman 594708 594708 Smythes, John, of Wryngton, yeoman 0
4043325 2040081 2040081 plaintiff Playce Richard husbandman 594708 594708 Playce, Richard, of Wryngton, husbandman 0
4091631 2057300 2057300 defendant Worye John husbandman 594708 594708 Worye, John, of Wryngton, husbandman 0
4092749 2057716 2057716 defendant Lawrence John husbandman 594708 594708 Lawrence, John, of Wryngton, husbandman 2
4145563 2076604 2076604 defendant Spencer William husbandman 594708 594708 Spencer, William, of Wryngton, husbandman 0
4198697 2095103 2095103 defendant Gybson John husbandman 594708 594708 Gybson, John, of Wryngton, husbandman 0
4262826 2117235 2117235 defendant Macy John yeoman 594708 594708 Macy, John, of Wryngton, yeoman 0
4470564 2191441 2191441 plaintiff Browning John   594708 594708 Browning, John, of Wryngton 0
4491755 2198105 2198105 defendant Pegan William   594708 594708 Pegan, William, of Wryngton 1
4491756 2198105 2198105 defendant Smyth John   594708 594708 Smyth, John, of Wryngton 2
4491757 2198105 2198105 defendant Wodewale William   594708 594708 Wodewale, William, of Wryngton 3
4517754 2205944 2205944 defendant Lydeford Martin (legal representative) 594708 594708 Lydeford, Martin, of Wryngton, parson, executor of 0
4591290 2228633 2228633 plaintiff Middelworth William (legal representative) 594708 594708 Middelworth, William, of Wryngton, parson, executors of 0
4601342 2231655 2231655 defendant Lauerence William   594708 594708 Lauerence, William, of Wryngton 0
4601344 2231656 2231656 defendant Lauerence William   594708 594708 Lauerence, William, of Wryngton 0
4623657 2238377 2238377 plaintiff (not given) William rector of Middelworth 594708 594708 Middelworth, William, of Wryngton, formerly parson & rector of the church, executors of 0
4623662 2238378 2238378 plaintiff Middelworth William (legal representative) 594708 594708 Middelworth, William, of Wryngton, parson, executors of 0
4623667 2238379 2238379 plaintiff Middeworth William (legal representative) 594708 594708 Middeworth, William, of Wryngton, parson, executors of 0
4707596 2267737 2267737 plaintiff Middelworth William (legal representative) 594708 594708 Middelworth, William, of Wryngton, parson of the parish church, executors of 0
4731065 2274921 2274921 plaintiff Middelworth William (legal representative) 594708 594708 Middelworth, William, of Wryngton, master & parson of the parish church, executors of 0
4731070 2274922 2274922 plaintiff Middelworth William (legal representative) 594708 594708 Middelworth, William, of Wryngton, master & parson, executors of 0
4768017 2285965 2285965 plaintiff Middelworth William (legal representative) 594708 594708 Middelworth, William, of Wryngton, master & parson, executors of 0
4821463 2302798 2302798 defendant Dale Richard husbandman 594708 594708 Dale, Richard, of Wryngton, husbandman 0
4824172 2303634 2303634 defendant Lauerence William husbandman 594708 594708 Lauerence, William, of Wryngton, husbandman 3
4909074 2329379 2329379 plaintiff Ballard Richard   594708 594708 Ballard, Richard, of Wryngton 0
4909076 2329379 2329379 plaintiff Trewebody John   594708 594708 Trewebody, John, of Wryngton 2
4909077 2329379 2329379 plaintiff Hanham William   594708 594708 Hanham, William, of Wryngton 3
4909078 2329379 2329379 defendant Holbroke Thomas husbandman 594708 594708 Holbroke, Thomas, of Wryngton, husbandman 0
5018902 2362416 2362416 defendant Wodewale John husbandman 594708 594708 Wodewale, John, of Wryngton, husbandman 0
5053852 2372747 2372747 defendant Pocker Richard husbandman 594708 594708 Pocker, Richard, of Wryngton, husbandman 4
5142749 2399005 2399005 defendant Rose John husbandman 594708 594708 Rose, John, of Wryngton, husbandman 0
5176685 2408864 2408864 defendant Trewebody William husbandman 594708 594708 Trewebody, William, of Wryngton, husbandman 0
5176686 2408864 2408864 defendant Taillour William tailor 594708 594708 Taillour, William, of Wryngton, tailor 1
5176687 2408864 2408864 defendant Hogges John husbandman 594708 594708 Hogges, John, of Wryngton, husbandman 2
5224177 2422743 2422743 defendant Trewbody Nicholas (legal representative) 594708 594708 Trewbody, Nicholas, of Wryngton, executor of 0
5224178 2422743 2422743 defendant Wodewale John husbandman 594708 594708 Wodewale, John, of Wryngton, husbandman 1
5227154 2423585 2423585 defendant Jones William tailor 594708 594708 Jones, William, of Wryngton, tailor 18
5227183 2423586 2423586 defendant Jones William tailor 594708 594708 Jones, William, of Wryngton, tailor 18
5346766 2459147 2459147 defendant Roo John, junior husbandman 594708 594708 Roo, John, junior, of Wryngton, husbandman 0
5355371 2461754 2461754 defendant Gurney Isabel widow 594708 594708 Gurney, Isabel, of Wryngton, widow 0
5355372 2461754 2461754 defendant Gurney Richard weaver 594708 594708 Gurney, Richard, of Wryngton, weaver 1
5355373 2461754 2461754 defendant Scryvener John yeoman 594708 594708 Scryvener, John, of Wryngton, yeoman 2
5355374 2461754 2461754 defendant Yaveley or Yaneley John laborer 594708 594708 Yaveley or Yaneley, John, of Wryngton, laborer 3
5523193 2512083 2512083 defendant Gurney John clothmaker 594708 594708 Gurney, John, of Wryngton, clothmaker 1
5544960 2518530 2518530 defendant Bele William husbandman 594708 594708 Bele, William, of Wryngton, husbandman 0
5554151 2521257 2521257 defendant Crosman Thomas husbandman 594708 594708 Crosman, Thomas, of Wryngton, husbandman 1
5554152 2521257 2521257 defendant Ketyngale Thomas husbandman 594708 594708 Ketyngale, Thomas, of Wryngton, husbandman 2
5554153 2521257 2521257 defendant Herte Thomas husbandman 594708 594708 Herte, Thomas, of Wryngton, husbandman 3
5554154 2521257 2521257 defendant Chaundeler alias Atnasse William husbandman 594708 594708 Chaundeler alias Atnasse, William, of Wryngton, husbandman 4
5554157 2521258 2521258 defendant Crosman Thomas husbandman 594708 594708 Crosman, Thomas, of Wryngton, husbandman 1
5554158 2521258 2521258 defendant Ketyngale Thomas husbandman 594708 594708 Ketyngale, Thomas, of Wryngton, husbandman 2
5554159 2521258 2521258 defendant Herte Thomas husbandman 594708 594708 Herte, Thomas, of Wryngton, husbandman 3
5554160 2521258 2521258 defendant Chaunderler William husbandman 594708 594708 Chaunderler, William, of Wryngton, husbandman 4
5554161 2521258 2521258 defendant Atnasse William husbandman 594708 594708 Atnasse, William, of Wryngton, husbandman 5
5564097 2524115 2524115 defendant Ballard Stephen carpenter 594708 594708 Ballard, Stephen, of Wryngton, carpenter 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);