names

82 rows where place_id = 590680

✎ 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
3601967 1868272 1868272 defendant Tadlowe John, senior husbandman 590680 590680 Tadlowe, John, senior, of Bassyngburn, husbandman 0
3601968 1868272 1868272 defendant Drury John husbandman 590680 590680 Drury, John, of Bassyngburn, husbandman 1
3601969 1868272 1868272 defendant Rykner Thomas husbandman 590680 590680 Rykner, Thomas, of Bassyngburn, husbandman 2
3629507 1904085 1904085 defendant Frankeleyn John thatcher 590680 590680 Frankeleyn, John, of Bassyngburn, thatcher 0
3681501 1920305 1920305 defendant Wrotham Thomas husbandman 590680 590680 Wrotham, Thomas, of Bassyngburn, husbandman 1
3681502 1920305 1920305 defendant Newman William husbandman 590680 590680 Newman, William, of Bassyngburn, husbandman 2
3867566 1979387 1979387 defendant Pynke Thomas husbandman 590680 590680 Pynke, Thomas, of Bassyngburn, husbandman 2
3904063 1991601 1991601 defendant Dewes John (legal representative) 590680 590680 Dewes, John, of Bassyngburn, clerk, executor of 0
4434740 2175630 2175630 defendant Beneyt John chaplain 590680 590680 Beneyt, John, of Bassyngburn, chaplain 0
4448568 2184479 2184479 defendant Bate John   590680 590680 Bate, John, of Bassyngburn 0
4448572 2184481 2184481 defendant Bate John   590680 590680 Bate, John, of Bassyngburn 0
4485364 2196125 2196125 defendant Prentys John   590680 590680 Prentys, John, of Bassyngburn 0
4491380 2197993 2197993 plaintiff Whitteby Robert   590680 590680 Whitteby, Robert, of Bassyngburn, parson 0
4504075 2201822 2201822 plaintiff Pynk John   590680 590680 Pynk, John, of Bassyngburn 0
4540849 2213042 2213042 defendant Roo Walter   590680 590680 Roo, Walter, of Bassyngburn 2
4540855 2213044 2213044 defendant Roo Walter   590680 590680 Roo, Walter, of Bassyngburn 2
4540899 2213060 2213060 plaintiff Whitteby Robert   590680 590680 Whitteby, Robert, of Bassyngburn, parson 0
4552588 2216761 2216761 defendant Gamul John   590680 590680 Gamul, John, of Bassyngburn 2
4576983 2224310 2224310 defendant Barkere Thomas   590680 590680 Barkere, Thomas, of Bassyngburn 0
4576984 2224310 2224310 defendant Baile Walter   590680 590680 Baile, Walter, of Bassyngburn 1
4595003 2229694 2229694 defendant Andrewe John   590680 590680 Andrewe, John, of Bassyngburn 0
4600500 2231378 2231378 defendant Bone William   590680 590680 Bone, William, of Bassyngburn 4
4600501 2231378 2231378 defendant Batte William   590680 590680 Batte, William, of Bassyngburn 5
4602925 2232129 2232129 plaintiff Whitteby Robert   590680 590680 Whitteby, Robert, of Bassyngburn, parson 0
4635410 2241915 2241915 defendant Bocher William   590680 590680 Bocher, William, of Bassyngburn 1
4640570 2243350 2243350 plaintiff Dymersh John   590680 590680 Dymersh, John, of Bassyngburn 0
4640571 2243350 2243350 defendant Bocher William   590680 590680 Bocher, William, of Bassyngburn 0
4640573 2243350 2243350 defendant Hebbe John   590680 590680 Hebbe, John, of Bassyngburn 2
4640574 2243350 2243350 defendant Hale John   590680 590680 Hale, John, of Bassyngburn 3
4649614 2245919 2245919 defendant Bate William   590680 590680 Bate, William, of Bassyngburn 0
4651310 2246414 2246414 defendant Paton John, senior husbandman 590680 590680 Paton, John, senior, of Bassyngburn, husbandman 2
4651311 2246414 2246414 defendant Rous Thomas   590680 590680 Rous, Thomas, of Bassyngburn 3
4656785 2248016 2248016 defendant Pondere or Poudere William husbandman 590680 590680 Pondere or Poudere, William, of Bassyngburn, husbandman 1
4692392 2263137 2263137 defendant Parkyn William husbandman 590680 590680 Parkyn, William, of Bassyngburn, husbandman 0
4692394 2263137 2263137 defendant Orabbe John husbandman 590680 590680 Orabbe, John, of Bassyngburn, husbandman 2
4695785 2264164 2264164 defendant Pynk John   590680 590680 Pynk, John, of Bassyngburn, franklin 0
4716302 2270409 2270409 defendant Paton John, sen husbandman 590680 590680 Paton, John, sen, of Bassyngburn, husbandman 1
4723563 2272673 2272673 defendant Danbour John husbandman 590680 590680 Danbour, John, of Bassyngburn, husbandman 0
4728809 2274249 2274249 defendant Maior Robert husbandman 590680 590680 Maior, Robert, of Bassyngburn, husbandman 0
4756608 2282431 2282431 defendant Perkyr Hugh husbandman 590680 590680 Perkyr, Hugh, of Bassyngburn, husbandman 0
4756609 2282431 2282431 defendant Holle William husbandman 590680 590680 Holle, William, of Bassyngburn, husbandman 1
4756610 2282431 2282431 defendant Dulberd John husbandman 590680 590680 Dulberd, John, of Bassyngburn, husbandman 2
4759014 2283170 2283170 defendant Dolberd John husbandman 590680 590680 Dolberd, John, of Bassyngburn, husbandman 0
4759015 2283170 2283170 defendant Danbour John husbandman 590680 590680 Danbour, John, of Bassyngburn, husbandman 1
4773795 2287781 2287781 defendant Pynke William yeoman 590680 590680 Pynke, William, of Bassyngburn, yeoman 0
4799184 2295925 2295925 defendant Pynke William yeoman 590680 590680 Pynke, William, of Bassyngburn, yeoman 0
4839581 2308299 2308299 defendant Paton Simon husbandman 590680 590680 Paton, Simon, of Bassyngburn, husbandman 1
4841119 2308756 2308756 defendant Tadlowe John husbandman 590680 590680 Tadlowe, John, of Bassyngburn, husbandman 0
4846686 2310473 2310473 defendant Fodryngeye John tailor 590680 590680 Fodryngeye, John, of Bassyngburn, tailor 0
4846688 2310473 2310473 defendant Lyon William husbandman 590680 590680 Lyon, William, of Bassyngburn, husbandman 2
4846689 2310473 2310473 defendant Bocher William butcher 590680 590680 Bocher, William, of Bassyngburn, butcher 3
4858630 2314071 2314071 defendant Bolnydhers or Bolvydhers John, junior husbandman 590680 590680 Bolnydhers or Bolvydhers, John, junior, of Bassyngburn, husbandman 1
4858633 2314072 2314072 defendant Bolvydhers or Bolnydhers John, junior husbandman 590680 590680 Bolvydhers or Bolnydhers, John, junior, of Bassyngburn, husbandman 1
4865575 2316198 2316198 plaintiff Gode John   590680 590680 Gode, John, of Bassyngburn 0
4866799 2316580 2316580 defendant Paton Simon husbandman 590680 590680 Paton, Simon, of Bassyngburn, husbandman 0
4916871 2331778 2331778 defendant Foderyngey John husbandman 590680 590680 Foderyngey, John, of Bassyngburn, husbandman 3
4944490 2340257 2340257 defendant Foderyngey John husbandman 590680 590680 Foderyngey, John, of Bassyngburn, husbandman 0
4944491 2340257 2340257 defendant Foderyngey John, junior   590680 590680 Foderyngey, John, junior, of Bassyngburn, husbandman, his son 1
4944492 2340257 2340257 defendant Haukyn Walter butcher 590680 590680 Haukyn, Walter, of Bassyngburn, butcher 2
4945981 2340730 2340730 defendant Tadlowe John husbandman 590680 590680 Tadlowe, John, of Bassyngburn, husbandman 0
4988995 2353645 2353645 defendant Angetyn George husbandman 590680 590680 Angetyn, George, of Bassyngburn, husbandman 2
4989008 2353648 2353648 defendant Angetyn George husbandman 590680 590680 Angetyn, George, of Bassyngburn, husbandman 2
4991496 2354339 2354339 defendant Fodryngey John   590680 590680 Fodryngey, John, of Bassyngburn 8
4996762 2355891 2355891 defendant Hawekyn Walter husbandman 590680 590680 Hawekyn, Walter, of Bassyngburn, husbandman 0
5016093 2361585 2361585 defendant Aungevyn George husbandman 590680 590680 Aungevyn, George, of Bassyngburn, husbandman 3
5110490 2389471 2389471 defendant Taddelowe William husbandman 590680 590680 Taddelowe, William, of Bassyngburn, husbandman 2
5110492 2389471 2389471 defendant Parkyn John husbandman 590680 590680 Parkyn, John, of Bassyngburn, husbandman 4
5111276 2389688 2389688 defendant Parkyn John husbandman 590680 590680 Parkyn, John, of Bassyngburn, husbandman 1
5152065 2401740 2401740 defendant Taddelow John husbandman 590680 590680 Taddelow, John, of Bassyngburn, husbandman 4
5169985 2406955 2406955 defendant Taddelowe John husbandman 590680 590680 Taddelowe, John, of Bassyngburn, husbandman 3
5240740 2427500 2427500 defendant Derby John tiler 590680 590680 Derby, John, of Bassyngburn, tiler 2
5391808 2472732 2472732 defendant Gery Thomas   590680 590680 Gery, Thomas, of Bassyngburn 0
5470430 2496077 2496077 plaintiff Gery Thomas   590680 590680 Gery, Thomas, of Bassyngburn 0
5481852 2499506 2499506 plaintiff Gery Thomas   590680 590680 Gery, Thomas, of Bassyngburn 0
5537432 2516202 2516202 defendant Lorkyn Walter gent 590680 590680 Lorkyn, Walter, of Bassyngburn, gent 0
5613304 2547943 2547943 defendant Baillyf Walter   590680 590680 Baillyf, Walter, of Bassyngburn 1
5618136 2549492 2549492 defendant Baillyf Walter   590680 590680 Baillyf, Walter, of Bassyngburn 2
5619444 2549929 2549929 defendant Swone William   590680 590680 Swone, William, of Bassyngburn 0
5623803 2551385 2551385 defendant Bate William yeoman 590680 590680 Bate, William, of Bassyngburn, yeoman 0
5633759 2554554 2554554 defendant Staveler John husbandman 590680 590680 Staveler, John, of Bassyngburn, husbandman 1
5633760 2554554 2554554 defendant Bone or Boue William yeoman 590680 590680 Bone or Boue, William, of Bassyngburn, yeoman 2
5635799 2555152 2555152 defendant Grayland William butcher 590680 590680 Grayland, William, of Bassyngburn, butcher 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);