names

76 rows where place_id = 613106

✎ 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
3696642 1925180 1925180 defendant Obley John yeoman 613106 613106 Obley, John, of Petteworth, yeoman 1
3696643 1925180 1925180 defendant Turge William yeoman 613106 613106 Turge, William, of Petteworth, yeoman 2
3696644 1925180 1925180 defendant Bowyer Richard yeoman 613106 613106 Bowyer, Richard, of Petteworth, yeoman 3
3696645 1925180 1925180 defendant Gobill James yeoman 613106 613106 Gobill, James, of Petteworth, yeoman 4
3696646 1925180 1925180 defendant Johnson Anthony yeoman 613106 613106 Johnson, Anthony, of Petteworth, yeoman 5
3696647 1925180 1925180 defendant Bocher William yeoman 613106 613106 Bocher, William, of Petteworth, yeoman 6
3826657 1966183 1966183 defendant White William tailor 613106 613106 White, William, of Petteworth, tailor 0
3845008 1971989 1971989 defendant Acton James clothier 613106 613106 Acton, James, of Petteworth, clothier 0
3860825 1977113 1977113 defendant Acton James clothier 613106 613106 Acton, James, of Petteworth, clothier 0
4435631 2175903 2175903 defendant Cheseman John   613106 613106 Cheseman, John, of Petteworth 2
4483765 2195615 2195615 plaintiff Oset Roger   613106 613106 Oset, Roger, of Petteworth 0
4495102 2199157 2199157 defendant Gynter John   613106 613106 Gynter, John, of Petteworth 0
4495103 2199157 2199157 defendant Porter Henry   613106 613106 Porter, Henry, of Petteworth 1
4499614 2200520 2200520 defendant Sygenye Richard   613106 613106 Sygenye, Richard, of Petteworth 0
4499622 2200521 2200521 defendant Grenvill Walter   613106 613106 Grenvill, Walter, of Petteworth 1
4523645 2207723 2207723 defendant Grenehel Walter   613106 613106 Grenehel, Walter, of Petteworth 1
4535898 2211499 2211499 plaintiff Sopere John   613106 613106 Sopere, John, of Petteworth 0
4568975 2221882 2221882 defendant Rolf John   613106 613106 Rolf, John, of Petteworth 1
4572769 2223021 2223021 plaintiff atte Ymbhawe Thomas   613106 613106 atte Ymbhawe, Thomas, of Petteworth 0
4609756 2234146 2234146 plaintiff Burton John de   613106 613106 Burton, John de, of Petteworth, parson 0
4609759 2234147 2234147 plaintiff Burton John de   613106 613106 Burton, John de, of Petteworth, parson 0
4618719 2236862 2236862 defendant Grenehulle Walter   613106 613106 Grenehulle, Walter, of Petteworth 0
4644375 2244447 2244447 defendant Rose John   613106 613106 Rose, John, of Petteworth 0
4649909 2245991 2245991 plaintiff Warre John   613106 613106 Warre, John, of Petteworth 0
4660107 2249006 2249006 defendant Knyghton John husbandman 613106 613106 Knyghton, John, of Petteworth, husbandman 0
4683537 2260455 2260455 defendant Coggate Richard skinner 613106 613106 Coggate, Richard, of Petteworth, skinner 0
4683539 2260456 2260456 defendant Strode John gent 613106 613106 Strode, John, of Petteworth, gent 0
4686436 2261361 2261361 defendant Slyfhurst Thomas parker 613106 613106 Slyfhurst, Thomas, of Petteworth, parker 0
4697554 2264723 2264723 defendant Kynge Robert   613106 613106 Kynge, Robert, of Petteworth, mason 1
4747579 2279799 2279799 defendant Dygeley John yeoman 613106 613106 Dygeley, John, of Petteworth, yeoman 0
4759902 2283432 2283432 defendant Apsle William husbandman 613106 613106 Apsle, William, of Petteworth, husbandman 0
4768060 2285977 2285977 plaintiff Mille John   613106 613106 Mille, John, of Petteworth 0
4776959 2288780 2288780 defendant Dudlesfold Richard husbandman 613106 613106 Dudlesfold, Richard, of Petteworth, husbandman 0
4776971 2288780 2288780 defendant Weller John, junior husbandman 613106 613106 Weller, John, junior, of Petteworth, husbandman 12
4792522 2293750 2293750 plaintiff Mille John   613106 613106 Mille, John, of Petteworth 0
4792866 2293857 2293857 defendant Elkeham John husbandman 613106 613106 Elkeham, John, of Petteworth, husbandman 0
4799853 2296136 2296136 defendant atte Mulle Richard carpenter 613106 613106 atte Mulle, Richard, of Petteworth, carpenter 0
4855498 2313081 2313081 defendant Freman John sherman 613106 613106 Freman, John, of Petteworth, sherman 0
4855499 2313081 2313081 defendant Medested Richard baker 613106 613106 Medested, Richard, of Petteworth, baker 1
4872774 2318434 2318434 defendant Apsle William husbandman 613106 613106 Apsle, William, of Petteworth, husbandman 2
4876436 2319591 2319591 defendant Sherman John sherman 613106 613106 Sherman, John, of Petteworth, sherman 0
4911914 2330231 2330231 defendant Percy Henry   613106 613106 Percy, Henry, of Petteworth, knight & Earl of Northumberland & lord of the Honour of Cokermouth 0
4919648 2332649 2332649 defendant Percy Henry   613106 613106 Percy, Henry, of Petteworth, knight & Earl of Northumberland & lord of the Honour of Cokermouth 0
4922811 2333547 2333547 defendant Coggate Robert husbandman 613106 613106 Coggate, Robert, of Petteworth, husbandman 3
4922812 2333547 2333547 defendant Coggate John baker 613106 613106 Coggate, John, of Petteworth, baker 4
4937409 2338072 2338072 defendant Percy Henry   613106 613106 Percy, Henry, of Petteworth, Earl of Northumberland 0
4951212 2342344 2342344 defendant Veryng Henry husbandman 613106 613106 Veryng, Henry, of Petteworth, husbandman 0
4959460 2344794 2344794 defendant Frenche John tailor 613106 613106 Frenche, John, of Petteworth, tailor 1
4963791 2346082 2346082 defendant Veryng Henry husbandman 613106 613106 Veryng, Henry, of Petteworth, husbandman 0
4990369 2354029 2354029 defendant Fox Walter carpenter 613106 613106 Fox, Walter, of Petteworth, carpenter 0
4990372 2354030 2354030 defendant Napper John turner 613106 613106 Napper, John, of Petteworth, turner 0
5001531 2357340 2357340 defendant Quyxley John clerk 613106 613106 Quyxley, John, of Petteworth, clerk 0
5004324 2358158 2358158 defendant Veryng Henry husbandman 613106 613106 Veryng, Henry, of Petteworth, husbandman 0
5008428 2359355 2359355 defendant Sygone William husbandman 613106 613106 Sygone, William, of Petteworth, husbandman 0
5010985 2360070 2360070 defendant atte Wode William husbandman 613106 613106 atte Wode, William, of Petteworth, husbandman 0
5015521 2361426 2361426 defendant Cawe John tanner 613106 613106 Cawe, John, of Petteworth, tanner 0
5017144 2361913 2361913 defendant Bowyer William dyer 613106 613106 Bowyer, William, of Petteworth, dyer 0
5017146 2361914 2361914 defendant Bowyer William dyer 613106 613106 Bowyer, William, of Petteworth, dyer 0
5024611 2364111 2364111 defendant Sygney William yeoman 613106 613106 Sygney, William, of Petteworth, yeoman 0
5029551 2365511 2365511 defendant Chesebergh Henry husbandman 613106 613106 Chesebergh, Henry, of Petteworth, husbandman 2
5031024 2365951 2365951 defendant Hoghton John   613106 613106 Hoghton, John, of Petteworth, bed maker 4
5034685 2367000 2367000 defendant Sygony William yeoman 613106 613106 Sygony, William, of Petteworth, yeoman 1
5034690 2367001 2367001 defendant Sygony William yeoman 613106 613106 Sygony, William, of Petteworth, yeoman 1
5043597 2369705 2369705 defendant Veryng Henry husbandman 613106 613106 Veryng, Henry, of Petteworth, husbandman 1
5052753 2372418 2372418 defendant Wynard Robert yeoman 613106 613106 Wynard, Robert, of Petteworth, yeoman 0
5052754 2372418 2372418 defendant Wynard John cordwainer 613106 613106 Wynard, John, of Petteworth, cordwainer 1
5108342 2388875 2388875 defendant Aysshe Robert husbandman 613106 613106 Aysshe, Robert, of Petteworth, husbandman 2
5215744 2420330 2420330 defendant Goggate Robert yeoman 613106 613106 Goggate, Robert, of Petteworth, yeoman 0
5215745 2420330 2420330 defendant Assheton Alice   613106 613106 Assheton, Alice, of Petteworth, servant 1
5235841 2426063 2426063 defendant Trybe John baker 613106 613106 Trybe, John, of Petteworth, baker 0
5243334 2428251 2428251 defendant Mille Edmund carpenter 613106 613106 Mille, Edmund, of Petteworth, carpenter 0
5260217 2433320 2433320 defendant Sygney William husbandman 613106 613106 Sygney, William, of Petteworth, husbandman 1
5275952 2438040 2438040 defendant Eye John smith 613106 613106 Eye, John, of Petteworth, smith 0
5317231 2450234 2450234 defendant Snoden William husbandman 613106 613106 Snoden, William, of Petteworth, husbandman 5
5327995 2453440 2453440 defendant Barbour John (legal representative) 613106 613106 Barbour, John, of Petteworth, executor of 0
5328195 2453505 2453505 defendant Cawe John yeoman 613106 613106 Cawe, John, of Petteworth, 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);