names

90 rows where place_id = 640819

✎ 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
3857652 1976030 1976030 defendant Broke John gent 640819 640819 Broke, John, of Berham, gent 0
4413076 2168961 2168961 plaintiff atte Cherche Thomas   640819 640819 atte Cherche, Thomas, of Berham 0
4464642 2189609 2189609 defendant Sprenget John   640819 640819 Sprenget, John, of Berham 5
4470375 2191383 2191383 plaintiff Broke William   640819 640819 Broke, William, of Berham 0
4488090 2196993 2196993 defendant Broke William   640819 640819 Broke, William, of Berham 0
4545239 2214433 2214433 defendant Gate John   640819 640819 Gate, John, of Berham 0
4548015 2215314 2215314 defendant Bekke John   640819 640819 Bekke, John, of Berham 0
4550757 2216177 2216177 defendant Lynche John   640819 640819 Lynche, John, of Berham 1
4551534 2216420 2216420 plaintiff Dygge John   640819 640819 Dygge, John, of Berham 0
4576226 2224066 2224066 plaintiff Broke William   640819 640819 Broke, William, of Berham 0
4581607 2225696 2225696 plaintiff Dygge John   640819 640819 Dygge, John, of Berham 0
4584623 2226611 2226611 defendant Miller Walter   640819 640819 Miller, Walter, of Berham 0
4600310 2231326 2231326 defendant Gate Thomas   640819 640819 Gate, Thomas, of Berham 0
4628608 2239872 2239872 defendant Man John   640819 640819 Man, John, of Berham 0
4628609 2239872 2239872 defendant Man Thomas   640819 640819 Man, Thomas, of Berham 1
4647335 2245275 2245275 defendant Opton Richard   640819 640819 Opton, Richard, of Berham 1
4670299 2256417 2256417 plaintiff Brownynge Thomas   640819 640819 Brownynge, Thomas, of Berham 0
4677095 2258453 2258453 defendant Swetey Edmund husbandman 640819 640819 Swetey, Edmund, of Berham, husbandman 2
4693046 2263332 2263332 defendant Wetherden Roger gent 640819 640819 Wetherden, Roger, of Berham, gent 0
4722742 2272429 2272429 defendant Okyndende Thomas yeoman 640819 640819 Okyndende, Thomas, of Berham, yeoman 0
4796382 2295018 2295018 defendant Gate William butcher 640819 640819 Gate, William, of Berham, butcher 1
4848207 2310911 2310911 defendant Sweteye John butcher 640819 640819 Sweteye, John, of Berham, butcher 0
4868215 2317037 2317037 defendant Swetey John butcher 640819 640819 Swetey, John, of Berham, butcher 0
4868216 2317037 2317037 defendant Aveyn or Anevyn William butcher 640819 640819 Aveyn or Anevyn, William, of Berham, butcher 1
4875820 2319401 2319401 defendant Sweteye John butcher 640819 640819 Sweteye, John, of Berham, butcher 0
4875821 2319401 2319401 defendant Anevyn Richard butcher 640819 640819 Anevyn, Richard, of Berham, butcher 1
4884245 2321981 2321981 defendant Flesshware John husbandman 640819 640819 Flesshware, John, of Berham, husbandman 0
4896907 2325685 2325685 defendant Cokeselle Simon laborer 640819 640819 Cokeselle, Simon, of Berham, laborer 0
4896908 2325685 2325685 defendant Okynden Thomas husbandman 640819 640819 Okynden, Thomas, of Berham, husbandman 1
4896911 2325685 2325685 defendant Sweteye John butcher 640819 640819 Sweteye, John, of Berham, butcher 4
4929967 2335780 2335780 defendant Coksell Simon yeoman 640819 640819 Coksell, Simon, of Berham, yeoman 1
4929970 2335780 2335780 defendant Flesshware John husbandman 640819 640819 Flesshware, John, of Berham, husbandman 4
4938439 2338400 2338400 defendant Valentyn Andrew chaplain 640819 640819 Valentyn, Andrew, of Berham, chaplain 0
4938440 2338400 2338400 defendant Mellers John   640819 640819 Mellers, John, of Berham, mason 1
4944221 2340164 2340164 defendant Coksell Simon yeoman 640819 640819 Coksell, Simon, of Berham, yeoman 0
4945307 2340508 2340508 defendant Coksell Simon husbandman 640819 640819 Coksell, Simon, of Berham, husbandman 0
4960811 2345195 2345195 defendant Swetey John butcher 640819 640819 Swetey, John, of Berham, butcher 3
4968330 2347491 2347491 defendant Broun John husbandman 640819 640819 Broun, John, of Berham, husbandman 0
4971016 2348272 2348272 defendant Coksell Simon husbandman 640819 640819 Coksell, Simon, of Berham, husbandman 0
4993589 2354956 2354956 defendant Swetey John butcher 640819 640819 Swetey, John, of Berham, butcher 1
5008426 2359355 2359355 plaintiff Symond John (legal representative) 640819 640819 Symond, John, of Berham, husbandman, executor of 0
5041450 2369048 2369048 defendant Dygge John esq 640819 640819 Dygge, John, of Berham, esq 0
5056857 2373626 2373626 defendant Swetey John butcher 640819 640819 Swetey, John, of Berham, butcher 0
5056858 2373626 2373626 defendant Stuphilde John, senior husbandman 640819 640819 Stuphilde, John, senior, of Berham, husbandman 1
5060632 2374759 2374759 defendant Bobbyng alias Thacher John thatcher 640819 640819 Bobbyng alias Thacher, John, of Berham, thatcher 1
5070418 2377645 2377645 defendant atte Gate William butcher 640819 640819 atte Gate, William, of Berham, butcher 0
5070420 2377646 2377646 defendant Lote William carpenter 640819 640819 Lote, William, of Berham, carpenter 0
5082785 2381357 2381357 plaintiff Dygges John, senior (legal representative) 640819 640819 Dygges, John, senior, of Berham, gent, executors of 0
5082788 2381357 2381357 defendant Wyngate John (legal representative) 640819 640819 Wyngate, John, of Berham, husbandman, executors of 0
5082790 2381357 2381357 defendant Coksell Simon husbandman 640819 640819 Coksell, Simon, of Berham, husbandman 2
5083725 2381636 2381636 defendant Coksell Simon yeoman 640819 640819 Coksell, Simon, of Berham, yeoman 0
5085049 2382038 2382038 defendant atte Gate William butcher 640819 640819 atte Gate, William, of Berham, butcher 2
5093221 2384410 2384410 defendant Gate William butcher 640819 640819 Gate, William, of Berham, butcher 0
5110454 2389462 2389462 defendant Gate William husbandman 640819 640819 Gate, William, of Berham, husbandman 0
5115717 2391023 2391023 defendant Broun Thomas yeoman 640819 640819 Broun,Thomas, of Berham, yeoman 0
5119560 2392151 2392151 defendant Furner or Furver John yeoman 640819 640819 Furner or Furver, John, of Berham, yeoman 0
5211671 2419153 2419153 defendant Bonyng Peter husbandman 640819 640819 Bonyng, Peter, of Berham, husbandman 1
5214170 2419871 2419871 plaintiff Broune Thomas   640819 640819 Broune, Thomas, of Berham 0
5229327 2424189 2424189 defendant Stokke William laborer 640819 640819 Stokke, William, of Berham, laborer 0
5235095 2425845 2425845 defendant Browne Thomas husbandman 640819 640819 Browne, Thomas, of Berham, husbandman 1
5235096 2425845 2425845 defendant Lotte William husbandman 640819 640819 Lotte, William, of Berham, husbandman 2
5255250 2431758 2431758 defendant Marston Thomas husbandman 640819 640819 Marston, Thomas, of Berham, husbandman 0
5255251 2431758 2431758 defendant Browene Thomas yeoman 640819 640819 Browene, Thomas, of Berham, yeoman 1
5282963 2440079 2440079 plaintiff Dygges John   640819 640819 Dygges, John, of Berham, esq, sheriff of Kent 0
5300053 2444981 2444981 defendant Tebbe Richard husbandman 640819 640819 Tebbe, Richard, of Berham, husbandman 1
5302027 2445562 2445562 defendant Tebbe Richard husbandman 640819 640819 Tebbe, Richard, of Berham, husbandman 0
5302028 2445562 2445562 defendant Broun William husbandman 640819 640819 Broun, William, of Berham, husbandman 1
5306490 2446929 2446929 defendant Baker John husbandman 640819 640819 Baker, John, of Berham, husbandman 4
5359952 2463152 2463152 plaintiff Sahevyle or Sakefeld Richard gent 640819 640819 Sahevyle or Sakefeld, Richard, of Berham, gent 0
5359955 2463152 2463152 defendant Innar or Junar William butcher 640819 640819 Innar or Junar, William, of Berham, butcher 2
5372900 2467117 2467117 plaintiff Lotte William carpenter 640819 640819 Lotte, William, of Berham, carpenter 0
5380313 2469419 2469419 defendant Feykyn Robert cooper 640819 640819 Feykyn, Robert, of Berham, cooper 0
5384837 2470738 2470738 defendant Feykyn Robert cooper 640819 640819 Feykyn, Robert, of Berham, cooper 0
5394056 2473361 2473361 defendant Lane Richard husbandman 640819 640819 Lane, Richard, of Berham, husbandman 1
5411137 2478288 2478288 defendant Beaute William husbandman 640819 640819 Beaute, William, of Berham, husbandman 1
5420423 2481033 2481033 defendant Lane Richard husbandman 640819 640819 Lane, Richard, of Berham, husbandman 1
5431153 2484258 2484258 defendant Lote William husbandman 640819 640819 Lote, William, of Berham, husbandman 0
5439256 2486671 2486671 defendant Lane Richard husbandman 640819 640819 Lane, Richard, of Berham, husbandman 1
5439260 2486672 2486672 defendant Lene Richard husbandman 640819 640819 Lene, Richard, of Berham, husbandman 1
5452964 2490767 2490767 defendant Knetthebole William husbandman 640819 640819 Knetthebole, William, of Berham, husbandman 1
5485531 2500582 2500582 defendant Fekyn Robert cooper 640819 640819 Fekyn, Robert, of Berham, cooper 0
5485532 2500582 2500582 defendant Fekyn Stephen cooper 640819 640819 Fekyn, Stephen, of Berham, cooper 1
5494718 2503309 2503309 defendant Fewekyn Robert husbandman 640819 640819 Fewekyn, Robert, of Berham, husbandman 1
5539766 2516918 2516918 defendant Johnson Henry chaplain 640819 640819 Johnson, Henry, of Berham, chaplain 0
5593358 2532902 2532902 defendant Hart William yeoman 640819 640819 Hart, William, of Berham, yeoman 0
5593359 2532902 2532902 defendant Cok Richard yeoman 640819 640819 Cok, Richard, of Berham, yeoman 1
5593360 2532902 2532902 defendant Frenche Thomas yeoman 640819 640819 Frenche, Thomas, of Berham, yeoman 2
5593362 2532902 2532902 defendant Bartylmewe Thomas yeoman 640819 640819 Bartylmewe, Thomas, of Berham, yeoman 4
5611057 2547178 2547178 defendant Petard John   640819 640819 Petard, John, of Berham 0
5634257 2554698 2554698 defendant Tely Walter laborer 640819 640819 Tely, Walter, of Berham, laborer 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);