names

84 rows where place_id = 586183

✎ 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
3588106 1863929 1863929 defendant Snathe Richard yeoman 586183 586183 Snathe, Richard, of Broghton, yeoman 0
3756692 1944067 1944067 defendant Sykes John clerk 586183 586183 Sykes, John, of Broghton, clerk 5
3889556 1986739 1986739 defendant Pedder Henry yeoman 586183 586183 Pedder, Henry, of Broghton, yeoman 0
4420956 2171451 2171451 plaintiff Chartres Elizabeth   586183 586183 Chartres, Elizabeth, of Broghton 0
4420957 2171451 2171451 defendant Aldy John   586183 586183 Aldy, John, of Broghton 0
4423805 2172292 2172292 defendant Warenner Hugh le   586183 586183 Warenner, Hugh le, of Broghton 1
4427379 2173400 2173400 defendant del Halle William   586183 586183 del Halle, William, of Broghton 0
4443083 2182798 2182798 defendant Rothewell John chaplain 586183 586183 Rothewell, John, of Broghton, chaplain 2
4454471 2186411 2186411 defendant del Yate William   586183 586183 del Yate, William, of Broghton 0
4454473 2186412 2186412 defendant del Yate William   586183 586183 del Yate, William, of Broghton 0
4458442 2187684 2187684 defendant Cam-- Richard   586183 586183 Cam--, Richard, of Broghton 0
4473542 2192383 2192383 defendant Bray Hugh   586183 586183 Bray, Hugh, of Broghton 0
4533231 2210653 2210653 defendant Pacok John   586183 586183 Pacok, John, of Broghton 0
4538987 2212459 2212459 defendant Smyth Nicholas   586183 586183 Smyth, Nicholas, of Broghton 4
4554280 2217264 2217264 defendant Bygenore Richard   586183 586183 Bygenore, Richard, of Broghton 0
4558163 2218494 2218494 plaintiff Lofthous Nicholas de   586183 586183 Lofthous, Nicholas de, of Broghton 0
4560305 2219162 2219162 defendant Lokweod Thmas   586183 586183 Lokweod, Thmas, of Broghton 31
4561446 2219515 2219515 defendant Lokwod Thomas   586183 586183 Lokwod, Thomas, of Broghton 44
4568246 2221640 2221640 defendant Mason John   586183 586183 Mason, John, of Broghton 0
4600844 2231487 2231487 defendant Bocher Stephen   586183 586183 Bocher, Stephen, of Broghton 1
4613477 2235231 2235231 defendant Lokwode John   586183 586183 Lokwode, John, of Broghton 0
4615393 2235822 2235822 defendant Gore Thomas   586183 586183 Gore, Thomas, of Broghton 0
4615395 2235823 2235823 defendant Gore Thomas   586183 586183 Gore, Thomas, of Broghton 0
4631177 2240652 2240652 defendant Gore Thomas   586183 586183 Gore, Thomas, of Broghton, son of Robert 0
4657606 2248270 2248270 defendant Brid John butcher 586183 586183 Brid, John, of Broghton, butcher 0
4657608 2248271 2248271 defendant Brid John butcher 586183 586183 Brid, John, of Broghton, butcher 0
4665556 2250698 2250698 defendant Gore Thomas husbandman 586183 586183 Gore, Thomas, of Broghton, husbandman 0
4680679 2259571 2259571 defendant Leek Robert gent 586183 586183 Leek, Robert, of Broghton, gent 0
4681577 2259851 2259851 defendant Walssh John   586183 586183 Walssh, John, of Broghton, shepherd 0
4711405 2268897 2268897 defendant Addeson John husbandman 586183 586183 Addeson, John, of Broghton, husbandman 4
4727702 2273906 2273906 defendant Gilson John husbandman 586183 586183 Gilson, John, of Broghton, husbandman 0
4762038 2284111 2284111 defendant Gay Philip husbandman 586183 586183 Gay, Philip, of Broghton, husbandman 1
4762039 2284111 2284111 defendant Dedemyll Thomas husbandman 586183 586183 Dedemyll, Thomas, of Broghton, husbandman 2
4762045 2284113 2284113 defendant Gay Philip husbandman 586183 586183 Gay, Philip, of Broghton, husbandman 0
4773609 2287715 2287715 defendant Ferle John clerk 586183 586183 Ferle, John, of Broghton, clerk 0
4787313 2292102 2292102 plaintiff Grenehull John   586183 586183 Grenehull, John, of Broghton 0
4787314 2292102 2292102 defendant Curteys William husbandman 586183 586183 Curteys, William, of Broghton, husbandman 0
4793432 2294053 2294053 defendant Wymboldm John husbandman 586183 586183 Wymboldm John, of Broghton, husbandman 0
4807370 2298501 2298501 defendant Treman Richard husbandman 586183 586183 Treman, Richard, of Broghton, husbandman 3
4815599 2300985 2300985 defendant Hethe Robert husbandman 586183 586183 Hethe, Robert, of Broghton, husbandman 0
4815600 2300985 2300985 defendant Deye John husbandman 586183 586183 Deye, John, of Broghton, husbandman 1
4815601 2300985 2300985 defendant Davys Henry laborer 586183 586183 Davys, Henry, of Broghton, laborer 2
4818166 2301757 2301757 defendant Hethe Robert husbandman 586183 586183 Hethe, Robert, of Broghton, husbandman 0
4819549 2302192 2302192 defendant Wykham Thomas   586183 586183 Wykham, Thomas, of Broghton, knight 2
4826801 2304422 2304422 defendant Whitmer William   586183 586183 Whitmer, William, of Broghton, parson 1
4834885 2306913 2306913 plaintiff del Spence William   586183 586183 del Spence, William, of Broghton, parson 1
4845305 2310043 2310043 plaintiff Pacok Thomas   586183 586183 Pacok, Thomas, of Broghton 0
4847531 2310730 2310730 defendant Dedemylle John   586183 586183 Dedemylle, John, of Broghton, wheel wright 0
4863986 2315711 2315711 defendant Brygger Edward husbandman 586183 586183 Brygger, Edward, of Broghton, husbandman 1
4864064 2315735 2315735 defendant Gore Thomas husbandman 586183 586183 Gore, Thomas, of Broghton, husbandman 0
4864065 2315735 2315735 defendant Smyth Thomas husbandman 586183 586183 Smyth, Thomas, of Broghton, husbandman 1
4866933 2316619 2316619 defendant Wattys John husbandman 586183 586183 Wattys, John, of Broghton, husbandman 3
4872856 2318462 2318462 plaintiff Pacok Thomas   586183 586183 Pacok, Thomas, of Broghton 0
4888776 2323279 2323279 defendant Dewy William tanner 586183 586183 Dewy, William, of Broghton, tanner 0
4900008 2326641 2326641 plaintiff Tenman John   586183 586183 Tenman, John, of Broghton 0
4900009 2326641 2326641 defendant Gilmyn Thomas husbandman 586183 586183 Gilmyn, Thomas, of Broghton, husbandman 0
4900010 2326641 2326641 defendant Gilmyn Ralph husbandman 586183 586183 Gilmyn, Ralph, of Broghton, husbandman 1
4900011 2326641 2326641 defendant Gilmyn Richard husbandman 586183 586183 Gilmyn, Richard, of Broghton, husbandman 2
4920810 2333023 2333023 defendant Clerk John husbandman 586183 586183 Clerk, John, of Broghton, husbandman 0
4926628 2334747 2334747 defendant Hyne or Hyve Robert yoeman 586183 586183 Hyne or Hyve, Robert, of Broghton, yoeman 3
4952054 2342585 2342585 defendant Walshe John   586183 586183 Walshe, John, of Broghton, shepherd 0
4952055 2342585 2342585 defendant Beverley Thomas husbandman 586183 586183 Beverley, Thomas, of Broghton, husbandman 1
4952063 2342585 2342585 defendant Fraunkeleyn John husbandman 586183 586183 Fraunkeleyn, John, of Broghton, husbandman 9
4974154 2349227 2349227 defendant Frewen John husbandman 586183 586183 Frewen, John, of Broghton, husbandman 1
4978242 2350443 2350443 defendant Fraunkeleyn Thomas husbandman 586183 586183 Fraunkeleyn, Thomas, of Broghton, husbandman 2
4986658 2352943 2352943 defendant Benet John husbandman 586183 586183 Benet, John, of Broghton, husbandman 0
4988766 2353596 2353596 defendant Dalawe Alan yeoman 586183 586183 Dalawe, Alan, of Broghton, yeoman 0
4988767 2353596 2353596 defendant Dalawe Thomas yeoman 586183 586183 Dalawe, Thomas, of Broghton, yeoman 1
5026778 2364703 2364703 defendant Wright Robert miller 586183 586183 Wright, Robert, of Broghton, miller 0
5073907 2378688 2378688 defendant Whykeham William esq 586183 586183 Whykeham, William, of Broghton, esq 0
5073924 2378688 2378688 defendant Chase John yeoman 586183 586183 Chase, John, of Broghton, yeoman 17
5074870 2378991 2378991 defendant Hedon John husbandman 586183 586183 Hedon, John, of Broghton, husbandman 1
5141477 2398625 2398625 defendant Thorley John esq 586183 586183 Thorley, John, of Broghton, esq 0
5162604 2404785 2404785 defendant Thorley John esq 586183 586183 Thorley, John, of Broghton, esq 0
5176588 2408837 2408837 defendant Thorley John esq 586183 586183 Thorley, John, of Broghton, esq 0
5198825 2415409 2415409 defendant Thorley John esq 586183 586183 Thorley, John, of Broghton, esq 0
5230295 2424480 2424480 plaintiff Balle John (legal representative) 586183 586183 Balle, John, of Broghton, executors of 0
5242776 2428091 2428091 defendant Forde Joan widow 586183 586183 Forde, Joan, of Broghton, widow 1
5242777 2428091 2428091 defendant Pulter Richard husbandman 586183 586183 Pulter, Richard, of Broghton, husbandman 2
5242778 2428091 2428091 defendant Pulter Thomas husbandman 586183 586183 Pulter, Thomas, of Broghton, husbandman 3
5631551 2553879 2553879 defendant Reve Thomas husbandman 586183 586183 Reve, Thomas, of Broghton, husbandman 1
5631552 2553879 2553879 defendant Dun Richard workman 586183 586183 Dun, Richard, of Broghton, workman 2
5631639 2553906 2553906 defendant Chatesden John yeoman 586183 586183 Chatesden, John, of Broghton, yeoman 4
5631642 2553907 2553907 defendant Chatesden John yeoman 586183 586183 Chatesden, John, of Broghton, yeoman 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);